Service Units

This topic shows detailed information about Accounting - Service Units.

This block shows class 1 and class 2 CPU times as service units.

The following example shows both layouts, the report on the left, and the trace layout on the right.

Accounting - Service Units

The field labels shown in the following sample layout of Accounting - Service Units are described in the following section. 


Report:                                            Trace:

AVERAGE SU           CLASS 1         CLASS 2       TOTAL SU              CLASS 1         CLASS 2
------------  --------------  --------------       -------------  --------------  --------------
CP CPU                 15.50            8.00       CP CPU                7599131         7599098
 AGENT                 15.50            8.00        AGENT                    240             207
  NONNESTED            15.50            8.00         NONNESTED               240             207
  STORED PRC            0.00            0.00         STORED PRC                0               0
  UDF                   0.00            0.00         UDF                       0               0
  TRIGGER               0.00            0.00         TRIGGER                   0               0
 PAR.TASKS              0.00            0.00        PAR.TASKS            7598890         7598890

 ELIG SECP              0.00             N/A        ELIG SECP                  0             N/A
 ELIG ACCEL              N/A            0.00        ELIG ACCEL               N/A            0.00

SE CPU                 15.50            8.00       SE CPU                7599131         7599098
  NONNESTED            15.50            8.00         NONNESTED               240             207
  STORED PROC           0.00            0.00         STORED PROC               0               0
  UDF                   0.00            0.00         UDF                       0               0
  TRIGGER               0.00            0.00         TRIGGER                   0               0
 PAR.TASKS              0.00            0.00        PAR.TASKS            7598890         7598890
 
 ELIG ACCEL             N/A             0.00        ELIG ACCEL               N/A            0.00
CLASS 1: CP CPU
The class 1 CPU service units (in an application). It indicates:
  • The TCB service units.
  • The accumulated TCB service units for processing stored procedures if stored procedures are present.
  • The accumulated CPU service units for processing parallel tasks. This is valid for query CP parallelism, sysplex query parallelism, and parallel tasks generated by utilities.
These CPU service units do not include the service units that were consumed on an IBM specialty engine.

Field Name: ADSUCPU1

CLASS 1: CP CPU - AGENT

The class 1 TCB service units (in an application). This field is derived from the TCB time and the conversion factor of the originating task.

Field Name: ADSUAGT1

CLASS 1: CP CPU - AGENT - NONNESTED

The TCB service units accumulated in nonnested activity.

Field Name: ADSUNN1

CLASS 1: CP CPU - AGENT - STORED PRC

The TCB service units accumulated in an application for stored procedures. This field is derived from the TCB time and the conversion factor of the originating task.

Field Name: ADSUTCS1

CLASS 1: CP CPU - AGENT - UDF

The TCB service units accumulated in an application for UDF.

Field Name: ADSUTCU1

CLASS 1: CP CPU - AGENT - TRIGGER

The number of TCB service units accumulated in DB2 used while executing under control of a trigger.

Field Name: ADSUTCT2

CLASS 1: CP CPU - PAR.TASKS

The sum of the CPU service units of the parallel tasks running in an application. These tasks can be query CP or sysplex query parallel tasks, parallel tasks produced by utilities, or roll-up autonomous tasks.

Field Name: ADSUCPP1

CLASS 1: CP CPU - ELIG SECP

The accumulated CPU service units that ran on a standard CP for work eligible on an IBM specialty engine.

Field Name: ADSUZEL

CLASS 1: SE CPU

The sum of several accumulated CPU service units consumed while running on an IBM specialty engine in all environments. This field is derived from the TCB time and the conversion factor of the originating task. These service units 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 service units 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: ADSUC1Z

CLASS 1: SE CPU - NONNESTED

The class 1 CPU service units for nonnested activity on the main application task consumed while running on an IBM specialty engine. These service units ignore the CPU time consumed when running stored procedure requests, or triggers on the main application execution unit on an IBM specialty engine.

Field Name: ADSUSEN1

CLASS 1: SE CPU - STORED PROC

The accumulated and consumed service units for stored procedures on an IBM specialty engine that consist of following parts:

  • Service units processed in a DB2 stored procedure or WLM address space. SQL procedure service units are included if the SQL procedure was called on a nested task and was not invoked by the main application execution unit.
  • Service units when running on the main application execution unit. As these stored procedures run entirely within DB2, this part of the service units counts for class 1 and class 2 time.

Field Name: ADSUSES1

CLASS 1: SE CPU - UDF

The accumulated CPU service units used to satisfy UDF requests processed in a DB2 stored procedure or WLM address space while running on an IBM specialty engine.

Field Name: ADSUSEU1

CLASS 1: SE CPU - TRIGGER

The accumulated CPU service units consumed on an IBM specialty engine while running triggers on a nested task or on the main application execution unit.

Field Name: ADSUSETR

CLASS 1: SE CPU - PAR.TASKS

The sum of the CPU service units of the parallel tasks running in an application on an IBM specialty engine. These service units contain the nonnested and consumed service units for stored procedures, UDFs, and triggers.

Field Name: ADSUSEP1

CLASS 2: CP CPU
The class 2 service units (in DB2). It indicates:
  • The TCB service units.
  • The accumulated TCB service units for processing stored procedures if stored procedures are present.
  • The accumulated CPU service units for processing parallel tasks. This is valid for query CP parallelism, sysplex query parallelism, and parallel tasks produced by utilities.
These CPU service units do not include the service units that were consumed on an IBM specialty engine.

Field Name: ADSUCPU2

CLASS 2: CP CPU - AGENT

The class 2 TCB service units (in DB2). This field is derived from the TCB time and the conversion factor of the originating task.

Field Name: ADSUAGT2

CLASS 2: CP CPU - AGENT - NONNESTED

The number of class 2 service units accumulated in nonnested activity.

Field Name: ADSUNN2

CLASS 2: CP CPU - AGENT - STORED PRC

The TCB service units accumulated in DB2 for stored procedures. This field is derived from the TCB time and the conversion factor of the originating task.

Field Name: ADSUTCS2

CLASS 2: CP CPU - AGENT - UDF

The TCB service units accumulated in DB2 for UDF.

Field Name: ADSUTCU2

CLASS 2: CP CPU - AGENT - TRIGGER

The number of TCB service units accumulated in DB2 used while executing under control of a trigger.

Field Name: ADSUTCT2

CLASS 2: CP CPU - PAR.TASKS

The sum of the CPU service units of the parallel tasks running in DB2. These tasks can be query CP or sysplex query parallel tasks, parallel tasks produced by utilities, or roll-up autonomous tasks.

These service units do not include service units consumed on an IBM specialty engine.

Field Name: ADSUCPP2

CLASS 2: CP CPU - ELIG ACCEL

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

Field Name: ADSUAEC2

CLASS 2: SE CPU

The sum of the accumulated CPU service units consumed while running in DB2 on an IBM specialty engine due to CPU time spent:

  • Nonnested on main application execution unit.
  • On triggers on main application execution unit and nested tasks.
  • Processing SQL statements issued by UDFs processed in a DB2 stored procedure or WLM address space.
  • On stored procedures on main application execution unit and nested tasks processed in a DB2 stored procedure or WLM address space. SQL procedure times are included if the SQL procedure was called on a nested task and was not invoked by the main application execution unit.

Field Name: ADSUC2Z

CLASS 2: SE CPU - NONNESTED

The class 2 CPU service units for nonnested activity on the main application task consumed while running on an IBM specialty engine.

Field Name: ADSUSEN2

CLASS 2: SE CPU - STORED PROC

The accumulated and consumed service units for stored procedures on an IBM specialty engine that consist of following parts:

  • Service units consumed in DB2, in a DB2 stored procedure, or WLM address space. SQL procedure service units are included if the SQL procedure was called on a nested task and was not invoked by the main application execution unit.
  • Service units when running on the main application execution unit. As these stored procedures run entirely within DB2, this part of service units counts for class 1 and class 2 time.

Field Name: ADSUSES2

CLASS 2: SE CPU - UDF

The accumulated and consumed service units for stored procedures on an IBM specialty engine that consist of following parts:

  • Service units consumed in DB2, in a DB2 stored procedure, or WLM address space. SQL procedure service units are included if the SQL procedure was called on a nested task and was not invoked by the main application execution unit.
  • Service units when running on the main application execution unit. As these stored procedures run entirely within DB2, this part of service units counts for class 1 and class 2 time.

This time is a subset of QWACSP_CLS1SE.

Field Name: ADSUSEU2

CLASS 2: SE CPU - TRIGGER

The accumulated CPU service units consumed on an IBM specialty engine while running triggers on a nested task or on the main application execution unit.

Field Name: ADSUSETR

CLASS 2: SE CPU - PAR.TASKS

The sum of the CPU service units of the parallel tasks running in DB2. These service units contain the nonnested and consumed service units for stored procedures, UDFs, and triggers.

Field Name: ADSUSEP2

CLASS 2: SE CPU - ELIG ACCEL

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

Field Name: ADSUAES2