Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

6.8.3 Operation example

This section provides an example of backing up a user LOB RDAREA (LOB001) under the following operational conditions:

Organization of this subsection
(1) Execute the frozen update command on the user LOB RDAREA (LOB001)
(2) Make a backup
(3) Make backups regularly
(4) Add HiRDB files and expand the user LOB RDAREA (LOB001)
(5) Make a backup
(6) Use the database condition analysis utility (pddbst command) to check for full data pages
(7) If more files with full data pages have been issued, execute the frozen update command
(8) Make a backup
(9) Make backups regularly

(1) Execute the frozen update command on the user LOB RDAREA (LOB001)

 
pddbfrz -r LOB001
 

[Figure]

Explanation
The HiRDB file with full data pages (file02) is placed in frozen update status. Refer to the KFPH27024-I message or use the database condition analysis utility (pddbst command) to confirm the HiRDB files that have been placed in frozen update status.

(2) Make a backup

Back up the user LOB RDAREA (LOB001) using some method other than the database copy utility (pdcopy command). Make the backup in units of the HiRDB files comprising the user LOB RDAREA (LOB001).

[Figure]

Explanation
All the HiRDB files are backed up (file01, file 02, and file 03).

For details about making a backup using methods other than the database copy utility (pdcopy command), see 6.7 Backup acquisition using backup-hold (backup without using the pdcopy command).

(3) Make backups regularly

Make backups on a regular schedule, such as once a week.

[Figure]

Explanation
Only the HiRDB files in permit update status are backed up (file01 and file 03). You do not need to back up the HiRDB file in frozen update status (file02).

(4) Add HiRDB files and expand the user LOB RDAREA (LOB001)

For details about expanding the user LOB RDAREA (LOB001), see 15.3 Increasing the size of an RDAREA (RDAREA expansion).

[Figure]

Explanation
A HiRDB file (file04) is added and the user LOB RDAREA (LOB001) is expanded.

(5) Make a backup

After expanding the user LOB RDAREA (LOB001), back it up. Always make a backup, even if the number of segments used in a file is 0; for the reason, see 6.8.7 Notes.

[Figure]

Explanation
HiRDB files in permit update status (file01, file03, and file04) are backed up. Backing up the HiRDB file in frozen update status (file02) is not necessary.

(6) Use the database condition analysis utility (pddbst command) to check for full data pages

When LOB data is added, additional HiRDB files with full data pages might be issued. Use the database condition analysis utility (pddbst command) to check for files with full data pages. For details about checking for files with full data pages, see 6.8.4 Checking for files with full data pages.

 
pddbst -r LOB001
 

(7) If more files with full data pages have been issued, execute the frozen update command

If more files with full data pages have been issued, as determined in step (6), execute the frozen update command.

 
pddbfrz -r LOB001
 

[Figure]

Explanation
HiRDB files with full data pages (file02 and file03) are placed in frozen update status. Refer to the KFPH27024-I message or use the data condition analysis utility (pddbst command) to confirm the HiRDB files that have been placed in frozen update status.

(8) Make a backup

Back up the user LOB RDAREA.

[Figure]

Explanation
HiRDB files file01, file03, and file04 are backed up; it is not necessary to back up HiRDB file file02.

(9) Make backups regularly

Make backups on a regular schedule, such as once a week.

[Figure]

Explanation
Only the HiRDB files in permit update status are backed up (file01 and file04). You do not need to back up the HiRDB files in frozen update status (file02 and file03).