This view allows you to get information on indexing status and error events, and when problems occur during indexing, for example, a document not being found. These index update events are then written to the index's event table.
The schema and name are stored in the db2ext.textindexes view. To get the name of the event view, use the following example:
db2 "select EVENTVIEWSCHEMA, EVENTVIEWNAME from DB2EXT.TEXTINDEXES where INDSCHEMA = 'myschema' and INDNAME = 'myindex'
The event view for an index consists of the following columns.
Attribute | Type | Notes |
---|---|---|
OPERATION | INTEGER | The operation on the user table is be reflected in full-text index
(insert = 0/ update = 1/ delete = 2).
When using a replication capture table, update operations are split into a delete and an insert operation. In this case, an insert operation in the event table can be either from an insert, or an update operation on the source table the index was created on. |
TIME | TIMESTAMP | Timestamp of event entry creation. |
REASON | INTEGER | Reason code. For a list of reason codes, see Appendix I, Text Search Engine reason codes. |
SEVERITY | INTEGER | The severity of the table entry. For example, 1 is for information purposes, 4 indicates a warning, and 8 means a table entry error. |
MESSAGE | VARCHAR(1024) | Additional text information. |
KEY1, ... KEY14 | Depends on the user table | First primary key column of user table to the last primary key column (a maximum of 14). |
PARTITION | INTEGER | The database partition number on which this error occurs. In a non-distributed environment, this is 0. |
The events can be cleared by the DB2TEXT CLEAR EVENTS command, see CLEAR EVENTS for further information.
Note |
---|
Informational events, such as starting, committing, and finishing update processing are also available in this view. In this case, Key1, ... Key14 and OPERATION all have NULL values. |
In the case of indexes on views, the PK01, ..., PK14 columns relate to the columns specified in the KEY COLUMNS clause of the CREATE INDEX command.