snapshot problem

shedb · #1 (**permalink**) 09-08-04, 03:01

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