Results 1 to 5 of 5

Thread: db2top issue

  1. #1
    Join Date
    Oct 2004
    Posts
    268

    Unanswered: db2top issue

    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.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    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

  3. #3
    Join Date
    Oct 2004
    Posts
    268
    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.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    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.
    Attached Files Attached Files

  5. #5
    Join Date
    Oct 2004
    Posts
    268
    Thank you for all the info (Good stuff).
    Last edited by mdx34; 02-06-12 at 09:39.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •