Executor: HiRDB administrator

When batch index creation is specified during data loading or reloading (during execution of the database load utility or database reorganization utility), batch index creation processing is executed once data loading or reload processing is completed. When batch index creation is specified during data loading or reloading, batch index creation processing is executed once data load or reload processing is completed. If an error occurs during the batch index creation processing (KFPL00716-I message is output), the table data is in completed status but the index data is in incomplete status. The following figure shows the procedure for recovering the index data in this situation.

Figure 14-4 Procedure for recovering index data

Organization of this section

14.7.1 Example of recovery when reloading (data loading) was performed in the log acquisition mode or the pre-update log acquisition mode

14.7.2 Example of recovery when reloading (data loading) was performed in the no-log mode (when the RDAREA storing the index contains no other tables or indexes)

14.7.3 Example of recovery when reloading (data loading) was executed in the no-log mode (when the RDAREA storing the index contains other tables or indexes)

14.7.4 Example of recovery in the event of an error on the disk that contains the index storage RDAREA