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