IBM Support

PK47366: GARBAGE IN COLL AND PKG FIELDS OF APPLICATION TRACE EVENT DETAILSCREEN.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • COLL and PKG fields of ATF EVENT DETAIL screen contain incorrect
    values
    
    
    >                        APPLICATION TRACE EVENT
    DETAIL
    
    ATD3
    
    
      Planname=DSNESPCS   Connid=TSO        Corrid=BG0TLE
    Authid=BG0T
    
    
    
    :  Control= NEXT     (FIRST/LAST/NEXT/PREV/ nnnn/-
    nnnn/Snnnn/TOP/BOTTOM/U
      Current=000001  Total Number of SQL
    Calls=000046
    
    
    
      Event Time   TN Event Type            Event Resource
    Information
      ------------ -- ---------------------
    ----------------------------
    
    -----
      13:43:57.109    LOCK ACQUIRE          PLAN=DSNESPCS
    SKCT S
      13:43:57.110    CREATE
    THREAD
      13:43:57.140    LOCK ACQUIRE          COLL=.. ..&........ ..(
    SKPT S
                                            PKG=.. ..(..
    TOKEN=149EEA901A79FE
      13:43:57.140    START PREPARE         PGM=DSNESM68
    STMT=00134
      13:43:57.140    END PREPARE           ROWS=0000000
    PAGES=0000000
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
    *                 users of component:                          *
    *                 -   Classic Interface                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: SKPT lock details are garbled on ATF    *
    *                      displays.                               *
    ****************************************************************
    * RECOMMENDATION: Apply this PTF                               *
    ****************************************************************
    PROBLEM SUMMARY:
    The COLLECTION and PACKAGE information associated with the
    SKPT lock type is not displayable for DB2 V8 and above.
    
    PROBLEM CONCLUSION:
    For DB2 V8 and above, change the display for SKPT locks.
    Display the TOKEN= value. This is the consistency token
    (CONTOKEN) column in SYSPACKAGES.
    

Problem conclusion

  • For DB2 V8 and above, change the display for SKPT locks.
    Display the TOKEN= value. This is the consistency token
    (CONTOKEN) column in SYSPACKAGES.
    
    KEYWORDS : SKPT  CONTOKEN  SYSPACKAGES  ATF
               COLLECTION PACKAGE  DB2 V8
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK47366

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    410

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2007-06-19

  • Closed date

    2008-04-04

  • Last modified date

    2017-02-04

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

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

    UK35253 UK35254

Modules/Macros

  •    KO2ACAPS KO2ACAP2 KO2ARSBA KO2ARSBS KO2ARSB2
    KO2ASUBA KO2ASUBS KO2ASUB2 KO2ATRCB KO2XLKDS KO2XLKD2
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R310 PSY UK35253

       UP08/04/07 P F804

  • R410 PSY UK35254

       UP08/04/07 P F804

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 February 2017