I´m new at this skill for DB2 and working with Freeze Frame tools. Excusme if this question is for a child.
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?
Joined: 01 Sep 2006 Posts: 2018 Location: Silicon Valley
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.
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.