Times (class 2)—DB2 time (BACCTDR)
This topic describes the Times (class 2)—DB2 time section of the Accounting summary—long report (BACCTDR).
------------ -------------- --------------
ELAPSED TIME 0.219540 0.020884
NONNESTED 0.219540 0.020884
STORED PROC 0.000000 0.000000
UDF 0.000000 0.000000
TRIGGER 0.000000 0.000000
CP CPU TIME 0.003412 0.001759
AGENT 0.003412 0.001759
NONNESTED 0.003412 0.001759
STORED PRC 0.000000 0.000000
UDF 0.000000 0.000000
TRIGGER 0.000000 0.000000
PAR. TASKS 0.000000 0.000000
S/E ELIGIBL 0.000000
S/E CPU 0.000000 0.000000
TRIGGERS 0.000000
SUSPEND TIME 0.000000 0.019110
AGENT N/A 0.019110
PAR.TASKS N/A 0.000000
STORED PR 0.000000
NOT ACCOUNT N/A 0.000015
DB2 ENT/EXIT N/A 106.535430
EN/EX-STPROC N/A 0.000000
EN/EX-UDF N/A 0.000000
DCAPT DESCR N/A N/A
LOG EXTRACT N/A N/A
The following table describes the fields in the Times (class 2)—DB2 time section.
Field | Description |
|---|---|
ELAPSED TIME | Class 2 elapsed time of the allied agent in DB2 |
NONNESTED | Elapsed time for nonnested activity in DB2 (QWACASC) In the DB2 Accounting CPU/Elapsed Time Report, this value is the average elapsed time within DB2 in seconds per plan execution |
STORED PROC | Total elapsed time spent executing SQL in stored procedures (QWACSPEB) |
UDF | Elapsed time that the allied agent spent executing SQL in user defined functions (QWACUDEB) |
TRIGGER | Accumulated elapsed time used for executing triggers under an enclave (QWACTRET) |
CPU TIME | DB2 CPU time (QWACAJST) In the DB2 Accounting CPU/Elapsed Time Report, this value is the average TCB CPU time consumed within DB2 in seconds per plan execution. This time is the CPU time accumulated when a thread is in DB2. Accounting class 2 must be activated to collect this data. This time does not include any time spent in a stored procedure, which is collected separately. This time does not include zIIP CPU time. |
CPU TIME AGENT | Allied agent's class 2 CPU time in DB2 This includes the accumulated class 2 CPU time for processing stored procedures, user-defined functions, and triggers. |
CPU TIME NONNESTED | Class 2 CPU time consumed by allied agent's nonnested activity |
CPU TIME STORED PROC | TCB time consumed in DB2 for processing SQL statements that were issued by stored procedures |
CPU TIME UDF | CPU time consumed in DB2 for processing SQL statements that were issued by user-defined functions |
CPU TIME TRIGGER | TCB time used when executing under the control of a trigger (QWACTRTT) |
CPU TIME PAR. TASKS | DB2 CPU time (QWACAJST) This time is the CPU time accumulated processing parallel tasks when a thread is in DB2. Accounting class 2 must be activated to collect this data. This time does not include any time spent in a stored procedure, which is collected separately. This time does not include zIIP CPU time. |
SE-CPU | AVG % ZIIP CPU OF CL2 ELAPSED |
SUSPEND TIME | Wait time for all types of class 3 suspensions by the originating task and parallel tasks |
SUSPEND TIME AGENT | Waiting time of the allied agent for all types of class 3 suspension |
SUSPEND TIME PAR. TASK | Total suspension time spent for parallel tasks (query CP or Sysplex query parallel tasks, or parallel tasks produced by utilities) |
NOT ACCOUNT | Time not accounted in DB2 This time is the class 2 waiting time minus the sum of class 3 times. |
DB2 ENT/EXIT | Number of entry or exit events for each user or plan (QWACARNA) This value indicates the number of DB2 entry and exit events processed in determining the elapsed and processor times in DB2. This field does not count entry and exit times for stored procedures which are gathered in a different counter. Accounting class 2 must be activated to determine this value. |
EN/EX-STPROC | Number of SQL entry or exit events performed by stored procedures (QWACSPNE) |
EN/EX-UDF | Number of SQL entry/exit events performed by user-defined functions (QWACUDNE) |
Related topic