Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 2051
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 RDz Json restful service Kevin Vaz IBM Tools 4 Thu Jun 29, 2017 10:44 pm
No new posts DSNACCOX (can it be run on 1 db/ts, t... SRICOBSAS DB2 5 Sat May 06, 2017 12:59 am
No new posts LISTIDR compiled date/time jerryte IBM Tools 3 Thu Apr 20, 2017 7:37 pm
No new posts Application not run by time HH:MM tri... jzhardy IBM Tools 1 Sun Apr 09, 2017 3:22 pm
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us