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

Example

Reload processing was executed on a table for which an index is defined. An error occurred during batch index creation because of an error on the disk that contains the index storage RDAREA.
Data load processing was executed in the addition mode on a table for which a plug-in index is defined. An error occurred during batch creation of plug-in index because of an error on the disk that contains the index storage RDAREA.

In such a case, the data is in the following status:

Organization of this subsection: (1) Check the message; (2) Take action to remedy the disk error; (3) Use the pdhold command to shut down the RDAREA storing the index; (4) Use the pdrstr command to recover the RDAREA storing the index; (5) Use the pdrorg command to re-create the index; (6) Back up the RDAREA storing the index; (7) Use the pdrels command to release the RDAREA from shutdown status

(1) Check the message

If you are loading data, check if the KFPL00703-I message was issued. If you are reloading, check if the KFPL00714-I or KFPL00734-I message was issued. If one of these messages has been issued, the table data is in completed status. In this case, use the pdrels command to release the RDAREA storing the table data (RDAREA1) from shutdown status. This operation is not required if reloading (or data loading) was performed in the no-log mode.

 
pdrels -r RDAREA1

(2) Take action to remedy the disk error

(3) Use the pdhold command to shut down the RDAREA storing the index

 
pdhold -r RDAREA2

This operation is required only if reloading (or data loading) was performed in the log acquisition mode or the pre-update log acquisition mode.

(4) Use the pdrstr command to recover the RDAREA storing the index

Recover the RDAREA storing the index (RDAREA2). For details about recovering RDAREAs, see 21. Database Recovery Procedures.

Do not release the RDAREA from shutdown even after it has been recovered.

(5) Use the pdrorg command to re-create the index

(6) Back up the RDAREA storing the index

Because you re-created the index in the pre-update acquisition mode (default), back up the RDAREA storing the index (RDAREA2). For details about backing up RDAREAs, see 6.4.8 Example 8 (backing up specified RDAREAs).

(7) Use the pdrels command to release the RDAREA from shutdown status

 
pdrels -r RDAREA2

We recommend that after the command has executed you check whether the execution results are correct. For details on how to check command execution results, see the manual HiRDB Version 9 Command Reference.