Nonstop Database, HiRDB Version 9 System Operation Guide

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

3.5.6 Changing a file's status

Organization of this subsection
(1) Changing the file used as the current file
(2) Placing a reserved file in overwrite enabled status
(3) Reserving a file in overwrite enabled status
(4) Changing a file from extracting status to extraction completed status
(5) Changing a file from overwriting denied status for online reorganization to operating permitted status for online reorganization

(1) Changing the file used as the current file

To use a different file as the current file, the pdlogswap command is executed to swap files. The current file is placed in unswappable target status, and a file in swappable target status becomes the current file. Use this command when the system log information contained in the current file is needed.

The pdlogswap command cannot be executed if there are no files that can be placed in swappable target status.

(2) Placing a reserved file in overwrite enabled status

The pdlogopen command can be used to place a reserved file in overwrite enabled status. When normal startup of HiRDB is executed, such a file will become overwrite disabled.

(3) Reserving a file in overwrite enabled status

The pdlogcls command can be used to reserve a file that is in overwrite enabled status. If there is only one file in overwrite enabled status, it cannot be reserved. A file in overwrite disabled status must not be reserved if it contains system log information needed for system recovery.

(4) Changing a file from extracting status to extraction completed status

The pdlogchg -R command can be used to forcibly change a file's status from extracting to extraction completed. When the file status is changed forcibly in this manner, the system log required by the HiRDB Datareplicator cannot be extracted. Also, the file might not be synchronized to the target database, or data linkage might not be performed. Execute the pdlogchg -R command only in cases such as when an error occurs and it is necessary to re-create the system log file. Do not execute the pdlogchg -R command in any other cases.

(5) Changing a file from overwriting denied status for online reorganization to operating permitted status for online reorganization

The pdlogchg -G command can be used to forcibly change a file from overwriting denied status for online reorganization to overwriting permitted status for online reorganization. When the file status is changed forcibly in this manner, the system log required for update processing will be lost, and it might not be possible to perform updatable online reorganization. Execute the pdlogchg -G command only in cases such as when an error occurs and it is necessary to re-create the system log file. Do not execute the pdlogchg -R command in any other cases.