Unit of AVG DUR and AVG CPU within Sysview for Db2 SQLSUM request
Article ID: 127899
Updated On:
Products
Issue/Introduction
Request to know the following about the ROWS PROCESSED FOR EACH SQL STATEMENT panel.
The sample panel is as follows:
--------------------------------------------------------------------------------------
Menu Print Tools Help CA SYSVIEW for DB2 ssid lpar mm/dd/yy hh:mm:ss
nn.n ssid xxxxxxx
1 SUMMARY 2 IO 3 PLAN 4 SQL 5 SCANS 6 LOCKS 7 DETAIL
SORT N/A
R/SQLSUM ROWS PROCESSED FOR EACH SQL STATEMENT Row 1-13/397
Actions: E=Explain, T=SQL Text
_ STMT TYPE: FETCH AVG DUR: 0.0004 PLAN: xxxxxxxx TRIGGERED: NO
STMT #: 206 AVG CPU: 0.0002 PROGRAM: xxxxxxxx
ISO LEVEL: N/A COUNT: 2 COLLECTION: xxx
CURSOR: xxxxxxxx_FETCH
|---------------- TOTAL ROWS ------------------------| |------ TOTAL
ANY RIGHT DM RDS RF INT RF INT
TABLE TABLE QUAL QUAL INSERT UPDATE DELETE DELETE SCAN'D SCAN'D
：
--------------------------------------------------------------------------------------
In the ROWS PROCESSED FOR EACH SQL STATEMENT panel, the AVG CPU and AVG DUR were shown as below:
AVG DUR: 0.0004
AVG CPU: 0.0002
What is the unit of the number of the AVG CPU and AVG DUR?
Resolution
SQLSUM request is in the hlq.CDBATREQ(SQLSUM) member.
The format of fields AVG DUR and AVG CPU is 'MM:SS.TTTT'.
HH:MM:SS.TTTT specifies hours, minutes, seconds and ten-thousandths of seconds.
Please see the Field-Attrib for an explanation about how TTTT should be read.
T - seconds (tenths)
TT - seconds (hundredths)
TTT - milliseconds
TTTT - milliseconds (tenths)
Sample panel displays.
AVG DUR: 1.0500 --> 1 second and 5 hundredths seconds (Or 1050 milliseconds).
AVG DUR: 1.5000 --> 1 second and 5 tenths seconds (Or 1500 milliseconds).
AVG DUR: 0.0010 --> 1 millisecond.
Feedback
