Example 3: When an RDAREA shortage occurs during index reorganization (execution in no-log mode)

Nonstop Database, HiRDB Version 9 System Operation Guide

14.1.5 Example 3: When an RDAREA shortage occurs during index reorganization (execution in 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) Re-initialize the RDAREA storing the index; (2) Use the pdhold command to release the RDAREAs storing the index and the table; (3) Use the pdrorg command to re-create the index; (4) Back up the RDAREAs storing the index and the table; (5) Use the pdrels command to release the RDAREAs storing the index and the table from shutdown status

(1) Re-initialize the RDAREA storing the index

Because the RDAREA storing the index is in error shutdown status, use the pdmod command to re-initialize the RDAREA storing the index and release it from error shutdown status. While doing so, increase the size of the RDAREA storing the index. For details about how to re-initialize RDAREAs, see 15.4 Modifying the size or attributes of an RDAREA (RDAREA reinitialization).

(2) Use the pdhold command to release the RDAREAs storing the index and the table

 
pdhold -r RDAREA1,RDAREA2

(3) Use the pdrorg command to re-create the index

All indexes stored in the re-initialized RDAREA must be re-created.

 
pdrorg -k ixrc -t TABLE01 /pdrorg/rorg01

Explanation

-k: Specifies ixrc, which is used to re-create 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:

 
idxname name=INDEX01
idxwork bes1 /pdrorg
sort bes1 /tmp/sortwork

INDEX01: Index identifier

bes1: Name of the server on which the index information file is created (specified when a HiRDB parallel server configuration is being used)

/pdrorg: Name of the directory in which the index information file is created

bes1: Name of the server on which the work file for sorting is created (specified when a HiRDB parallel server configuration is being used)

/tmp/sortwork: Name of the work directory for sorting

(4) Back up the RDAREAs storing the index and the table

Back up the RDAREAs storing the index and the table (RDAREA1 and 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 RDAREAs storing the index and the table from shutdown status

 
pdrels -r RDAREA1,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.