Overview of the event table

Each text search index has an event table associated with it that is created and maintained by the administration stored procedures.

The event table provides information about processing steps in stored procedures and problems that might occur during the indexing of individual documents (text column values) in the SYSPROC.SYSTS_UPDATE stored procedure. If a document cannot be indexed (for example, because the document is ill-formed XML), a row is added to the event table with details about the problem and a reference to the row in the table that the text search index was created on. This information can help to determine the cause of an indexing problem. To allow analysis of event table rows by a program, the rows are further classified by severity.

The schema and name of an event table is SYSIBMTS.EVENTS_index-ID, where index-ID is the index identifier according to the INDEXID column of the SYSIBMTS.SYSTEXTINDEXES administration table. The index-ID is unique for each text search index. To retrieve the name of an event table, you can use the following query:

SELECT 'SYSIBMTS.' || EVENTTABLENAME FROM SYSIBMTS.SYSTEXTINDEXES 
  WHERE INDEXSCHEMA = 'my-schema' and INDEXNAME = 'my-index';

The event table for an index consists of the columns that are specified in the following table.

Table 1. Contents of the event table
Column name	Type	Length	Nulls	Description
RID	CHAR (FOR BIT DATA)	40	Y	Specifies the foreign key to the document in the user table. If null, the event is not related to a document.
OPERATION	CHAR	1	Y	Specifies a document-specific event: ‘I' (insert), ‘U' (update), and ‘D' (delete).
TIME	TIMESTAMP	10	Y	Specifies the time that the event was recorded.
SEVERITY	SMALLINT	2	Y	Specifies the severity of the event: 1 (informational), 4 (warning), 8 (error).
REASON	SMALLINT	2	Y	Specifies the same message number as in the text of the MESSAGE column.
MESSAGE	VARCHAR	1024	Y	Specifies the message text in language according to CURRENT LOCALE LC_CTYPE.