Example

Nonstop Database, HiRDB Version 9 System Operation Guide

20.18.2 Example

The database reorganization utility terminated abnormally during reorganization of a table containing 3 million data cases. The number of synchronization points is 1 million.

Organization of this subsection: (1) Check for messages; (2) Use the pdrorg command to execute reloading; (3) Check for messages; (4) Back up the RDAREAs that were reloaded; (5) Use the pdrels command to release RDAREAs in shutdown status

(1) Check for messages

The following messages have been output:

 
KFPL00714-I  unload ended, table=USR01.TABLE1, server=sds01, return code=0
 
KFPL00800-I Loading until 2000000th row committed

Explanation

Message KFPL00714-I indicates that unloading has been completed.
Message KFPL00800-I indicates that reloading of up to 2 million cases has been completed.

(2) Use the pdrorg command to execute reloading

Use the database reorganization utility to reload the remaining 1 million cases and create the index.

 
pdrorg -k reld -t TABLE1 /pdrorg/rorg01

Explanation: Change the specification of the -k option only; change it from rorg to reld. The specifications of other options need not be modified.

(3) Check for messages

Determine whether the database reorganization utility terminated normally by checking for the KFPL00719-I message.

 
KFPL00719-I  Pdrorg terminated, return code=0

(4) Back up the RDAREAs that were reloaded

Because you reloaded the RDAREAs in the pre-update log acquisition mode (default), back up the RDAREAs that were reloaded. For details about backing up RDAREAs, see 6.4.8 Example 8 (backing up specified RDAREAs).

(5) Use the pdrels command to release RDAREAs in shutdown status

Use the pdrels command to release the table-storage and index-storage RDAREAs that are in shutdown status.

 
pdrels -r RDAREA1,RDAREA2,RDAREA3

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