Summary HDB fields

Summary HDB fields have the following format:
Table 1. Format of Summary HDB fields
CMF Data Type DB2® Data Type Field Length
T – Time stamp

(see note 1)

Date component is DATE: 'YYYY-MM-DD'

One-byte separator is '-'

Time component is TIME: 'HH.MM.SS'

10

1

8

C – Character CHAR(n) Same as CMF field length. For example, TRAN has length 4.
A – Counter

(see note 3)

Two FLOAT numbers:
  • Total
  • Sum of Squares
 
  • 8
  • 8
P – Packed

(see note 3)

Two FLOAT numbers:
  • Total
  • Sum of Squares
 
  • 8
  • 8
S – Clock TIME is two FLOAT numbers:
  • Total
  • Sum of Squares

COUNT is two FLOAT numbers:

  • Total
  • Sum of Squares
 
  • 8
  • 8

 

  • 8
  • 8
Other Clocks

(see note 2)

Two FLOAT numbers:
  • Total
  • Sum of Squares
 
  • 8
  • 8
TASKCNT

TASKTCNT

(see note 4)

FLOAT 8
Note:
  1. Time stamp fields are loaded differently for List and Summary HDBs. List HDB time stamps are loaded as a full TIMESTAMP. Summary HDB time stamps are broken down into their DATE and TIME components. This provides more flexibility to summarize data over time.
  2. “Other Clocks” include special fields like RESPONSE (response time) which are derived from other fields (RESPONSE = STOP minus START).
  3. For summary HDBs, CICS PA keeps 2 accumulators for count and clock fields; Total and Sum of Squares. Total is used to calculate average. Sum of Squares is used to calculate standard deviation and peak percentiles.
  4. TASKCNT and TASKTCNT are special counters in the Summary HDB. TASKCNT is the number of transactions (tasks) that were accumulated to build this summary record. TASKTCNT is the number of Task Termination records. Either TASKCNT or TASKTCNT is used to calculate the average of count and clock fields.