PI06009: CHANGES TO TDSZ PROCESSING FOR DB2 PACKAGE ROLLUP FOR DB2 V10 AND ABOVE.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• APAR to change the TDSz processing for DB2 package rollup in DB2
  and above.
  1. When QPACROLL is set, the package name will be QPACPKID (or
  QPACPKID_VAR if QPACPKID_OFF is set
  2. When QPACRUSM is set, then a summary rollup record is
  present. The package name will be set to *ROLSUM*
  3. When processing a DB2 v9 (or below) record, processing will
  remain as it is currently (*ROLLUP* for rollup records)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IBM Tivoli Decision Support for z/OS     *
  *                 users who collect DB2 package statistics     *
  *                 from the SMF_101_1 record into the DB2       *
  *                 component.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 v10 two new flags were created   *
  *                      in QPACFLGS called QPACROLL and         *
  *                      QPACRSUM. These flags show that the     *
  *                      record being processed is a rollup      *
  *                      record or a rollup summary record.      *
  *                      TDSz needs to be modified to use these  *
  *                      flags when doing its package            *
  *                      processing for DB2 v10+ logs so that    *
  *                      these records are processed correctly   *
  *                      by TDSz into the DB2_PACKAGE_* tables.  *
  ****************************************************************
  * RECOMMENDATION: APPLY THE PTF FIXING THIS APAR               *
  ****************************************************************
  TDSz is not processing package names correctly in DB2 v10 and
  above. To determine whether the record is a rollup record
  or rollup summary record TDSz needs to be modified to check
  the QPACROLL and QPACRSUM flags within QPACFLGS. The package
  name then needs to be set to either the appropriate package
  name for the rollup, or *ROLSUM* in the case of a rollup
  summary record.
  

Problem conclusion

Temporary fix

Comments

• TDSz definitions member DRLTD2PU has been modified to change
  the way package rollup records and package rollup summary
  records are determined. For DB2 v10 and above, QPACFLGS is used
  to determine if QPACROLL or QPACRUSM is set. If QPACROLL is set
  then the record is a rollup record and the package name is
  set to the package name in the record. If QPACRUSM is set then
  the record is a rollup summary record, and the package name
  is set to *ROLSUM*. Package name processing in TDSz has not
  changed for DB2 v9 and below.
  

APAR Information

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

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

  UI13552 UI13553 UI13554 UI13555

Modules/Macros

• DRLRS101 DRLTD2PU
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• R8A0 PSY UI13554

     UP13/12/17 P F312

• R80A PSY UI13555

     UP13/12/17 P F312

• R801 PSY UI13552

     UP13/12/17 P F312

• R810 PSY UI13553

     UP13/12/17 P F312

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.