PI74817: PWH ACCOUNTING TABLE LOAD FAILURE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Unable to load PWH accounting tables.  Error received:
  DSNU320I -DC61 263 16:56:29.41 DSNURWI - RESUME(YES) WAS
  SPECIFIED FOR EMPTY TABLESPACE DSNU334I
  DC61 263 16:56:29.53 DSNURCON - INPUT FIELD
  'CLASS1_ELAPSED',INVALID FOR 'DB2PM.DB2PMSACCT_GENERAL',
  ERROR CODE '04 - INPUT PACKED DECIMAL IS IN ERROR'
  DSNU302I -DC61 263 16:56:29.53 DSNURWBF - (RE)LOAD PHASE
  STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=1
  DSNU017I 263 16:56:29.56 DSNUGBAC - UTILITY DATA BASE SERVICES
  MEMORY EXECUTION ABENDED, REASON=X'00E40323'
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2M Users.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Load of performance warehouse tables    *
  *                      fails with MSGDSNU332 or MSGDSNU334 and *
  *                      possible ABEND04E RSN00E40323.          *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  DB2 LOAD utility control statements generated by DB2PE to
  populate performance warehouse (PWH) accounting tables do    not
  accurately reflect changes made to the SAVE format data  used as
  the input.  This causes the DB2 LOAD to fail due to  multiple
  reasons.  Most commonly, the error messages indicate that a
  field is out of range or not in the correct format.   These
  errors typically result in MSGDSNU332 or MSGDNSU334. In
  addition, MSGDSNU053 with RC8 may occur depending on how the PWH
  tables were created.
  

Problem conclusion

• The code that generates the DB2 LOAD utility control statements
  has been corrected.
  

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:

  UI47745

Modules/Macros

•    DGOZLD10 DGOZLD11 DGOZLD6  DGOZLD7  DGOZLD8
  DGOZLD9
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI47745

     UP17/06/03 P F706

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.