PI06562: SQL ERROR -204 DURING REBUILD OF PWH OBJECTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following error may occur during rebuild of performance
  warehouse :
  
  FPEV5009I  SZ92
  ****************************************************************
  ****************
  FPEV5009I  SZ92 DB2 SQL operation failed:
  FPEV5009I  SZ92   SQL code ............. :   -  204
  FPEV5009I  SZ92   Detecting module ..... : DSNXISB1
  FPEV5009I  SZ92   PM Server function ... : DGOZTBL
  FPEV5009I  SZ92   SQL state ............ :    42704
  FPEV5009I  SZ92   SQL error message .... :
  FPEV5009I  SZ92
  +---------------------------------------------------------------
  -----------+
  FPEV5009I  SZ92    |  DSNT408I SQLCODE = -204, ERROR:
  DB2PM.UIX_PROCESSGROUP IS AN UNDEFINED |
  FPEV5009I  SZ92    |           NAME
  |
  FPEV5009I  SZ92    |  DSNT418I SQLSTATE   = 42704 SQLSTATE
  RETURN CODE                        |
  FPEV5009I  SZ92    |  DSNT415I SQLERRP    = DSNXISB1 SQL
  PROCEDURE DETECTING ERROR            |
  FPEV5009I  SZ92    |  DSNT416I SQLERRD    = 130  0  0  -1  0  0
  SQL DIAGNOSTIC INFORMATION    |
  FPEV5009I  SZ92    |  DSNT416I SQLERRD    = X'00000082'
  X'00000000'  X'00000000'             |
  FPEV5009I  SZ92    |           X'FFFFFFFF'  X'00000000'
  X'00000000' SQL DIAGNOSTIC           |
  FPEV5009I  SZ92    |           INFORMATION
  |
  FPEV5009I  SZ92
  +---------------------------------------------------------------
  -----------+
  
  if DB2 contains objects with the same names as PWH ones but
  having different owner
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - PWH (Host part)                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: In case a customer creates database     *
  *                      indexes having the same name than       *
  *                      indexes that are automatically managed  *
  *                      by the PWH subtask of the PE server     *
  *                      a SQLCODE -204 gets issued during       *
  *                      rebuild of PWH indexes.                 *
  *                                                              *
  *                      A PWH index rebuild happens in case     *
  *                      a customer applies maintenance or       *
  *                      forces a rebuild via MODIFY command.    *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  The SQL cursor determining which PWH indexes need to be
  rebuilt does not ignore any user defined indexes having
  the same name than PWH indexes.
  
  PROBLEM CONCLUSION:
  The SQL cursor determining which PWH indexes need to be
  rebuilt now ignores any user defined indexes having the
  same name than PWH indexes.
  
  KEYWORDS:
  PWH SQLCODE -204
  

Problem conclusion

• The SQL cursor determining which PWH indexes need to be
  rebuilt now ignores any user defined indexes having the
  same name than PWH indexes.
  
  KEYWORDS:
  PWH SQLCODE -204
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI13692 UI13693

Modules/Macros

• DGO@TBL  DGOVMSTR DGOVZAP  DGOZTBL
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R511 PSY UI13692

     UP13/12/21 P F312

• R520 PSY UI13693

     UP13/12/21 P F312

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.