This site will undergo a maintenance outage on Saturday, 13 September beginning at 2:30 AM Central/1 PM IST for a platform upgrade. The downtime will be ~three hours.

Default language.

CPU times (BSTATDR)


This topic describes the CPU times section of the DB2 statistics detail report (BSTATDR).

TCB TIME        SRB TIME        TOTAL TIME         ZIIP TIME
   CPU TIMES                 H:MM:SS.THTTH   H:MM.SS.THTTH    H:MM.SS.THTTH      H:MM.SS.THTTH
   ------------------------  -------------   -------------    -------------      -------------
   SYSTEM   SRVCS ADDR SPC    00:00.01295     00:00.00284      00:00.01579        00:00.00000
   DATABASE SRVCS ADDR SPC    00:00.00359     00:00.00302      00:00.00661        00:00.00007
   IRLM                       00:00.00000     00:00.04770      00:00.04771        00:00.00000
   DDF ADDRESS SPACE          00:00.00550     00:00.00244      00:00.00794        00:00.00000

   TOTAL                      00:00.02205     00:00.05600      00:00.07805

The following table describes the fields in the CPU times section.

Field

Description

TCB TIME

TCB CPU time (QWSAEJST)

This field provides the CPU time for the address space being tracked. The information in the CPU time generally represents time which is not allocated to threads and is therefore usually asynchronous overhead.

This time does not include zIIP CPU time.

SRB TIME

SRB CPU time (QWSASRBT)

This field accumulates the CPU time for all SRB tasks assigned to the address space being tracked. Many Db2 events are scheduled as SRBs (service request blocks) for which time can be obtained. They are, therefore, Db2 address space overhead.

This time does not include zIIP CPU time.

SYSTEM SRVCS ADDR SPC—TOTAL

Total number of CPU (TCB+SRB) seconds consumed by the Db2 master address space during this statistics interval (QWSAEJST of MSTR+QWSASRBT of MSTR)

This time does not include zIIP CPU time.

DATABASE SRVCS ADDR SPC—TOTAL

Total number of CPU (TCB+SRB) seconds consumed by the Db2 database manager address space during this statistics interval (QWSAEJST of DBM+QWSASRBT of DBM).

This time does not include zIIP CPU time.

IRLM—TOTAL

Total number of CPU (TCB+SRB) seconds consumed by the IRLM address space during this statistics interval (QWSAEJST of IRLM+QWSASRBT of IRLM).

This time does not include zIIP CPU time.

DDF ADDRESS SPACE—TOTAL

Total number of CPU (TCB+SRB) seconds consumed by the DDF (DIST) address space if DDF is active during this statistics interval (QWSAEJST of DIST+QWSASRBT of DIST)

This time does not include zIIP CPU time.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*