PM83029: DSNT408I SQLCODE = -204, ERROR: DB2PM.EPOCH IS AN UNDEFINED NAME DURING PWH REBUILD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following error may occur during rebuild of Performance
  Warehouse
  
  0FPEV5009I  D1AS
  ****************************************************************
  ****************
  0FPEV5009I  D1AS DB2 SQL operation failed:
  0FPEV5009I  D1AS   SQL code ............. :   -  204
  0FPEV5009I  D1AS   Detecting module ..... :  DSNXOFE
  0FPEV5009I  D1AS   PM Server function ... : DGOZVW1
  0FPEV5009I  D1AS   SQL state ............ :    42704
  0FPEV5009I  D1AS   SQL error message .... :
  0FPEV5009I  D1AS
  +---------------------------------------------------------------
  -----------+
  0FPEV5009I  D1AS    |  DSNT408I SQLCODE = -204, ERROR:
  DB2PM.EPOCH IS AN UNDEFINED NAME       |
  0FPEV5009I  D1AS    |  DSNT418I SQLSTATE   = 42704 SQLSTATE
  RETURN CODE                        |
  0FPEV5009I  D1AS    |  DSNT415I SQLERRP    = DSNXOFE SQL
  PROCEDURE DETECTING ERROR             |
  0FPEV5009I  D1AS    |  DSNT416I SQLERRD    = -200  0  0  -1  0
  0 SQL DIAGNOSTIC INFORMATION   |
  0FPEV5009I  D1AS    |  DSNT416I SQLERRD    = X'FFFFFF38'
  X'00000000'  X'00000000'             |
  0FPEV5009I  D1AS    |           X'FFFFFFFF'  X'00000000'
  X'00000000' SQL DIAGNOSTIC           |
  0FPEV5009I  D1AS    |           INFORMATION
  |
  0FPEV5009I  D1AS
  +---------------------------------------------------------------
  -----------+
  0FPEV5009I  D1AS   User action .......... :
  0FPEV5009I  D1AS
  +---------------------------------------------------------------
  -----------+
  0FPEV5009I  D1AS    | SEE 'DB2 UDB FOR Z/OS MESSAGES AND CODES'
  FOR                            |
  0FPEV5009I  D1AS    | DETAILS ABOUT THIS SQLCODE.
  |
  0FPEV5009I  D1AS
  +---------------------------------------------------------------
  -----------+
  0FPEV5009I  D1AS
  ****************************************************************
  ****************
  0FPEV5004S  D1AS DATABASE UPDATE FAILED. SEE JOB LOG FOR DETAILS
  0FPEV5002I  D1AS PWH IS STOPPING
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Performance Warehouse users              *
  ****************************************************************
  * PROBLEM DESCRIPTION: During PWH startup an error is          *
  *                      shown when deleting a view that is no   *
  *                      longer existing.                        *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  An error is shown during PWH startup, if already deleted
  views are trying to be deleted again.
  
  PROBLEM CONCLUSION:
  In case a view has already been deleted, no errors are shown
  and PWH can be started.
  

Problem conclusion

• In case a view has already been deleted, no errors are shown
  and PWH can be started.
  
  KEYWORDS : PWH SQLCODE -204 DB2PM EPOCH IS AN UNDEFINED NAME
  

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:

  UK93110

Modules/Macros

•    DGO@VW1  DGO@VW2  DGOVMSTR DGOVZAP  DGOZVW1
  DGOZVW2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R511 PSY UK93110

     UP13/04/05 P F304

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.