Example 2: When an RDAREA shortage occurs during index reorganization (execution in a mode other than no-log mode)

Nonstop Database, HiRDB Version 9 System Operation Guide

14.1.4 Example 2: When an RDAREA shortage occurs during index reorganization (execution in a mode other than no-log mode)

A space shortage in an index-storage RDAREA during index reorganization has caused the pdrorg command to terminate abnormally.

Organization of this subsection: (1) 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) Increase the size of the RDAREA storing the index

For details about increasing the size of RDAREAs, see 15.3 Increasing the size of an RDAREA (RDAREA expansion).

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

 
pdhold -r RDAREA1

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

Using as input information the index information file that was output during index reorganization, perform batch index creation (-k ixmk specification).

 
pdrorg -k ixmk -t TABLE01 /pdrorg/rorg01

Explanation

-k: Specifies ixmk, which is used to perform batch creation of the index.

-t: Specifies the name of the table for which the index is defined.

/pdrorg/rorg01: Specifies the name of the control statements file for the pdrorg command. The following shows an example of a control statements file specification:

 
index INDEX01 RDAREA1 /pdrorg/index_inf01

INDEX01: Index identifier

RDAREA1: Name of the RDAREA storing the index

/pdrorg/index_inf01: Name of the index information file

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

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.