PM85076: PACKAGE TIMES FOR CLASS 8 SUSPENSIONS INCORRECT IN TABLE DB2_PACKAGE_H.

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
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM85076

  • Reported component name

    TDS FOR Z/OS

  • Reported component ID

    569510100

  • Reported release

    80A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-19

  • Closed date

    2013-04-23

  • Last modified date

    2013-05-06

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

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

    UK93722 UK93723

Modules/Macros

  •    DRLTD2PK DRLTD2PU
    

Publications Referenced
SH19681911 SH19681912      

Fix information

  • Fixed component name

    TDS FOR Z/OS

  • Fixed component ID

    569510100

Applicable component levels

  • R8A0 PSY UK93722

       UP13/04/25 P F304

  • R80A PSY UK93723

       UP13/04/25 P F304

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.



Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Decision Support for z/OS

Software version:

80A

Reference #:

PM85076

Modified date:

2013-05-06

Translate my page

Machine Translation

Content navigation