The following are the contents of the control statements file (/pdrorg/rorg01).

(a) HiRDB single server configuration

 
unload /pdrorg/unfile1
 

Explanation

Specifies the name of the unload data file.

(b) HiRDB parallel server configuration

 
unload bes1:/pdrorg/unfile1              1
unload bes2:/pdrorg/unfile2              2
 

Explanation

1. Specifies the name of the unload data file at a back-end server (bes1).
2. Specifies the name of the unload data file at a back-end server (bes2).

 
pdrorg -k unld -W bin -g -t TABLE1 /pdrorg/rorg01
 

Explanation

-k: Specifies unld in order to unload data.

-W bin: Specifies that the unload data file is to be used as the input file (binary format) for the pdload command.

-g: Specifies that TABLE1 is row-partitioned among multiple servers for a HiRDB parallel server configuration. The unload data files will be combined into a single file.

-t: Specifies the name of the table to be unloaded.

/pdrorg/rorg01: Specifies the name of the control statements file for the pdrorg command created in step (2).

The following are the contents of the control statements file (/pdexp/exp01):

 
-t USR01.TABLE1
 

Explanation

USR01: Name of the schema that owns TABLE1

TABLE1: Name of the table to be exported

 
pdexp -e /pdexp/expfile1 -f /pdexp/exp01
 

Explanation

-e: Specifies the name of the file to be exported.

-f: Specifies the name of the control statements file for the pdexp command created in step (5).

The following are the contents of the control statements file (/pdexp/exp02):

 
-p USR01.PROC1
 

Explanation

USR01: Name of the schema that owns PROC1

PROC1: Name of the stored procedure to be exported

 
pdexp -e /pdexp/expfile2 -f /pdexp/exp02
 

Explanation

-e: Specifies the name of the file to be exported.

-f: Specifies the name of the control statements file for the pdexp command created in step (7).

The unload data file created in step (3) and the export files created in steps (6) and (8) are stored on a medium such as CMT.

The operations at the source system (HiRDB system A) are now completed.

The operations from this point on are performed at the target system (HiRDB system B).

The unload data file and export files stored on a medium such as CMT are copied into the target system.

Before making a backup copy, use the pdlogswap command to swap the system log files.

 
pdlogswap -d sys -w
 

Explanation

For a HiRDB parallel server configuration, specify the -s option and execute the pdlogswap command on each server that is to be backed up.

 
pdcopy -m /rdarea/mast/mast01 -M r
-r RDMAST,RDDIR,RDDIC,DICLOB,RDAREA1,RDAREA2,RDAREA3,RDAREA4,RDAREA5,
RDAREA6 -b /pdcopy/backup01 -p /pdcopy/list01
 

Explanation

The RDAREAs are backed up as a safeguard in the event of errors during database migration. The following RDAREAs must be backed up:

• Master directory RDAREA
• Data directory RDAREA
• Data dictionary RDAREAs
• Data dictionary LOB RDAREAs
• User RDAREAs and user LOB RDAREAs for storing the imported table (RDAREA1 to RDAREA6)

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

-M: Specifies the backup acquisition mode.

-r: Specifies the names of the RDAREAs to be backed up.

-b: Specifies the name of the backup file.

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

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

 
pdexp -i /pdexp/expfile1
 

Explanation

-i: Specifies the name of the file to be imported.

The following are the contents of the control statements file (/pdload/load01).

(a) HiRDB single server configuration

 
source /pdrorg/unfile1                           1
idxwork /pdrorg/idxwork                          2
sort /sortwork                                   3
 

Explanation

1. Specifies the name of the unload data file.
2. Specifies the name of the directory in which an index information file is to be created. The index information file is created under this directory.
3. Specifies the name of the work directory for sorting.

(b) HiRDB parallel server configuration

 
source bes1:/pdrorg/unfile1                     1
idxwork bes1 /pdrorg/idxwork                    2
sort bes1 /sortwork                             3
idxwork bes2 /pdrorg/idxwork                    4
sort bes2 /sortwork                             5
 

Explanation

1. Specifies the name of the unload data file (for bes1).
2. Specifies the name of the directory in which an index information file is to be created (for bes1). The index information file is created under this directory.
3. Specifies the name of the work directory for sorting (for bes1).
4. Specifies the name of the directory in which an index information file is to be created (for bes2). The index information file is created under this directory.
5. Specifies the name of the work directory for sorting (for bes2).

 
pdload -b -W TABLE1 /pdload/load01
 

Explanation

-b: Specifies that binary data is to be loaded.

-W: Specifies that binary format input data created by the pdrorg command is to be used.

TABLE1: Specifies the name of the table subject to data loading.

/pdload/load01: Specifies the name of the control statements file for the pdload command.

Before making a backup copy, use the pdlogswap command to swap the system log files.

 
pdlogswap -d sys -w
 

Explanation

For a HiRDB parallel server configuration, specify the -s option and execute the pdlogswap command on each server that is to be backed up.

 
pdcopy -m /rdarea/mast/mast01 -M r
-r RDMAST,RDDIR,RDDIC,DICLOB,RDAREA1,RDAREA2,RDAREA3,RDAREA4,RDAREA5,
RDAREA6 -b /pdcopy/backup02 -p /pdcopy/list02
 

Explanation

The following RDAREAs must be backed up:

• Master directory RDAREA
• Data directory RDAREA
• Data dictionary RDAREAs
• Data dictionary LOB RDAREAs
• User RDAREAs and user LOB RDAREAs for storing the imported table (RDAREA1 to RDAREA6)

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

-M: Specifies the backup acquisition mode.

-r: Specifies the names of the RDAREAs to be backed up.

-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.

 
pdexp -i /pdexp/expfile2
 

Explanation

-i: Specifies the name of the file to be imported.

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.