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.
Start of changeAPPL_NAMEEnd of change Start of changeCHAR(64)End of change Start of changeApplication nameEnd of change
Start of changeAPPL_VER1End of change Start of changeINTEGEREnd of change Start of changeMajor version numberEnd of change
Start of changeAPPL_VER2End of change Start of changeINTEGEREnd of change Start of changeMinor version numberEnd of change
Start of changeAPPL_VER3End of change Start of changeINTEGEREnd of change Start of changeMicro version numberEnd of change
Start of changeAPPL_OPEREnd of change Start of changeCHAR(64)End of change Start of changeThe operation associated with the taskEnd of change
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    

Reference Reference

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//ciuugevent.html