The purpose of this table is to persist the business event object so it can be later processed by those other applications that may want to participate in the event. The table will contain a sequence column where each 4K chunk of the XML will be stored in a separate record and can be pieced back based on a unique key and the sequence. One of the objectives of this table is to ensure that the data can be easy replicated using DB2 replication.

Column Descriptions:

BUSEVENT_IDBIGINT NOT NULLThe unique identifier of a business event. Together with SEQUENCE column, it forms the primary key of the table.
SEQUENCEINTEGER NOT NULLThe sequence number associated with the chunk of XML document. The XML document can be pieced back together again based on all records with the same BUSEVENT_ID and the ordering of the sequence column.
CREATETSTMPTIMESTAMP NOT NULLThe timestamp when the event was processed. This can be used for table cleanup so events older then X days can be deleted; where X is a number greater then 0.
EVENTDATAVARCHAR (4000) NOT NULLA 4K chunk of the event XML document. This chunk could be part of the entire XML document that represents the business event.
CHECKEDSMALLINTThe state of the event:
Event has not been processed by RaiseECEvent job yet.
Event has been processed by RaiseECEvent job.
Event is being processed by EventProcessor job.
Event is ready to be deleted by CleanECEvent job.
EVENT_SEARCHKEYCHAR (64)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


NameColumn NamesType
I0001104CHECKEDNon-Unique Index