The unit of the AVG DUR and AVG CPU.
Article ID: 127899
Updated On:
Products
CA Bind Analyzer for DB2 for z/OS
CA Detector
CA SQL-Ease for DB2 for z/OS
CA Sysview Performance Management Option for DB2 for z/OS
CA Database Detector for DB2 for z/OS
CA Plan Analyzer for DB2 for z/OS
CA Subsystem Analyzer for DB2 for z/OS
Issue/Introduction
I want 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 DB2D AI04 02/07/19 19:50:51
18.0 DB2D TPUxxxx
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: XKEM0001 TRIGGERED: NO
STMT #: 206 AVG CPU: 0.0002 PROGRAM: XDBI313F
ISO LEVEL: N/A COUNT: 2 COLLECTION: CIM
CURSOR: XDBI313F_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 unit of the number of the "AVG CPU" and "AVG DUR?
Environment
MF, Mainframe, z/OS, DB2, IDB2, Sysview for DB2
Resolution
SQLSUM request is in R180.CDBATREQ(SQLSUM) member.
The format of fields AVG DUR and AVG CPU is 'MM:SS.TTTT'.
HH:MM:SS.TTTT specifes hours, minutes, seconds and ten-thousandths of seconds.
Please see the following link for an explanation about how TTTT should be read:
Field-Attrib
https://docops.ca.com/ca-sysview-db2/19/en/reference/iql-reference/iql-syntax/request-elements/field-specification/field-attrib
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.
The format of fields AVG DUR and AVG CPU is 'MM:SS.TTTT'.
HH:MM:SS.TTTT specifes hours, minutes, seconds and ten-thousandths of seconds.
Please see the following link for an explanation about how TTTT should be read:
Field-Attrib
https://docops.ca.com/ca-sysview-db2/19/en/reference/iql-reference/iql-syntax/request-elements/field-specification/field-attrib
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
Powered by
