Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2003
    Posts
    78

    Unanswered: snapshot problem

    hello all,
    to get a snapshot on a aix db2 udb 7.2 fixpack 10a server's database, what i do is:
    connect to tevr00;
    update monitor switches using bufferpool on;
    update monitor switches using statement on;
    update monitor switches using lock on;
    update monitor switches using sort on;
    update monitor switches using table on;
    update monitor switches using uow on;


    then wait for sometime(10 minutes):
    then run the commands:
    db2 connect to tevr00
    db2 get snapshot for all on tevr00

    but when i do that, many things ar not collected:

    Locks held currently = 0
    Lock waits = Not Collected
    Time database waited on locks (ms) = Not Collected
    Lock list memory in use (Bytes) = 3492
    Deadlocks detected = 0
    Lock escalations = 0

    ...........

    Total sorts = Not Collected
    Total sort time (ms) = Not Collected
    Sort overflows = Not Collected
    Active sorts = 0

    Buffer pool data logical reads = Not Collected
    Buffer pool data physical reads = Not Collected
    Asynchronous pool data page reads = Not Collected
    Buffer pool data writes = Not Collected
    Asynchronous pool data page writes = Not Collected
    Buffer pool index logical reads = Not Collected
    Buffer pool index physical reads = Not Collected
    Asynchronous pool index page reads = Not Collected

    ......................


    Number of executions = 17
    Number of compilations = 2
    Worst preparation time (ms) = 1
    Best preparation time (ms) = 1
    Internal rows deleted = Not Collected
    Internal rows inserted = Not Collected
    Rows read = Not Collected
    Internal rows updated = Not Collected
    Rows written = Not Collected
    Statement sorts = Not Collected
    Total execution time (sec.ms) = Not Collected
    Total user cpu time (sec.ms) = Not Collected
    Total system cpu time (sec.ms) = Not Collected
    Statement text = SELECT count(*) AS SAYI FROM


    ................


    we do the same things on other servers and it works, what is wrong with that one?
    is there something missing with the monitoring

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Are you doing the snapshot on the same session/window ??

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Dec 2003
    Posts
    78
    yes
    i connect throug telnet, and do all operations on the same window

  4. #4
    Join Date
    Sep 2004
    Posts
    111
    Recycling the instance will help to collect these missed informations

    -Raj

  5. #5
    Join Date
    Dec 2003
    Posts
    78
    what is recycling the instance?
    how can i do that?

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    db2stop/db2start

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  7. #7
    Join Date
    Dec 2003
    Posts
    78
    during monitoring?

Posting Permissions

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