7.6.1 When data was loaded in log acquisition mode or pre-update log acquisition mode

This section explains the procedure for handling errors that may occur during data loading in the log acquisition mode or pre-log acquisition mode.

If the table has a plug-in index, this procedure assumes that the applicable plug-in provides the batch plug-in index creation partial recovery facility. If your plug-in does not have the batch plug-in index creation partial recovery facility, see 7.6.2 When data was loaded in no-log mode.

Restore the index storage RDAREAs according to the cause of error. The following shows the procedure:

Organization of this subsection
(1) Error due to shortage of space in index storage RDAREA
(2) Sorting error (message KFPL15062-E is output) or an error due to forced termination of the utility by the pdcancel command
(3) Error due to a disk failure

(1) Error due to shortage of space in index storage RDAREA

  1. Expand the index storage RDAREA.

    [Figure]

  2. Create the index. Use the index information file created by the database load utility (pdload) to create the index in the batch mode.

    [Figure]

    If the index information file created by the database load utility (pdload) is not available, re-create the index with the database reorganization utility (pdrorg).

    [Figure]

(2) Sorting error (message KFPL15062-E is output) or an error due to forced termination of the utility by the pdcancel command

  1. Create the index. Use the index information file created by the database load utility (pdload) to create the index in the batch mode.

    [Figure]

    If the index information file created by the database load utility (pdload) is not available, re-create the index with the database reorganization utility (pdrorg).

    [Figure]

(3) Error due to a disk failure

  1. Replace the faulty disk and use a backup copy to restore the status before the utility executed. To prevent accesses, place the RDAREAs in shutdown status until the index storage executed in step 2 has been completed.

    [Figure]

  2. Re-create the index with the database reorganization utility (pdrorg).

    [Figure]