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.
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 |
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 |
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.