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.
Column | Type | Description |
---|---|---|
APPLID | CHAR(8) | CICS® region applid. |
HOMESYSID | CHAR(4) | SYSID of local region. |
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 |