Measured/Elig Times

This topic shows detailed information about Accounting - Measured/Elig Times.

Accounting - Measured/Elig Times

The field labels shown in the following sample layout of Accounting - Measured/Elig Times are described in the following section. 


MEASURED/ELIG TIMES  APPL (CL1)   DB2 (CL2)
-------------------  ----------  ----------
ELAPSED TIME          18.459616   18.025282
 ELIGIBLE FOR ACCEL         N/A    0.000000
                                           
CP CPU TIME          1:31.19251  1:30.81587
 ELIGIBLE FOR SECP   1:09.97827         N/A
 ELIGIBLE FOR ACCEL         N/A    0.000000
                                           
SE CPU TIME            0.000000    0.000000
 ELIGIBLE FOR ACCEL         N/A    0.000000
APPL (CL1) - ELAPSED TIME

The class 1 elapsed time of the allied agent.

Special Considerations:
  • If the begin time equals zero, or if the end time minus begin time equals zero or is negative, N/C is shown.
  • Threads that can be reused, such as CICS protected threads or IMS/VS wait-for-input message regions, can include time during which the thread was inactive and waiting for work.
  • Elapsed time to process distributed requests is included for allied-distributed threads.
  • This time includes the time for processing SQL statements issued by stored procedures, user-defined functions, or triggers.
  • In query CP, sysplex query, or utility parallelism, this is the time shown in the originating record, which overlaps the elapsed times shown in the parallel records.

Field Name: ADRECETT

This is an exception field.

APPL (CL1) - CP CPU TIME

The class 1 CPU time in an application. It indicates:

  • The class 1 CPU time of the allied agent, which may include the accumulated class 1 TCB time for processing stored procedures, user-defined functions, and triggers.
  • The accumulated CPU time for processing parallel tasks. This is valid for query CP parallelism, sysplex query parallelism, and parallel tasks generated by utilities.
  • In sysplex query parallelism, the individual CPU times are normalized by the conversion factor of the parallel tasks that is related to the originating task.

    In sysplex query parallelism, only CPU times of parallel tasks, running on the same member of the SYSPLEX group as the originating task, are included.

This CPU time does not include time that is consumed on an IBM specialty engine.

Field Name: ADCPUT

This is an exception field.

APPL (CL1) - CP CPU TIME - ELIGIBLE FOR SECP

The accumulated CPU time that is consumed on a standard CP for work eligible on an IBM specialty engine.

For records for the parent tasks in parallel queries, this value reflects zIIP-eligible time for the parent and the child tasks. Child task records have a value of 0.

Field Name: AWACZEL

APPL (CL1) - SE CPU TIME

The sum of several accumulated CPU times consumed while running on an IBM specialty engine in all environments. These times are consumed when:

  • Running stored procedure requests and triggers on the main application execution unit.
  • Satisfying stored procedure requests processed in a DB2 stored procedure or WLM address space. SQL procedure times are included in this time if the SQL procedure was called on a nested task and was not invoked by the main application execution unit.
  • Satisfying UDF requests processed in a DB2 stored procedure or WLM address space.
  • Running triggers on a nested task.
  • Running parallel tasks in an application which contains the accumulated CPU time used to satisfy UDF requests.
Note: All CPU times of an IBM specialty engine (SE) that are reported in DB2 trace records are already normalized by DB2 to the speed of the general purpose processor.

Field Name: AWACC1Z

DB2 (CL2) - ELAPSED TIME

The class 2 elapsed time of the allied agent accumulated in DB2.

Field Name: ADDB2ETT

This is an exception field.

DB2 (CL2) - ELAPSED TIME - ELIGIBLE FOR ACCEL

The accumulated elapsed time spent processing SQL in DB2 that may be eligible for execution on an accelerator.

Field Name: AWACEEL2

DB2 (CL2) - CP CPU TIME
The class 2 CPU time (in DB2). It indicates:
  • The class 2 CPU time for the allied agent. This includes the accumulated class 2 TCB time for processing any stored procedures, user-defined functions, and triggers.
  • The accumulated CPU time for processing parallel tasks. This is valid for query CP parallelism, sysplex query parallelism, and parallel tasks generated by utilities.
  • For batch reporting, in sysplex query parallelism, the individual CPU times are normalized by the conversion factor of the parallel tasks, related to the originating task.

    For online monitoring, in sysplex query parallelism, only CPU times of parallel tasks, running on the same member of the sysplex group as the originating task, are included.

This CPU time does not include time that is consumed on an IBM specialty engine.

Field Name: ADDBCPUT

This is an exception field.

DB2 (CL2) - CP CPU TIME - ELIGIBLE FOR ACCEL

The accumulated CPU time spent processing SQL in DB2 that may be eligible for execution on an accelerator.

Field Name: AWACECP2

DB2 (CL2) - SE CPU TIME

The accumulated and consumed class 2 time on an IBM specialty engine (SE) that consists of times for non-nested, stored procedures, user-defined functions, triggers, and parallel tasks.

Note: All CPU times of an IBM specialty engine that are reported in DB2 trace records are already normalized by DB2 to the speed of the general purpose processor.

Field Name: AWACC2Z

DB2 (CL2) - SE CPU TIME - ELIGIBLE FOR ACCEL

The accumulated CPU time consumed on an IBM specialty engine while processing SQL in DB2 that may be eligible for execution on an accelerator.

Field Name: AWACESE2