PM40134: BATCH RECORD TRACE REPORTER IMPROVEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• Missing counters in IFCID 1 and IFCID 96
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Performance Expert Client                *
  *                 -   Batch Reporting                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Incorrect or misaligned fields in    *
  *                      Batch Record Trace reports for IFCIDs   *
  *                      96, 170, 230, 263, 269, 370, 371        *
  *                      2. For all lock related IFCIDs, the     *
  *                      resource name has been shown in an      *
  *                      unreadable format in case of COLLECTION *
  *                      lock types.                             *
  *                      3. New zIIP counter QWSAPSRB_zIIP was   *
  *                      missing in Batch Record Trace Reporting *
  *                      for IFCID 1                             *
  *                      4. Values are inaccurate for fields     *
  *                      COMPRESSION DICTIONARY (QW0225CD) and   *
  *                      BUFFER MANAGER STORAGE CNTL BLKS        *
  *                      (QW0225BB) in Batch Statistics LONG     *
  *                      TRACE reports. Values are inaccurate    *
  *                      for fields STACK STORAGE IN USE (MB)    *
  *                      (QW0225SUG_SYS) and SHARED NON-SYSTEM   *
  *                      AGENT STACK STORAGE (MB) (QW0225GSG)    *
  *                      in Batch Statistics LONG REPORT and     *
  *                      LONG TRACE reports.                     *
  *                      5. The field QW0124ST (statement ID)    *
  *                      has been processed incorrectly for      *
  *                      DB2 V8 and V9 subsytems. This affects   *
  *                      the PE client Thread Detail display.    *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  1. Some fields in Batch Record Trace Reports are unaligned and
  show incorrect information
  2. In case of COLLECTION locks the lock name is shown in an
  unreadable format.
  3. Missing zIIP counter QWSAPSRB_zIIP counter in IFCID 1 in
  Batch Record Trace Report
  4. Fields QW0225CD, QW0225BB, QW0225SUG_SYS and QW0225GSG are
  processed incorrectly during the generation of Batch Statistics
  reports due to the new 64 bit representation of QW0225CD and
  QW0225BB and due to inconsistent report layout definitions.
  5. Statement ID (QW0124ST) for DB2 V8/V9 is shown incorrectly
  in PE Client Thread Detail screen.
  
  PROBLEM CONCLUSION:
  1. Batch Record Trace reports for IFCIDs 96, 170, 230, 263, 269,
  370, 371 are aligned and show correct information.
  2. The lockname is shown in hex format in Batch Record Trace
  Reports for all COLLECTION locks.
  3. zIIP counter QWSAPSRB_zIIP is available in Batch Record Trace
  Report for IFCID 1.
  4. Fields COMPRESSION DICTIONARY (QW0225CD), BUFFER MANAGER
  STORAGE CNTL BLKS (QW0225BB), STACK STORAGE IN USE (MB)
  (QW0225SUG_SYS) and SHARED NON-SYSTEM AGENT STACK STORAGE (MB)
  (QW0225GSG) are processed correctly during the generation of
  Batch Statistics reports.
  5. Correct Statement ID in PE Client Thread Detail panels
  is displayed.
  

Problem conclusion

Temporary fix

Comments

• 1. Batch Record Trace reports for IFCIDs 96, 170, 230, 263, 269,
  370, 371 are aligned and show correct information.
  2. The lockname is shown in hex format in Batch Record Trace
  Reports for all COLLECTION locks.
  3. zIIP counter QWSAPSRB_zIIP is available in Batch Record Trace
  Report for IFCID 1.
  4. Fields COMPRESSION DICTIONARY (QW0225CD), BUFFER MANAGER
  STORAGE CNTL BLKS (QW0225BB), STACK STORAGE IN USE (MB)
  (QW0225SUG_SYS) and SHARED NON-SYSTEM AGENT STACK STORAGE (MB)
  (QW0225GSG) are processed correctly during the generation of
  Batch Statistics reports.
  5. Correct Statement ID in PE Client Thread Detail panels
  is displayed.
  
  KEYWORDS : BATCH RECORD TRACE, BATCH STATISTICS, COLLECTION
  LOCK, ZIIP, QWSAPSRB_ZIIP, QW0225CD, QW0225BB, QW0225SUG_SYS,
  QW0225GSG, QW0124ST, PE CLIENT
  

APAR Information

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

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

  UK69968

Modules/Macros

•    DGONF100 DGONF230 DGONF270 DGONF370 DGONF9ST
  DGONSLCK DGOVSCT2 FPEUFTDS FPEUFTS2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R510 PSY UK69968

     UP11/07/22 P F107

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.