18.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 2000000​th 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 or not 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.6 Example 6 (Backing up 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

It is recommended that after the command has executed you check whether or not the execution results are correct. For details on how to check command execution results, see the manual HiRDB Version 8 Command Reference.