Use the information in the CIU_REGION_INFO table in the CICS® regions base table defined in the database to write your own SQL applications to query the tables; these applications must use native SQL queries.
Column | Type | Description |
---|---|---|
COLLECTION_ID | CHAR(16) | Collection ID. |
ARCHIVE_DATE | TIMESTAMP | Time of archiving. |
APPLID | CHAR(8) | CICS region APPLID. |
HOMESYSID | CHAR(4) | CICS region system identifier (SYSID). |
CICS_RELEASE | CHAR(4) | The CICS level number for the CICS region. |
CSD_NAME | CHAR(44) | Name of the CICS System Definition data set (CSD) used during the last collection in this region. |
CSD_GROUP_LIST1 | CHAR(8) | Name of the first resource group list in the CSD defined at system startup. |
CSD_GROUP_LIST2 | CHAR(8) | Name of the second resource group list in the CSD defined at system startup. |
CSD_GROUP_LIST3 | CHAR(8) | Name of the third resource group list in the CSD defined at system startup. |
CSD_GROUP_LIST4 | CHAR(8) | Name of the fourth resource group list in the CSD defined at system startup. |
STORAGE_PROTECT | CHAR(8) | Indicates whether storage protection was active for the region. |
DEP_COLL_LASTSTART | TIMESTAMP | Time at which the last collection of dependency data was started, in the local time format. |
DEP_COLL_LASTSAVE | TIMESTAMP | Time at which collected dependency data was last saved, in the local time format. |
APP_COLL_LASTSTART | TIMESTAMP | Time at which the last collection of affinity data was started, in the local time format. |
APP_COLL_LASTSAVE | TIMESTAMP | Time at which collected affinity data was last saved, in the local time format. |
DEP_COLL_FIRST_COLLECTED | TIMESTAMP | First time dependency data was collected, in the local time format. |
DEP_COLL_LAST_COLLECTED | TIMESTAMP | Last time dependency data was collected, in the local time format. |
AFF_COLL_FIRST_COLLECTED | TIMESTAMP | First time affinity data was collected, in the local time format. |
AFF_COLL_LAST_COLLECTED | TIMESTAMP | Last time affinity data was collected, in the local time format. |