Times (class 1 and 2)—application time and Db2 time

ELAPSED TIME

Elapsed time from the first connect to Db2 to thread termination (QWACESC - QWACBSC)

The time a thread was inactive waiting for work is included in this value. This value is not accurate for threads that do not terminate, such as a CICS conversational transaction or an IMS WFI BMP.

Class 2 elapsed time of the allied agent in Db2

NONNESTED

Class 1 time for non-nested activity of the allied agent

This time does not include the time spent in stored procedures, user-defined functions, or triggers.

Elapsed time for non-nested 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 in stored procedures, including time spent executing SQL (QWACSPEA)

Total elapsed time spent executing SQL in stored procedures (QWACSPEB)

UDF

Total elapsed time spent in user-defined functions, including time spent executing SQL (QWACUDEA)

This time is collected with accounting class 1 active.

Elapsed time that the allied agent spent executing SQL in user defined functions (QWACUDEB)

TRIGGER

Accumulated elapsed time used while executing under the control of triggers (QWACTRET)

Accumulated elapsed time used for executing triggers under an enclave (QWACTRET)

CPU TIME

CPU time from MVS (QWACEJST - QWACBJST)

This number is the MVS CPU time as reported from all calling sources, such as CICS, IMS or TSO. It includes both the main task and all parallel tasks. Zeros indicate no time is available. This number represents the MVS CPU time for the application. It is calculated by subtracting the beginning CPU time from the ending CPU time.

This time does not include zIIP 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.

AGENT

Allied agent’s class 1 CPU time (in Db2)

It comprises the class 1 CPU time of the allied agent, which may include the accumulated class 1 CPU time for processing stored procedures, user-defined functions, and triggers if present. CPU time for processing parallel tasks is not charged to this counter.

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.

NONESTED

Class 1 CPU time consumed by the allied agent’s non-nested activity

Class 2 CPU time consumed by allied agent's non-nested activity

STORED PRC

TCB time spent processing SQL stored procedure CALL statements (QWACSPCP)

This time reflects the TCB time for SQL CALL statements which reference stored procedures in the stored procedures address space or a WLM address space. This time is collected with accounting class 1 active.

This time does not include zIIP CPU time.

TCB time spent processing SQL statements that were issued by stored procedures

UDF

Accumulated CPU time used to satisfy user-defined function requests processed in WLM address (QWACUDCP)

CPU time consumed in Db2 for processing SQL statements that were issued by user-defined functions

TRIGGER

Accumulated TCB time used while executing under the control of triggers (QWACTRTT)

This time does not include zIIP CPU time.

Accumulated TCB time used while executing under the control of triggers

This time does not include zIIP CPU time.

PAR. TASKS

CPU time spent processing parallel tasks (QWACEJST - QWACBJST)

This number is the MVS CPU time as reported from all calling sources, such as CICS, IMS, or TSO. It does not include the main task. Zeros indicate no time is available. This number represents the MVS CPU time for the application. It is calculated by subtracting the beginning CPU time from the ending CPU time.

This time does not include zIIP CPU time.

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.

(BACCTDR only)

S/E ELIGIBL:

Accumulated CPU time that ran on a standard CP for zIIP-eligible work (QWACEZIP)

(BACCTLT only)

IIP CPU

(BACCTLT only)

IIP CP

TRIG CPU

STORED PR

UDF

(BACCTDR only)

S/E CPU

Accumulated CPU time that is consumed while running on a zIIP in all environments

Average percentage of CPU time that is consumed while running on a zIIP of Class 2 elapsed time

TRIGGERS

Accumulated CPU time that is consumed for triggers while running on a zIIP

N/A

SUSPEND TIME

Application suspension time spent outside of Db2

Application suspension time for all types of class 3 suspensions by the originating task and parallel tasks

AGENT

N/A

Application suspension time of the allied agent for all types of class 3 suspension

(BACCTLT only)

UDF SCHED

N/A

PAR.TASKS

N/A

Total suspension time spent for parallel tasks (query CP or Sysplex query parallel tasks, or parallel tasks produced by utilities)

STORED PR

Average stored procedure application 1 TCB time

N/A

NOT ACCOUNT

N/A

Time not accounted in Db2

This time is the class 2 waiting time minus the sum of class 3 times.

DB2 ENT/EXIT

N/A

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

N/A

Number of SQL entry or exit events performed by stored procedures (QWACSPNE)

EN/EX-UDF

N/A

Number of SQL entry/exit events performed by user-defined functions (QWACUDNE)