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)

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) Check the message; (2) Use the pdmod command to re-initialize the RDAREA storing the index; (3) Use the pdmod command to increase the size of the RDAREA storing the index; (4) Use the pdhold command to shut down 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.

 
pdrels -r RDAREA1

(2) Use the pdmod command to re-initialize the RDAREA storing the index

Use the pdmod command to re-initialize the RDAREA storing the index (RDAREA2). For details about how to re-initialize RDAREAs, see 15.4 Modifying the size or attributes of an RDAREA (RDAREA reinitialization).

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

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

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