|
Problem IC73308
|
Status: Closed |
DB2PD -STACK ON SOLARIS SLOWS DOWN PERFORMANCE, PRODUCES MISLEADING DIAGNOSTICS DUE TO PROCESS MEMORY MAP COLLECTION |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - 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: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* see ERROR DESCRIPTION *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.5 Fix Pack 8. *
**************************************************************** |
| Local Fix: |
When the db2pd -stack command is required, t 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. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 9.5 Fix Pack 8. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC73323 IC73324 IC73325
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.12.2010
29.08.2011
29.08.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
