Scalable Database Server, HiRDB Version 8 Command Reference

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

Appendix C.3 Whether or not the check pending status can be set

Whether or not a utility can be executed on a referenced table in order to place its referencing table in check pending status depends on the RDAREA open timing and the RDAREA's status. Tables C-9 through C-14 show whether or not the check pending status can be set by a utility depending on the RDAREA's status.

Table C-9 Whether or not the check pending status can be set by a utility depending on the RDAREA's status (when open timing is set to INITIAL) (1/3)

Utility No shutdown Command shutdown Ref-possible shutdown
Open Closed Open Closed Open Closed
Database structure modification utility Y S S S S S
Database load utility Y N Y N Y N
Database reorganization utility Y N Y N Y N

Legend:
Y: Can be set to check pending status.
S: Cannot be set to check pending status. The utility skips this processing and executes the next processing.
N: Cannot be set to check pending status.

Table C-10 Whether or not the check pending status can be set by a utility depending on the RDAREA's status (when open timing is set to INITIAL) (2/3)

Utility Reference-possible backup hold Updatable backup-hold Error shutdown
Open Closed Open Open Closed
Database structure modification utility S S Y S S
Database load utility N N Y N N
Database reorganization utility N N Y N N

Legend:
Y: Can be set to check pending status.
S: Cannot be set to check pending status. The utility skips this processing and executes the next processing.
N: Cannot be set to check pending status.

Table C-11 Whether or not the check pending status can be set by a utility depending on the RDAREA's status (when open timing is set to INITIAL) (3/3)

Utility No-log shutdown
Open Closed
Database structure modification utility S S
Database load utility N N
Database reorganization utility N N

Legend:
S: Cannot be set to check pending status. The utility skips this processing and executes the next processing.
N: Cannot be set to check pending status.

Table C-12 Whether or not the check pending status can be set by a utility depending on the RDAREA's status (when open timing is set to DEFER or SCHEDULE) (1/3)

Utility No shutdown Command shutdown Ref-possible shutdown
Open Closed Open Closed Open Closed
Database structure modification utility Y Y S S S Y
Database load utility Y Y Y N Y Y
Database reorganization utility Y Y Y N Y Y

Legend:
Y: Can be set to check pending status.
S: Cannot be set to check pending status. The utility skips this processing and executes the next processing.
N: Cannot be set to check pending status.

Table C-13 Whether or not the check pending status can be set by a utility depending on the RDAREA's status (when open timing is set to DEFER or SCHEDULE) (2/3)

Utility Reference-possible backup hold Updatable backup-hold Error shutdown
Open Closed Open Closed Open Closed
Database structure modification utility S S Y Y S S
Database load utility N N Y Y N N
Database reorganization utility N N Y Y N N

Legend:
Y: Can be set to check pending status.
S: Cannot be set to check pending status. The utility skips this processing and executes the next processing.
N: Cannot be set to check pending status.

Table C-14 Whether or not the check pending status can be set by a utility depending on the RDAREA's status (when open timing is set to DEFER or SCHEDULE) (3/3)

Utility No-log shutdown
Open Closed
Database structure modification utility S S
Database load utility N N
Database reorganization utility N N

Legend:
S: Cannot be set to check pending status. The utility skips this processing and executes the next processing.
N: Cannot be set to check pending status.