By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

CPU Time (User / System) & Actual Elapsed Time for SQL

P: n/a
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

Mar 2 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.