If an error occurs in an index information file after the UAP has executed but before batch creation of plug-in indexes is completed, delayed batch creation of plug-in indexes cannot be executed. In such a case, the plug-in index must be created by one of the following methods:

• Use the database reorganization utility to re-create the plug-in index
• Execute DROP INDEX, then execute CREATE INDEX to create the plug-in index

If there is a large number of data items, either method will require a considerable amount of time because the amount of plug-in index data is equivalent to the number of data items added by the UAP plus the number of data items contained initially in the table.

Therefore, a directory with sufficient disk space must be provided in order to avoid a space shortage for the index information files.

Rollback executed

Appropriate action to correct the error must be taken, then the UAP can be re-executed.

Rollback not executed

If the UAP was executed in the no-log mode, rollback is not executed. In such a case, the database must be restored with the database recovery utility, then the UAP can be re-executed.

Appropriate action to correct the error must be taken, then the database reorganization utility can be executed to create the plug-in index in the batch mode.