ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

The unit of the AVG DUR and AVG CPU.

book

Article ID: 127899

calendar_today

Updated On:

Products

Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS 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.