DB2 V9.5 FP7 - RHL Linux 6.2


I am testing db2top in batch mode with the following command which creates

db2snap-MYDB1-Linux64.bin file (I don't know why).

db2top -d MYDB1 -C -i 30 -b l -X -o db2top.xml -m 3


As you can see, I set the snapshot for 30 seconds for 3 minutes duration. When I review the file, I just select b (Buffer pools) or m (memory) but it stays up for 1 minute then it closes with the message of

*** End of input stream reached, size was 5.1M...

How am I supposed to see the rest of the 2 minutes ?


Thanks for any help.

I noticed the same when I was viewing db2top output and trying to compare it with what db2pd captured.

I just tried again and got:

*** End of input stream reached, size was 896.4K...
Exiting...


The size matches the output file:
-rw------- 1 db2inst1 db2grp1 917932 Feb 02 15:02 db2top.out.20120202.150220


So, it gives this message when it reaches the end of file.


But the time it stays up is not consistent. When viewing the same file, 1st time it stayed up for ~1 min and then existed, other times it stayed up longer. Not sure why that is.


I use the following command to collect db2top output:
db2top -d xxxxx -C -i 60 -m 1 -f $SNAP/db2top.out

And use "db2top -f <file name>" to view it.


Check this article, you might find some helpful info:
DB2 problem determination using db2top utility

Thank you for your response. I am doing exactly the sameting. I have this problem on a 64 bit server and not on 32 bit server.

Luckily, I can copy the result from 64 bit Linux server to 32 bit server and view it there correctly.

I am choosing 30 secondsfor the intervals between the snapshots. I don't know what to pick as interval value for the stress test we have this evening. May be I will leave the default 2 seconds. Any recommendations ?

Thanks again.

I ran db2top on v9.1 / AIX (didn't try on RHEL). I scheduled it in crontab, but I don't rely on db2top info and also collect snapshots/db2pd as well as some OS info. I'd suggest capturing snapshots and/or db2pd in addition to db2top.

Attached is what I collect.

Thank you for all the info (Good stuff).