Example 3 (Moving RDAREAs to a different back-end server in the same unit)

In this example, RDAREAs are moved to a different back-end server in the same unit.

RDAREA1 contains a non-row-partitioned table (TABLE1).
An index (INDEX1) and a LOB column (LOB1) are defined for TABLE1. The index is stored in RDAREA2 and the LOB data is stored in RDAREA3.
The HiRDB files configuring these RDAREAs are as follows:
RDAREA1: /area1/rdarea1
RDAREA2: /area2/rdarea2
RDAREA3: /area3/rdarea3

Organization of this subsection: (1) Estimate memory requirements; (2) Use the pdcopy command to back up the RDAREAs; (3) Use the pdhold command to place the RDAREAs being moved in shutdown and closed status; (4) Create a control statements file for the pdmod command; (5) Use the pdmod command to move the RDAREAs; (6) Use the pdstop command to terminate HiRDB normally; (7) Use the pdstart command to start HiRDB normally; (8) Use the pdcopy command to back up the RDAREAs

(1) Estimate memory requirements

Estimate memory requirements for the target back-end server. For details about estimating memory requirements, see the HiRDB Version 9 Installation and Design Guide.

(2) Use the pdcopy command to back up the RDAREAs

 
pdcopy -m /rdarea/mast/mast01 -M r -a -b /pdcopy/backup01 -p /pdcopy/list01

Explanation

-m: Specifies the name of the first HiRDB file in the master directory RDAREA.

-M: Specifies the backup acquisition mode.

-a: Specifies that all RDAREAs are to be backed up.: Because the master directory RDAREA and the data dictionary RDAREAs are updated when an RDAREA is moved, we recommend that you back up all RDAREAs at this time.

-b: Specifies the name of the backup file.

-p: Specifies the output destination of the pdcopy command's processing results listing.

For details about making backups, see 6. Backup Procedures.

(3) Use the pdhold command to place the RDAREAs being moved in shutdown and closed status

(4) Create a control statements file for the pdmod command

Create a control statements file (/pdmod/move01) containing a move rdarea statement for the pdmod command. The following shows the contents of this control statements file:

 
move rdarea RDAREA1,RDAREA2,RDAREA3                1
   to bes2;                                        2

Explanation

Specifies the names of the RDAREAs being moved.
Specifies the name of the target server.

(5) Use the pdmod command to move the RDAREAs

 
pdmod -a /pdmod/move01

Explanation: -a: Specifies the name of the control statements file for the pdmod command.

(6) Use the pdstop command to terminate HiRDB normally

(7) Use the pdstart command to start HiRDB normally

(8) Use the pdcopy command to back up the RDAREAs

 
pdcopy -m /rdarea/mast/mast01 -M r -a -b /pdcopy/backup02 -p /pdcopy/list02

Explanation: -m: Specifies the name of the first HiRDB file in the master directory RDAREA.; -M: Specifies the backup acquisition mode.; -a: Specifies that all RDAREAs are to be backed up. Because the master directory RDAREA and the data dictionary RDAREAs are updated when an RDAREA is moved, we recommend that you back up all RDAREAs at this time.; -b: Specifies the name of the backup file.; -p: Specifies the output destination of the pdcopy command's processing results listing.; For details about making backups, see 6. Backup Procedures.

15.9.4 Example 3 (Moving RDAREAs to a different back-end server in the same unit)