Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC83325 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem 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 )
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* all                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade the DB2 server to V9.7 Fix Pack 7 or above           * 
****************************************************************
Local Fix:
available fix packs:
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

Solution
This problem has first been fixed in DB2 V9.7 Fix Pack 7
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC87892 IC88626 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
10.05.2012
30.10.2012
30.10.2012
Problem solved at the following versions (IBM BugInfos)
9.7.FP7
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.7 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.