Calculating CICS and DB2 processor times for DB2 Version 5 or earlier

When your CICS system is connected to DB2 Version 5 or earlier, the CICS performance class record does not include processor time consumed in DB2. To estimate the total processor time for a single transaction, add information from the corresponding CICS performance record and the DB2 accounting record (SMF type 101 record).

About this task

For information about matching CICS performance records with DB2 accounting records, see Relating DB2 accounting records to CICS performance class records.

Take the CPU field from the CICS performance class record. Using the DB2 accounting record, you can calculate the DB2 thread processor time (T1) as:
          T1 = QWACEJST - QWACBJST
This calculates the CLASS 1 TCB processor time. The sum of the processor time from the CICS CPU field and the calculated value of T1 is an expression for the processor time spent in CICS and DB2.
Notes:
  • The CLASS 2 processor time is part of the CLASS 1 processor time and should not be added to the sum.
  • If the CLASS 2 processor time is subtracted from the CLASS 1 processor time, this gives an approximation of CPU utilization of the CICS DB2 attachment facility. This is a useful tuning aid.
  • The processor time used in the DB2 address spaces and recorded in the DB2 statistics records is not related to any specific thread. It can be distributed proportionally to the CPU time recorded in the DB2 accounting records.
  • Processor time used in the CICS address space under the subtask TCBs cannot easily be distributed to the CICS performance records, because it includes the processor times for the DB2 subtasks, which are already contained in the calculated T1 value. It means that processor time used in subtasks other than the thread subtasks is not included in the addition.
  • Most of the processor time used in the thread TCB to create the thread is not included in any DB2 accounting records associated with this thread, because this processor time is spent before the thread is created.
  • The capture ratio for CICS and DB2 should be taken into account. Capture ratio is the ratio of reported CPU time to total used CPU time (for more information, see the z/OS® Resource Measurement Facility (RMF™) Performance Management Guide (SC28–1951)).


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