|
Problem IC88626
|
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 / A10 - 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 V10 Fix Pack 2 or above *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
This problem has first been fixed in V10 Fix Pack 2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.11.2012
11.02.2013
11.02.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.2
|
 |
| 10.5.0.2
|
|
