|
Hi,
ENV: DB2 ESE 8.2.3 DPF (11 nodes) on AIX 5.x
====
SCENARIO / SETUP
======== ======
(1) I needed to find out CPU Time (User / System) of SQL queries for
benchmark testing.
(2) I setup an EVENT MONITOR WHERE AUTH_ID = 'ANURAG'
(write to table).
(3) I set event monitor state to 1 and from another session executed 1
SQL query at a time (having connected to database with user
'ANURAG'). All this while, I am directly logged on to the server.
(4) After I received the complete results (41 million rows), I flushed
event monitor buffer and set its state to 0.
(5) Here are some actual results that baffle me:
(a) System CPU Time = 1.15 seconds
(b) User CPU Time = 21.83 seconds
(c) Elapsed Time = 84627 seconds
(calculated from 'start_time' and 'stop_time')
QUESTION / HELP SOUGHT
======================
(1) The query actually returned the results in some 9 hours; how can
this figure be related to the event monitor output?
(2) Is there any way where I can find out the actual time of resultset
return from DB2 facilities?
I am unable to relate the CPU Time, Start/Stop Time with the 9 hours
elapsed. Results for other SQLs were similarly mindboggling.
Pl help me understand the output
(we will leave performance improvements for later :-)
Regards,
Anurag
| 
