IC74998: DB2PD WITH FULL DATABASE SCOPE OPTIONS ONLY DUMPS ANCHOR ID 0 FOR DYNAMIC SQL CACHE

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• In version 9.7, the db2pd -dynamic command allows specification
  of anchor ID
     -dynamic [anch=<AnchId>] [file=<filename>]
        Dynamic Cache
  
  The default it to dump all information from the dynamic
  statement cache, i.e. for all anchors.  This works when
  explicitly specifying -dynamic option, but when requesting all
  database scope options ( -eve or -db <database> with no specific
  option ), only the information for anchor 0 is returned, so
  there is a lot of missing information.  This is especially
  important for FODC data collections for diagnosing more severe
  DB2 problems.
  

Local fix

• Issue the -dynamic option explicitly in order to get full
  information from the dynamic statement cache.
     db2pd -db <db> -dynamic
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All DB2 Server systems                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * See Local Fix                                                *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in DB2 Version 9.7 Fix Pack 5
  

Temporary fix

• See Local Fix
  

Comments

APAR Information

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

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

Modules/Macros

• pd
  

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• R970 PSN

     UP