IC88626: DB2PD MAY UNDER THE COVERS RUN ALL DATABASE SCOPE OPTIONS WHEN ONLY ONE OR A FEW OPTIONS WERE REQUESTED

DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• When db2pd is run with an option that retrieves a lot of data
  from the server e.g. -tcbstats or -dynamic
  it has to store the data in a local buffer before showing the
  output.
  If this initial buffer is too small, db2pd needs to reallocate
  the buffer.
  The retry logic involved in this has a problem whereby it would
  cause all database scope option of db2pd to be executed.
  This is incorrect as the retry logic should only re-execute the
  options that were passed to db2pd initially.
  
  
  A workaround exists by increasing the initial db2pd buffer size
  by setting an environment variable :  DB2PDBUFSIZE
  e.g.
  
  export DB2PDBUFSIZE=33554432
  ( 32MB )
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * all                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade the DB2 server to V10 Fix Pack 2 or above            *
  ****************************************************************
  

Problem conclusion

• This problem has first been fixed in V10 Fix Pack 2
  

Temporary fix

Comments

APAR Information

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

  IC83325

• 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

• RA10 PSN

     UP