Field formats
CICS PA saves data in its container data sets in a format suitable for loading directly into DB2® tables. Field data saved in the container data set depends on its CMF data type and the HDB type.
The following tables outline the various data types and how data is saved for each type of HDB.
List HDB fields
CMF Data Type | DB2 Data Type | Field Length |
---|---|---|
T – Time stamp |
TIMESTAMP |
26 |
C – Character | CHAR(n) | Same as CMF field length. For example, TRAN has length 4. |
A – Counter | INT | 4 |
P – Packed | INT | 4 |
S – Clock | TIME component is FLOAT |
8 |
Other Clocks |
FLOAT | 8 |
Summary HDB fields
CMF Data Type | DB2 Data Type | Field Length |
---|---|---|
T – Time stamp |
Date component is DATE: 'YYYY-MM-DD' |
10 |
C – Character | CHAR(n) | Same as CMF field length. For example, TRAN has length 4. |
A – Counter |
Two FLOAT numbers:
|
|
P – Packed |
Two FLOAT numbers:
|
|
S – Clock | TIME is two FLOAT numbers:
COUNT is two FLOAT numbers:
|
|
Other Clocks |
Two FLOAT numbers:
|
|
TASKCNT |
FLOAT | 8 |
- 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.
- “Other Clocks” include special fields like RESPONSE (response time) which are derived from other fields (RESPONSE = STOP minus START).
- 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.
- 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.
Time precision
CICS PA stores time fields in FLOAT format in units of seconds and a precision of micro-seconds. For example, if the accumulated response time total in a Summary HDB is 10.202122 and the task count (TASKCNT field) for this interval is 20, then the average response time is 10.202122/20=0.510106 seconds.