PM11304: TS DB2PM.PROCESS is left in CHKP status during PWH 4.2 upgrade wcauses SQL -204 error

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• During upgrade OMEGAMON DB2 PE system from 4.1 to 4.2,
  tablespace DB2PM.PROCESS is left in CHKP status and as
  consequence update of DB2PM database failed with SQL error code
  -204.
  

Local fix

• Start the OMPE Server Started Task for each DB2 subsystem
  individually, without any other DB2 subsystems being monitored.
  1) in RKD2PAR(D2OMO2):
     a) place an "*" in front of EXEC STRTOA and EXEC STRTNTH,
        to comment these out and turn off Object Analysis
        and Near Term History.
     b) place an "*" in front of all RVTMxxxx members
        (where xxxx is the DB2  subsystem ID) except the DB2
        subsystem you're working with, so no other DB2s will
        be monitored.
  2) in RKD2PAR(OMPEMSTR) set AUTODETECT=N
  3) in RKD2PAR(OMPEyyyy) - where yyyy is the DB2 subsystem:
     a) comment out all statements starting with "AUTOEXCP",
        except leave AUTOEXCPFILE=N
     b) set PERFORMANCEWAREHOUSE=F to force a migration.
  
  This should ensure no interference from any other processing.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Performance Warehouse users              *
  ****************************************************************
  * PROBLEM DESCRIPTION: After or during migrating from OMEGAMON *
  *                      XE for DB2 PE V4.1.0 to OMEGAMON XE for *
  *                      DB2 PE V4.2.0 a table space of the      *
  *                      DB2PM database is left in CHKP state.   *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  SQL error code -204 is detected during or after the PWH
  migration step because a table space of the database
  DB2PM is put in CHKP state.
  
  PROBLEM CONCLUSION:
  The code of the Performance Warehouse has been modified to
  reset detected pending state CHKP and retry corresponding
  steps of the database updating process.
  

Problem conclusion

• The code of the Performance Warehouse has been modified to
  reset detected pending state CHKP and retry corresponding
  steps of the database updating process.
  
  KEYWORDS : CHKP -204  PERFORMANCE WAREHOUSE
  

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:

  UK66456

Modules/Macros

•    DGO@TBL  DGOVMSTR DGOZTBL
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R420 PSY UK66456

     UP11/04/05 P F104

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.