Event table
Use the information in the CIU_EVENT_DETAIL table to write your own SQL applications to query the tables; these applications must use native SQL queries.
- CIU_EVENT_DETAIL
- This
table stores detailed EVENT information.
Table 1. The CIU_EVENT_DETAIL 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) SYSID of local region. PLATFORM CHAR(64) Platform name APPL_NAME CHAR(64) Application name APPL_VER1 INTEGER Major version number APPL_VER2 INTEGER Minor version number APPL_VER3 INTEGER Micro version number APPL_OPER CHAR(64) The operation associated with the task EVENT_NAME CHAR(32) Event name. CAPTURE_SPEC CHAR(32) Capture Specification name. EVENT_BINDING CHAR(32) Event Binding name. EVENT_TYPE CHAR(1) Event type (application or system). EVENT_STRUCID CHAR(4) Event structure identifier. EVENT_VERSION INTEGER Event Structure version number. SCHEMA_VER INTEGER Schema version number. SCHEMA_REL INTEGER Schema release number. EVENT_USERTAG CHAR(8) Event Binding user tag. EB_DEF_SOURCE CHAR(8) Event Binding definition source. The source of the definition, depending on which, agent made the last change. EB_DEF_TIME TIMESTAMP Event Binding definition time. The local date and time when the resource definition record was created. EB_STATUS CHAR(12) Event Binding status. Indicates whether the event binding is enabled or not. EB_ADAPTER CHAR(32) Event Binding Adapter. EB_CHG_AGENT CHAR(12) Event Binding change agent identifier. EB_CHG_REL CHAR(4) The CICS release level of the agent that made the last modification. EB_CHG_TIME TIMESTAMP The local date and time when the definition was last changed. EB_CHG_USERID CHAR(8) The user ID that made the last modification. EB_INST_AGENT CHAR(12) The install agent identifier that made the installation. EB_INST_TIME TIMESTAMP The local date and time when the definition was installed. EB_INST_USERID CHAR(8) The user ID that installed the resource definition. BUNDLE_BASESCOPE CHAR(255) Base scope of bundle. BUNDLE_DIR CHAR(255) Name of the BUNDLE directory. BUNDLE_CHG_AGENT CHAR(12) Last modification agent. BUNDLE_CHG_AGREL CHAR(4) Last modification agent release. BUNDLE_CHG_TIME TIMESTAMP Last modification time. BUNDLE_CHG_USERID CHAR(8) Last modification user ID. BUNDLE_DEF_SOURCE CHAR(8) Source of the resource definition. BUNDLE_DEF_TIME TIMESTAMP Creation time. BUNDLE_ENA_COUNT INTEGER Enabled count. BUNDLE_ENA_STATUS CHAR(12) Status. BUNDLE_INST_AGENT CHAR(12) Installation agent. BUNDLE_INST_TIME TIMESTAMP Installation time. BUNDLE_INST_USERID CHAR(8) Installation user ID. BUNDLE_PART_COUNT INTEGER Part count. BUNDLE_TARGET_COUNT INTEGER Target count. FIRST_RUN TIMESTAMP Time of first occurrence, in the local time format. LAST_RUN TIMESTAMP Time of latest observation, in the local time format. IN _db2dbnt_.CIUEVNT AUDIT CCSID EBCDIC