about snapshot monitor

[%NAME%]

Hi,

When collecting snapshot, there is seemingly discrepency between query
running time and some metrics collected.

For example, on a DPF with 8 nodes, I have 8863201 seconds for
"Total buffer pool read time (milliseconds)" from running "db2 get
snapshot for all on bcudb global"

Then without the "global" option, on each node, there is around
1110000 -- 1120000 milisec for the same metric, e.g. "Total buffer
pool read time (milliseconds) = 1119828"

However, the query itself only runs less than 200 seconds, which is
only 1/5 of the time for "total buffer pool read time" on each node.
How could this be? The snapshot before running the query shows close
to 0 seconds, e.g. "Total buffer pool read time (milliseconds) =
203", so there should be no error.

I guess they multiplied this time with number of prefetchers?

Huaxin

[Udo]

> I guess they multiplied this time with number of prefetchers?

You are right. From the System Monitor Guide:

> At the database and table space levels, this element includes the value of pool_async_read_time. <

see http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0001241.htm

Regards,
Udo

--
Speedgain for DB2 - the DB2 monitor
http://www.itgain.de/en/produkte/speedgain.html