Nonstop Database, HiRDB Version 9 System Operation Guide
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
15.4.5 Example 4 (LOB column is defined)
(1) Use the pdfstatfs command to determine if the HiRDB file system area has free space
(2) Prepare a HiRDB file system area
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:
- Allocate a new HiRDB file system area that is larger than the existing HiRDB file system area.
- Allocate a new HiRDB file system area in addition to the existing HiRDB file system area.
- 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
|
(3) Use the pdhold command to shut down RDAREA1 and RDAREA2
pdhold -r RDAREA1,RDAREA2
|
(4) Use the pdlogswap -d sys -w command to swap the system log files
(5) Use the pdcopy command to back up data
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.
(6) Create the control statements file for the pdrorg command
A control statements file containing the pdrorg command's unload statement (/pdrorg/unld01) is created. The following are the contents of the control statements file:
- Explanation
- Specifies the name of the unload file.
(7) Use the pdrorg command to unload LOB data
pdrorg -k unld -j -t TABLE1 /pdrorg/unld01
|
- Explanation
- -k: Specifies unld in order to unload.
- -j: Specifies that the table to be unloaded contains a LOB column.
- -t: Specifies the name of the table to be unloaded.
- /pdrorg/unld01: Specifies the name of the control statements file for the pdrorg command created in step (6).
(8) Use the pdclose command to close RDAREA2
(9) Create the control statements file for the pdmod command
A control statements file that contains the pdmod command's initialize rdarea statement (/pdmod/init01) is created. The following are the contents of the control statements file:
initialize rdarea RDAREA2 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 RDAREA2.
- Specifies the RDAREA to be reinitialized (RDAREA2).
- Because the file structure is being changed from what it was before reinitialization, specify with reconstruction.
- Specifies the HiRDB file that is to constitute the RDAREA.
- Specifies the number of segments for the HiRDB file.
(10) Use the pdmod command to reinitialize (increase the size of) RDAREA2
- Explanation
- -a: Specifies the name of the control statements file for the pdmod command created in step (9).
(11) Use the pdopen command to open RDAREA2
(12) Use the pdrorg command to reload data of TABLE1
pdrorg -k reld -j -t TABLE1 /pdrorg/unld01
|
- Explanation
- -k: Specifies reld in order to reload.
- -j: Specifies that the table to be reloaded contains a LOB column.
- -t: Specifies the name of the table to be reloaded.
- /pdrorg/unld01: Specifies the name of the control statements file for the pdrorg command created in step (6).
(13) Use the pdlogswap -d sys -w command to swap the system log files
(14) Use the pdcopy command to back up data
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.
(15) Use the pdrels command to release RDAREA1 and RDAREA2 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.
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.