|
Problem IC66127
|
Status: Closed |
DB2TOP EXITS WITHOUT SHOWING ANY DATA WHEN PLAYING WITH COLLECTED FILE IN REPLAY MODE |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
DB2TOP exits without showing any of the data collected:
-------------start collection-----------------
db2top -d gp001001 -f /tmp/collect.bin.3 -C -m 10 -P 1
[03:45:14] Starting DB2 snapshot data collector, collection
every 2 second(s), max duration 10 minute(s), max file
growth/hour 100.0M, hit <CTRL+C> to cancel...
[03:45:17] Writing to '/tmp/collect.bin.3', should I create a
named pipe instead of a file [N/y]? N
[03:45:23] Creating '/tmp/collect.bin.3' as a normal file
[03:45:23] Increasing snapshot interval from 2 to 7 to limit
volume of collection
[03:45:30] 9.1M written, time 16.093, 2.0G/hour
[03:50:54] Increasing snapshot interval from 7 to 11 to limit
volume of collection
[03:51:05] 18.3M written, time 350.987, 189.1M/hour
[03:55:23] Max duration reached, 18.3M bytes, time was
608.780...
[03:55:23] Snapshot data collection stored in
'/tmp/collect.bin.3'
Exiting...
----------------------replay
mode-----------------------------------------
$ db2top -d gp001001 -f /tmp/collect.bin.3 -b l -A -P 1
*** End of input stream reached, size was 19279506...
No performance data to analyze for option 'l'
Exiting...
Problem is because the stream size limit is 100M/hour.
The above output show that db2top is estimating at
[03:51:05] the collection rate is 189.1M/hour and db2top
collected 18.3M in
about 10 minutes. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2TOP exits without showing any of the data collected: *
* *
* *
* *
* -------------start collection----------------- *
* *
* db2top -d gp001001 -f /tmp/collect.bin.3 -C -m 10 -P 1 *
* *
* [03:45:14] Starting DB2 snapshot data collector, collection *
* every 2 second(s), max duration 10 minute(s), max file *
* *
* growth/hour 100.0M, hit <CTRL+C> to cancel... *
* [03:45:17] Writing to '/tmp/collect.bin.3', should I create *
* a named pipe instead of a file [N/y]? N *
* *
* [03:45:23] Creating '/tmp/collect.bin.3' as a normal file *
* *
* [03:45:23] Increasing snapshot interval from 2 to 7 to limit *
* volume of collection *
* *
* [03:45:30] 9.1M written, time 16.093, 2.0G/hour *
* [03:50:54] Increasing snapshot interval from 7 to 11 to *
* limit volume of collection *
* *
* [03:51:05] 18.3M written, time 350.987, 189.1M/hour *
* *
* [03:55:23] Max duration reached, 18.3M bytes, time was *
* 608.780... *
* *
* [03:55:23] Snapshot data collection stored in *
* '/tmp/collect.bin.3' *
* *
* Exiting... *
* *
* *
* *
* ----------------------replay *
* mode----------------------------------------- *
* *
* $ db2top -d gp001001 -f /tmp/collect.bin.3 -b l -A -P 1 *
* *
* *** End of input stream reached, size was 19279506... *
* *
* No performance data to analyze for option 'l' *
* *
* Exiting... *
* *
* *
* *
* *
* *
* *
* *
* Problem is because the stream size limit is 100M/hour. *
* *
* *
* *
* The above output show that db2top is estimating at *
* *
* [03:51:05] the collection rate is 189.1M/hour and db2top *
* collected 18.3M in about 10 minutes. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V9.1 Fixpack 10 *
**************************************************************** |
| Local Fix: |
If problem happens in replay mode, increase stream size by
adding streamsize=###M to .db2toprc file and rerun.
To estimate the size to of 'streadmsize' to use in .db2toprc use
the info from the previous attempt.
In the example above it shows 18.3M within 10 minutes.
Estimate the streamsize by taking the 18.3M * 6=110M/hour. Since
the volume
of captured snapshot data can flucturate leave a big margin
size. Increase 4-5 times the
size estimated. In this case set streamsize=500 in .db2toprc
file |
| available fix packs: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
Fixed in V9.1 Fixpack 10 |
| Workaround |
If problem happens in replay mode, increase stream size by
adding streamsize=###M to .db2toprc file and rerun. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC71637 IC71638 IC71639
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.02.2010
07.07.2011
07.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
