home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IC73187 Status: Closed

INCORRECT COLUMN HEADERS IN DB2PD -TRANSACTIONS OUTPUT

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
In db2pd -transactions output, the column for LogSpace and 
SpaceReserved are described & displayed incorrectly. 
For example: 
 
AppHandl TranHdl  Locks          Firstlsn 
  Lastlsn             LogSpace  SpaceReserved 
84              24        29      0x000000000909CD4A 
0x000000000909E61C  7304      13711 
 
They are described in the documentation as follows: 
 
LogSpace 
The amount of log space that is reserved for the transaction. 
SpaceReserved 
The total log space that is reserved for the transaction, 
including the used space and all compensation records. 
 
The titles of the LogSpace and SpaceReserved columns do not 
match with their the descriptions -- they should be switched. 
Output from db2pd   is displayed correctly according to the 
descriptions but not the titles. For instance, the value of 7304 
actually represents the reserved space -- who's description 
currently matches what we describe for LogSpace. 
 
Also, the description for LogSpace and SpaceReserved will be 
updated on Info Center as follow: 
 
SpaceReserved 
The amount of log space that is reserved for the transaction. 
LogSpace 
The total log space that is required for the transaction, 
including the used space and the reserved space for compensation 
log records.
Problem Summary:
Local Fix:
available fix packs:
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

Solution
Workaround
not known / see Local fix
Comment
This is an update to db2pd tool output and info center for 
accurate description.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
10.12.2010
08.12.2011
08.12.2011
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.5 FixList