Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
About SQL Service Time

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
wicherc

New User


Joined: 16 Nov 2011
Posts: 2
Location: Argentina

PostPosted: Sat Apr 28, 2012 12:03 am    Post subject: About SQL Service Time
Reply with quote

I´m new at this skill for DB2 and working with Freeze Frame tools. Excusme if this question is for a child. icon_redface.gif
At a new report from a COBOL/DB2 program we found large time in a SQL statement (SELECT) This tool reports the following data:
Mean CPU Time: 0.00369sg
Mean Svc Time: 0.17625sg
I supose here there is a problem with this sentence, but i can´t understand what is the diference betwen CPU Time and Service Time.
Can anybody help me?
Thanks.
Back to top
View user's profile Send private message

Pedro

Senior Member


Joined: 01 Sep 2006
Posts: 2088
Location: Silicon Valley

PostPosted: Sat Apr 28, 2012 2:21 am    Post subject: Reply to: About SQL Service Time
Reply with quote

You need to look at the documentation for "Freeze Frame".

This is only a guess...
1. service time sounds like elapsed time, from start to finish of the query. Perhaps, as if you had a stop watch and could measure so tiny an interval. On a large system, DB2 might be doing work for thousands of people at roughly the same time. The more work there is, the longer the elapsed time takes.

2. CPU time is the amount of time to execute the program. Assuming no changes to the data, the CPU time should remain fairly constant. It is a measurement of the CPU time needed to run your query, not including waiting for other tasks that are competing for computer resources.
Back to top
View user's profile Send private message
wicherc

New User


Joined: 16 Nov 2011
Posts: 2
Location: Argentina

PostPosted: Wed May 02, 2012 8:02 pm    Post subject:
Reply with quote

Pedro: Thanks for your response. I was looking for in all the Freeze Frame docs but nothing appears qith this concept.
I supose that Service Time is more close to the DB2 engine and of course, to the cpu work load. May be the ET taken by DB2.
Thanks again
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Comparision with current time arunsoods DFSORT/ICETOOL 5 Thu Nov 09, 2017 10:37 am
This topic is locked: you cannot edit posts or make replies. Comparing current time with the time ... arunsoods SYNCSORT 1 Mon Oct 30, 2017 4:07 pm
This topic is locked: you cannot edit posts or make replies. Incrementing current time field by 30... arunsoods DFSORT/ICETOOL 11 Thu Oct 26, 2017 3:22 pm
This topic is locked: you cannot edit posts or make replies. 00D3003B - time outs in DB2 when invo... chavinash2004 DB2 2 Mon Oct 09, 2017 4:39 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us