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. 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) through 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) 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)

UtilityNo shutdownCommand shutdownRef-possible shutdown
OpenClosedOpenClosedOpenClosed
Database structure modification utilityYSSSSS
Database load utilityYNYNYN
Database reorganization utilityYNYNYN
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)

UtilityReference-possible backup holdUpdatable backup-holdError shutdown
OpenClosedOpenOpenClosed
Database structure modification utilitySSYSS
Database load utilityNNYNN
Database reorganization utilityNNYNN
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)

UtilityNo-log shutdown
OpenClosed
Database structure modification utilitySS
Database load utilityNN
Database reorganization utilityNN
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)

UtilityNo shutdownCommand shutdownRef-possible shutdown
OpenClosedOpenClosedOpenClosed
Database structure modification utilityYYSSSY
Database load utilityYYYNYY
Database reorganization utilityYYYNYY
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)

UtilityReference-possible backup holdUpdatable backup-holdError shutdown
OpenClosedOpenClosedOpenClosed
Database structure modification utilitySSYYSS
Database load utilityNNYYNN
Database reorganization utilityNNYYNN
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)

UtilityNo-log shutdown
OpenClosed
Database structure modification utilitySS
Database load utilityNN
Database reorganization utilityNN
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.