If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Dynamic SQL Snapshot - Number of executions = 0 but Worst preparation time (ms) = 126

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-22-06, 03:13
ggnanaraj ggnanaraj is offline
Registered User
 
Join Date: Aug 2002
Location: Chennai, India
Posts: 171
Dynamic SQL Snapshot - Number of executions = 0 but Worst preparation time (ms) = 126

When taking the dynamic SQL snapshot, find some entries like the following:

Number of executions = 0
Number of compilations = 0
Worst preparation time (ms) = 126
Best preparation time (ms) = 126
Internal rows deleted = 0
Internal rows inserted = 0
Rows read = 0
Internal rows updated = 0
Rows written = 0
Statement sorts = 0
Total execution time (sec.ms) = 0.000000
Total user cpu time (sec.ms) = 0.000000
Total system cpu time (sec.ms) = 0.000000
Statement text = select count(*) from Aments where BIL = 11 and APC between '6/1/2006' and '6/1/2006' for read only

This gives rise to the following question:
When 'Number of executions' & 'Number of compilations' = 0; why is 'Worst preparation time (ms)' & 'Best preparation time (ms)' = 126?
The application that had this SQL statement was executed; but this SQL statement was not compiled & executed, however (126 * 2) ms time was spent on this SQL. Which means that the application took additional (126*2)ms time even though this SQL statement was not compiled or executed. Is my understanding right? Please clarify.

Thanks in advance.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On