CICS regions base table
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.
- CIU_REGION_INFO
- This table stores information about the CICS regions on which the Collector has
run. Whenever a collection of dependency or affinity data is started,
the names of the CICS System
Definition data set (CSD) and of the first four resource group lists
in the CSD are stored, together with date and time information.
Table 1. The CIU_REGION_INFO table 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.