PM26124: INVALID PROCESSING OF QXSTLOBV QXCASCDP QXSTXMLV(V420) in ACCOUNTING REPORT ,SAVE, AND PDB/PWH's DB2PMSACCT_GENERAL TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The externalization of the calculated values is not suitable to
  the field definitions of the DB2 counters QXSTLOBV, and
  QXCASCDP.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Batch Reporting                          *
  *                 -   Performance Database users               *
  *                 -   Performance Warehouse users              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Some maximum fields might show          *
  *                      incorrect values in Accounting long     *
  *                      REPORT. The DB2 counters are            *
  *                      QXCASCDP, QXSTLOBV, and QXSTXMLV.       *
  *                                                              *
  *                      Some PDB/PWH columns might contain      *
  *                      incorrect values in DB2PMSACCT_GENERAL  *
  *                      table. The column names are             *
  *                      MAX_SQL_CASCAD_LVL, and                 *
  *                      MAX_STOR_LOB_VALUE.                     *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  Possibly some incorrect maximum values in Accounting long
  REPORT, and in some columns in PDB/PWH's DB2PMSACCT_GENERAL
  table.
  
  PROBLEM CONCLUSION:
  The processing of the fields has been changed.
  

Problem conclusion

• The processing of the fields has been changed.
  
  KEYWORDS :
  QXCASCDP QXSTLOBV QXSTXMLV MAX SQL CASC LVL MAX STOR LOB VALUES
  MAX_SQL_CASCAD_LVL MAX_STOR_LOB_VALUE MAX STO LOB VAL (KB)
  

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:

  UK62248 UK62249

Modules/Macros

• DGOABORD DGOABORE DGOACALC DGOACMER DGOACOMP
  DGOACREC DGOADIST DGOAEXIT DGOAEX20 DGOAIREC DGOAMTRC DGOAREDB
  DGOAREDC DGOAREDD DGOAREDG DGOAREDM DGOAREDP DGOAREDR DGOAREDX
  DGOASAVE DGOATRAC DGOATREC 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 DGOPACNV DGORAEXT DGORIREP
  DGORPACC DGORUACC DGORZREP FPEUCBPR
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK62248

     UP10/11/23 P F011

• R420 PSY UK62249

     UP10/11/23 P F011

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.