6.6.2 When data was loaded in no-log mode

This section explains the procedure for handling errors that may occur during data loading in no-log mode or when your plug-in does not provide the batch plug-in index creation partial recovery facility.

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. Reinitialize the index storage RDAREA.
    You can also recover from a backup. In such a case, until index storage has been completed, place the RDAREA in shutdown status in order to prevent accesses. In the following case, recovery must be performed using a backup:
    • The relevant index is stored in an RDAREA with different tables, indexes, or falsification prevented tables.

      [Figure]

  2. Expand the index storage RDAREA.

    [Figure]

  3. 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. Reinitialize the index storage RDAREA.
    You can also recover from a backup. In such a case, until index storage has been completed, place the RDAREA in shutdown status in order to prevent accesses. In the following case, recovery must be performed using a backup:
    • The relevant index is stored in an RDAREA with different tables, indexes, or falsification prevented tables.

      [Figure]

  2. 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.

    [Figure]

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

    [Figure]