The purpose of the log table is to store the change operations on the user table or view that require synchronization with the external full-text index.
For indexes created on regular tables or nickname tables, there are triggers created on the user table to feed change information into the log table. However, if replication capture tables are used, no log table is created and the replication capture table is used instead.
For log tables, the update command reads the entries and deletes them after successful synchronization.
However, in the case of indexes on views, triggers cannot fill the log
table. As you can update the view, the user is responsible for this
task.
Attribute | Type | Notes |
---|---|---|
OPERATION | INTEGER | The type of change on the user table that requires index synchronization: (0 = insert, 1 = update, 2 = delete). |
TIME | TIMESTAMP | The timestamp for the creation of a row in this table. |
PK01 ... PKnm | Same as user table | In case of errors, the column where the problem occurred. They are a copy of the primary key columns of the user table or the equivalent key columns in case of an index on a view. |
The user who creates the table is able to select, update, insert, and delete this view.
If you specify a replication capture table in the create index
command, no log table is created and the replication capture table is used
instead. The replication capture table must contain the following
columns:
Table 16. The replication capture table
Attribute | Type | Notes |
---|---|---|
IBMSNAP_OPERATION | INTEGER | The type of change on the CD or CCD table that requires index
synchronization: (I = insert, U= update, D= delete).
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. |
IBMSNAP_COMMITSEQ | CHAR | Maps to the corresponding column of the CD or CCD table. |
IBMSNAP_INTENTSEQ | CHAR | Maps to the corresponding column of the CD or CCD table. |
PK01 ... PKnm | Same as user table | In case of errors, the column where the problem occurred. They are the primary key columns of the user table. |
The user who defines the table is able to select, update, insert, and delete with the grant option.