CPU Times

This topic shows detailed information about Statistics - CPU Times.

This block shows statistics data of CPU timer values for each resource manager and control address space.

Db2 can generate parallel tasks for the efficient execution of queries. Parallel tasks are executable units composed of special SRBs (service request block), which are called preemptable SRBs. With preemptable SRBs, the z/OS dispatcher can interrupt a task at any time to run other work at the same or higher dispatching priority. For non-distributed parallel work, parallel tasks run under a type of preemptable SRB, which is called a client SRB. The client SRB lets the parallel task inherit the importance of the originating address space. For distributed requests, the parallel tasks run under a preemptable SRB, which is called an enclave SRB.

Statistics - CPU Times

The field labels shown in the following sample layout of Statistics - CPU Times are described in the following section.


CPU TIMES                               TCB TIME      PREEMPT SRB   NONPREEMPT SRB      CP CPU TIME  PREEMPT IIP SRB  CP CPU /COMMIT
-------------------------------  ---------------  ---------------  ---------------  ---------------  ---------------  --------------
SYSTEM SERVICES ADDRESS SPACE           0.120789         0.037248         0.027924         0.185961         0.000000        0.005635
DATABASE SERVICES ADDRESS SPACE         0.403656         0.218449         0.009574         0.631680         0.000000        0.019142
IRLM                                    0.000043         0.000000         0.224940         0.224983         0.000000        0.006818
DDF ADDRESS SPACE                       0.005795         1.122965         0.007127         1.135886         0.000000        0.034421

TOTAL                                   0.530282         1.378663         0.269566         2.178511         0.000000        0.066015

SYSTEM SERVICES ADDRESS SPACE - TCB TIME

TCB time for the system services address space.

Field Name: SSTCBT

DATABASE SERVICES ADDRESS SPACE - TCB TIME

TCB time used for database services address space.

Field Name: SDTCBT

IRLM - TCB TIME

IRLM TCB time.

Field Name: SDITCBT

DDF ADDRESS SPACE - TCB TIME

DDF address space TCB time.

Field Name: SDDFTCBT

TOTAL - TCB TIME

Total TCB time for all address spaces.

Field Name: SDTLTCBT

SYSTEM SERVICES ADDRESS SPACE - PREEMPT SRB

The preemptable SRB time for the system services address space, not including preemptable SRB time consumed on an IBM zIIP.

Field Name: SSPSRB

DATABASE SERVICES ADDRESS SPACE - PREEMPT SRB

The preemptable SRB time for the database services address space, not including preemptable SRB time consumed on an IBM zIIP.

Field Name: SDPSRB

IRLM - PREEMPT SRB

The preemptable SRB time for the IRLM address space, not including preemptable SRB time consumed on an IBM zIIP.

Field Name: SDIPSRB

DDF ADDRESS SPACE - PREEMPT SRB

The preemptable SRB time for the DDF address space, not including preemptable SRB time consumed on an IBM zIIP.

Field Name: SDDFPSRB

TOTAL - PREEMPT SRB

Total preemptable SRB time for all address spaces, not including preemptable SRB time consumed on an IBM zIIP.

Field Name: SDTLPSRB

SYSTEM SERVICES ADDRESS SPACE - NONPREEMPT SRB

The nonpreemptable SRB time for the system services address space.

Field Name: SSNPSR

DATABASE SERVICES ADDRESS SPACE - NONPREEMPT SRB

The nonpreemptable SRB time for the database services address space.

Field Name: SDNPSR

IRLM - NONPREEMPT SRB

The nonpreemptable SRB time for the IRLM address space.

Field Name: SDINPSR

DDF ADDRESS SPACE - NONPREEMPT SRB

The nonpreemptable SRB time for the DDF address space.

Field Name: SDDFNPSR

TOTAL - NONPREEMPT SRB

Total nonpreemptable SRB time for all address spaces.

Field Name: SDTLNPSR

SYSTEM SERVICES ADDRESS SPACE - CP CPU TIME

System services address space total time.

Field Name: SSTOTT

DATABASE SERVICES ADDRESS SPACE - CP CPU TIME

Database services address space total time.

Field Name: SDTOTT

IRLM - CP CPU TIME

IRLM address space total time.

Field Name: SDITOTT

DDF ADDRESS SPACE - CP CPU TIME

DDF address space total time.

Field Name: SDDFTOTT

TOTAL - CP CPU TIME

Total CPU time for all address spaces.

Field Name: SDTLTOTT

SYSTEM SERVICES ADDRESS SPACE - PREEMPT IIP SRB

The preemptable SRB time for the system services address space consumed on an IBM zIIP.

Field Name: SSPSRZ

DATABASE SERVICES ADDRESS SPACE - PREEMPT IIP SRB

The preemptable SRB time for the database services address space consumed on an IBM zIIP.

Field Name: SDPSRZ

IRLM - PREEMPT IIP SRB

The preemptable SRB time for the IRLM address space consumed on an IBM zIIP.

Field Name: SDIPSRZ

DDF ADDRESS SPACE - PREEMPT IIP SRB

The preemptable SRB time for the DDF address space consumed on an IBM zIIP.

Field Name: SDDFPSRZ

TOTAL - PREEMPT IIP SRB

Total preemptable SRB time for all address spaces consumed on an IBM zIIP.

Field Name: SDTLPSRZ