CA Bind Analyzer for DB2 for z/OSCA DetectorCA SQL-Ease for DB2 for z/OSCA Sysview Performance Management Option for DB2 for z/OSCA Database Detector for DB2 for z/OSCA Plan Analyzer for DB2 for z/OSCA 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