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:
Name | Type | Description |
BUSEVENT_ID | BIGINT NOT NULL | The unique identifier of a business event.
Together with SEQUENCE column, it forms the primary key of the
table. |
SEQUENCE | INTEGER NOT NULL | The 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. |
CREATETSTMP | TIMESTAMP NOT NULL | The 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. |
EVENTDATA | VARCHAR (4000) NOT NULL | A 4K chunk of the event XML document. This chunk
could be part of the entire XML document that represents the
business event. |
CHECKED | SMALLINT | The state of the event:
- 0
- Event has not been processed by RaiseECEvent job yet.
- -10
- Event has been processed by RaiseECEvent job.
- -15
- Event is being processed by EventProcessor job.
- -20
- Event is ready to be deleted by CleanECEvent job.
|
EVENT_SEARCHKEY | CHAR (64) | Reserved for HCL internal use. |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | BUSEVENT_ID+SEQUENCE | Primary Key |
I0001104 | CHECKED | Non-Unique Index |