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 |
---|---|---|
APPLID | CHAR(8) | CICS region applid. |
HOMESYSID | CHAR(4) | CICS region system identifier (SYSID). |
CSD_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 if 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. |