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 IC73324 Status: Closed

DB2PD -STACK ON SOLARIS SLOWS DOWN PERFORMANCE, PRODUCES MISLEADING
DIAGNOSTICS DUE TO PROCESS MEMORY MAP COLLECTION

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
The process memory map collection performed on Solaris during 
the db2pd -stack command has been improved in version 9.5 Fix 
Pack 6 and version 9.7 Fix Pack 2.  It is no longer triggering 
severe hang symptoms. 
However, it still may take a relatively long time (eg. 30 
seconds on some symptoms), and causes some contention with other 
memory operations on the DB2 server. 
 
Since it is intrusive and may lead to misleading diagnostics, it 
will be removed from the diagnostics collected in db2pd -stack. 
The information is rarely needed, and can be collected by the 
native Solaris pmap <process> command, which is much quicker and 
less intrusive.  The pmap command will be added to the db2fodc 
-perf and -hang data collections.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2/Solaris systems                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 5 to retain diagnostic   * 
* capability of db2pd -stack                                   * 
****************************************************************
Local Fix:
When the db2pd -stack command is required, it is recommended to 
substitute the following: 
db2pd -latches 
pstack <db2sysc process ID> 
pmap <db2sysc process ID> 
 
If running db2fodc -perf or -hang, modify the appropriate 
sqllib/bin/db2cos_hang or db2cos_perf scripts to use the 
alternate commands.
Solution
Problem first fixed in DB2 Version 9.7 Fix Pack 5
Workaround
see Local Fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
16.12.2010
02.05.2012
02.05.2012
Problem solved at the following versions (IBM BugInfos)
9.7.FP5
Problem solved according to the fixlist(s) of the following version(s)