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