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

Example

A table for which an index is defined was reloaded. However, because the size of the RDAREA storing the index was too small at this time (or a sort processing error occurred), an error occurs during batch index creation. When a sort processing error occurs, the KFPL15062-E message is issued.
Data was loaded in the addition mode into a table for which a plug-in index is defined. However, because the size of the RDAREA storing the index was too small at this time, an error occurs during batch plug-in index creation.

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

Organization of this subsection: (1) Use the pdmod command to increase the size of the RDAREA storing the index; (2) Use the pdhold command to shut down the RDAREA storing the index; (3) Use the pdrorg command to create the index in the batch mode; (4) Back up the RDAREA storing the index; (5) Use the pdrels command to release the RDAREA from shutdown status

(1) Use the pdmod command to increase the size of the RDAREA storing the index

If an error occurs because the RDAREA is too small, use the pdmod command to increase the size of the RDAREA storing the index (RDAREA2). For details about increasing the size of RDAREAs, see 15.3 Increasing the size of an RDAREA (RDAREA expansion).

Do not perform this operation when a sort processing error occurs. Take remedial action based on the error message that was issued.

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

 
pdhold -r RDAREA2

This operation is not required if the RDAREA is already shut down.

(3) Use the pdrorg command to create the index in the batch mode

 
pdrorg -k ixmk -t TABLE1 /pdrorg/rorg01

Using as input information the index information file that was created when reloading (or data loading) was performed, create the index in the batch mode.

(4) Back up the RDAREA storing the index

Because you created the index in the batch mode 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).

(5) 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.

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

(1) Use the pdmod command to increase the size of the RDAREA storing the index

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

(3) Use the pdrorg command to create the index in the batch mode

(4) Back up the RDAREA storing the index

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