A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

Closed as program error.

Error description

PACKAGE TIMES FOR CLASS 8 SUSPENSIONS INCORRECT IN TABLE
DB2_PACKAGE_H.

Local fix

Problem summary

****************************************************************
* USERS AFFECTED: All users of the Tivoli Decision Support *
* for z/OS DB2 component who collect data *
* into the DB2_PACKAGE_* table. *
****************************************************************
* PROBLEM DESCRIPTION: The PKG_TOT_WAIT_SEC and SUSP_COUNT *
* columns in table DB2_PACKAGE_* *
* contain the total waiting times and *
* event counts for all class 8 *
* suspensions. Currently it is missing *
* global contention, DB2 latch and *
* TCPIP LOB XML from the totals. *
* *
* The PKG_LATCH_SEC column also needs *
* to be updated to include times for *
* both IRLM lock+latch and DB2 latch. *
****************************************************************
* RECOMMENDATION: APPLY THE PTF FIXING THIS APAR *
****************************************************************
New releases of DB2 have included new SMF fields for package
class 8 suspension times and event counts. In TDSz some of
these new fields have not been added into the totals for all
class 8 suspensions, which is contained in the
PKG_TOT_WAIT_SEC and SUSP_COUNT columns of the DB2_PACKAGE_*
table. Some of these fields such as global contention times
should also be collected into their own individual columns in
the same table.

Problem conclusion

The PKG_TOT_WAIT_SEC column in the DB2_PACKAGE_* table has been
updated to include in its total the waiting times for
global contention, DB2 latch, and TCPIP LOB XML.
The SUSP_COUNT column in the DB2_PACKAGE_* table has been
updated to include in its total the event counts for
global contention, DB2 latch, and TCPIP LOB XML.
The PKG_LATCH_SEC column in the DB2_PACKAGE_* table has been
updated to include times for both IRLM lock+latch and DB2
latch.
In addition, the following new columns have been added into
the DB2_PACKAGE_* table which detail class 8 global contention
wait times:
PKG_LLCK_TOT_SEC
PKG_LLCK_CHILD_SEC
PKG_LLCK_OTHER_SEC
PKG_PLCK_TOT_SEC
PKG_PLCK_PP_SEC
PKG_PLCK_PAGE_SEC
PKG_PLCK_OTHER_SEC
8A0Y
80AY
DRLTD2PK
DRLTD2PU