Assume you determined in step (1) that the HiRDB files system area has no free space. In order to increase the size of the RDAREA when you reinitialize it, you must use one of the following methods to prepare a HiRDB file system area:

1. Allocate a new HiRDB file system area that is larger than the existing HiRDB file system area.
2. Allocate a new HiRDB file system area in addition to the existing HiRDB file system area.
3. Expand the existing HiRDB file system area.

This example uses method 1 to prepare a HiRDB file system area.

 
pdfmkfs -n 100 -l 10 -k DB -i /rdarea/area02
 

 
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. When an RDAREA is reinitialized, other RDAREAs are also updated as explained in 6.3 RDAREAs to be backed up together. Therefore, you must also back up other RDAREAs as shown in section 6.3. In this example, all RDAREAs are 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.

A control statements file (/pdrorg/unld01) is created for the unload statement of the pdrorg command. The following are the contents of the control statements file:

 
unload /unld/unldfile1
 

Explanation

Specifies the name of the unload file.

 
pdrorg -k unld -j -t TABLE1 /pdrorg/unld01
 

Explanation

-k: Specifies unld for unloading.

-j: Specifies that one of the following types of tables is to be unloaded:

• Table containing a LOB column
• Table in which is defined an abstract data type with the LOB attribute

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

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

A control statements file (/pdmod/init01) is created for the initialize rdarea statement of the pdmod command. The following are the contents of the control statements file:

 
initialize rdarea RDAREA1                               1
   with reconstruction                                  2
   file name "/rdarea/area02/file01"                    3
      initial 3000 segments;                            4
 

Explanation

The newly created HiRDB file system area is allocated for RDAREA1.

1. Specifies the RDAREA (RDAREA1) that is to be reinitialized.
2. Because the file structure is being changed from what it was before reinitialization, specify with reconstruction.
3. Specifies the HiRDB file comprising the RDAREA.
4. Specifies the number of HiRDB file segments.

 
pdmod -a /pdmod/init01
 

Explanation

-a: Specifies the name of the control statements file for the pdmod command created in step (9).

A control statements file (/pdrorg/reld01) is created for the unload, index, and sort statements of the pdrorg command. The following are the contents of the control statements file:

 
unload /unld/unldfile                      1
index INDEX1 /unld/index_inf               2
sort /tmp/sortwork                         3
 

Explanation

1. Specifies the name of the unload log file.
2. Specifies an index identifier (INDEX1) and the name of the index information file (/unld/index_inf).
3. Specifies the name of the work directory for sorting.

 
pdrorg -k reld -j -t TABLE1 /pdrorg/reld01
 

Explanation

To also create the index (INDEX1) at the same time, the -i option is omitted and the index is created in the batch mode.

-k: Specifies reld for reloading.

-j: Specifies that one of the following types of tables is to be reloaded:

• Table containing a LOB column
• Table in which is defined an abstract data type with the LOB attribute

-t: Specifies the name of the table that is to be reloaded.

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

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

When an RDAREA is reinitialized, other RDAREAs are also updated as explained in 6.3 RDAREAs to be backed up together. Therefore, you must also back up other RDAREAs as shown in section 6.3. In this example, all RDAREAs are backed up. For details about making backups, see 6. Backup Procedures.

 
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.