DB2 FOR LUW / DB2FORLUW / 970 - DB2

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 )

**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the DB2 server to V9.7 Fix Pack 7 or above           * 
****************************************************************

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
 

This problem has first been fixed in DB2 V9.7 Fix Pack 7

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC87892 IC88626 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

10.05.2012
30.10.2012
30.10.2012

9.7.FP7