Calculating CICS and DB2 processor times for DB2

When CICS is connected to DB2 and is exploiting the open transaction environment, the CICS DB2 attachment facility uses CICS managed open TCBs rather than CICS DB2 subtask TCBs.

About this task

Using CICS managed open TCBs means the CICS monitoring facility can measure activity that was previously only reported in the DB2 accounting record (the SMF type 101 record). For example, CICS can now measure the processor time consumed on the DB2 thread and the processor time consumed in DB2 (the CLASS 1 and CLASS 2 CPU time). When CICS is using L8 open TCBs, the CPU time reported for these TCBs by the CICS monitoring facility includes the DB2 CLASS 1 processor time.

In the open transaction environment, the CICS L8 task processor time can also include the cost of creating a DB2 thread.

Unless you are using DB2 parallel query, do not add together the processor time from the CICS records (SMF type 110 records) and the DB2 accounting records (SMF type 101 records) when calculating the total processor time for a single transaction, because the DB2 processor time would then be included twice. The total processor time for a single transaction is recorded in the USRCPUT field in the CICS records (performance class data field 008 from group DFHTASK). This field includes all processor time used by the transaction when it was executing on any TCB managed by the CICS dispatcher. CICS-managed TCBs include the QR, RO, CO, and L8 mode TCBs.

If you are using DB2 parallel query, you do need to add some of the processor time from the DB2 accounting records. With DB2 sysplex query parallelism, DB2 might use multiple TCBs within the DB2 address space to service a query. The TCBs used for this purpose are non-CICS TCBs, so any processor time that they consume is not accounted for in the CICS SMF type 110 records. To obtain the total amount of processor time used for a parallel query, you therefore need to add the PAR.TASKS processor time recorded in the DB2 SMF type 101 record that applies to the transaction, to the processor time recorded in the USRCPUT field in the CICS SMF type 110 record.



dfhtkyq.html | Timestamp icon Last updated: Sunday, 4 June 2017