IBM Support

IC77814: SNAPSHOTS, LIST APPLICATIONS AND DB2PD MAY SHOW INCORRECT STATUS FOR CERTAIN WLM APPLICATIONS.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Get Snapshot and db2pd data for applications may show the
    application status of certain WLM applications as "UOW Queued"
    when in fact they are not queued, as shown by WLM functions like
    WLM_GET_QUEUE_STATS.
    
    Here is an example:
    
    These are the queued transactions according to WLM (looks
    correct):
    
    LOW_01_SC  SYSDEFAULTSUBCL TESTER_WL  18714   0 QUEUED   TESTER
    TESTER  db-unload.impl  0
    
    LOW_01_SC  SYSDEFAULTSUBCL TESTER_WL  24020   0 QUEUED   TESTER
    TESTER  db-unload.impl  0
    
    Here is the output of LIST APPLICATIONS on the user TESTER
    showing 3 queued applications (WLM only shows 2).
    
    
    TESTER  db-unload.impl  41842  123.45.67.89.62238.110613145923
    00001 1  0  71326  UOW Queued
    
    TESTER  db-unload.impl  24315  *N0.dbedw5p.110613152112
    00001 1  0  21114  UOW Queued
    
    TESTER  db-unload.impl  23933  *N0.dbedw5p.110613152114
    00001 1  0  57934  UOW Queued
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Get Snapshot and db2pd data for applications may show the    *
    * application status of certain WLM applications as "UOW       *
    * Queued" when in fact they are not queued, as shown by WLM    *
    * functions like WLM_GET_QUEUE_STATS.                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 5.                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fix Pack 5.
    

Temporary fix

Comments

  • N/A
    

APAR Information

  • APAR number

    IC77814

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-07-28

  • Closed date

    2011-12-09

  • Last modified date

    2011-12-09

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC77814

Modified date: 09 December 2011