PK17992: DB2PE PERFORMANCE DATABASE LOAD VALUE IN CLASS1_SU_CPU INTEGER -1748973075

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The db2pm db2pe performance database function with a load into
  table DB2PMFACCT_GENERAL.
  User value (of service units) exceeding INTEGER limit - it
  normal for long running batches
  Corresponding column in ACCOUNTING table is INTEGER so ERROR
  as original value is not possible to be inserted into column.
  The loading Accounting table giving no error information
  truncates inserting WRONG data.
  SELECT CLASS1_SU_CPU, SUBSYSTEM_ID, PRIMAUTH
  FROM DB2PMFACCT_GENERAL
  ---------+---------+---------+---------+---------+---------+-
  CLASS1_SU_CPU  SUBSYSTEM_ID  PRIMAUTH
  ---------+---------+---------+---------+---------+---------+-
    -1748973075  DBP4          YW5XX1
  DSNE610I NUMBER OF ROWS DISPLAYED IS 1
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM V310            *
  *                 users of component:                          *
  *                 -  Batch Reporting                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: For batch accounting jobs taking over   *
  *                      2 150 000 000 (more than max integer)   *
  *                      Service Units incorrect results appear  *
  *                      (including negative values) in tables   *
  *                      like DB2PMFACCT_GENERAL, as the value   *
  *                      for fields ADSUCPU1 (CPU time for       *
  *                      class 1 in service units),              *
  *                      adsutcs1, adsunn1, adsutcu1, adsucpp1,  *
  *                      adsucpu2, adsunn2, adsutcs2, adsutcu2,  *
  *                      adsutct2, adsucpp2,          adsucpu7,  *
  *                      adsutcb7, adsucpp7  are declared in     *
  *                      accounting table and  file created for  *
  *                      load purpose (via FILE control          *
  *                      statement)  as INTEGER. So real value   *
  *                      (taken from SMF) is truncated without   *
  *                      any warnings.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Define correct data type of these fields (decimal) in tables
  like: DB2PMFACCT_GENERAL and DB2PMFACCT_PROGRAMM
  SYSMOD TITLE:  DB2PMFACCT_GENERAL
  KEYWORDS: DB2PMFACCT_GENERAL
  

Temporary fix

Comments

APAR Information

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

  PK11297

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

  UK13024

Modules/Macros

•    DGOABFGE DGOABFPK DGOABORD DGOABORE DGOACALC
  DGOACFGE DGOACFPK DGOACMER DGOACOMP DGOACREC DGOADFGE DGOADFPK
  DGOADIST DGOAEXIT DGOAEX20 DGOAFGEN DGOAFILE DGOAFPCK DGOAIREC
  DGOALFGE DGOALFPK DGOAMSGS DGOAMTRC DGOAREDB DGOAREDC DGOAREDD
  DGOAREDG DGOAREDM DGOAREDP DGOAREDR DGOAREDX DGOARXIT DGOATRAC
  DGOATREC DGOAUPDB DGOAZMER DGOAZREC DGOBARDD DGOBARLK DGOBARLO
  DGOBARPK DGOBARPO DGOBARPT DGOBARRI DGOBARRL DGOBARSH DGOBARSP
  DGOBARSQ DGOBARTE DGOBARTM DGOBATDD DGOBATLK DGOBATLO DGOBATPK
  DGOBATPO DGOBATPT DGOBATRI DGOBATRL DGOBATSH DGOBATSP DGOBATSQ
  DGOBATTM DGOBGENL DGOFPRIC DGORAEXT DGORIREP DGORPACC DGORUACC
  DGORZREP FPEUCBPR FPEUFFER FPEUFFE2 FPEUFIOI FPEUFIO2 FPEUFOCR
  FPEUFOC2 FPEUFUIS FPEUFUIT FPEUFUNI FPEUFUN2 FPEUFWMG FPEUFWMX
  FPEUFYDY FPEUFYD2 FPEUFYLD FPEUFYST FPEUFYS2 FPEUIFCI FPEUIFC2
  FPEUMSGS
  

Fix information

• Fixed component name

  OM XE DB2PE/PM/

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK13024

     UP06/03/31 P F603

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.