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
Reflection processing for online reorganization (pdorend command)YSSSSS
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
Reflection processing for online reorganization (pdorend command)SSYSS
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 shutdownSynchronization shutdownOnline reorganization hold
OpenClosedOpenClosedOpenClosed
Database structure modification utilitySSSSYS
Database load utilityNNW#1N#2YN
Database reorganization utilityNNW#1N#2YN
Reflection processing for online reorganization (pdorend command)SSSSYS
Legend:
Y: Can be set to check pending status.
W: Waits until the shutdown status is released and then sets the 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.

#1: A utility or UAP is placed in lock-release wait status until the shutdown status is released. After the shutdown status is released, the utility or UAP can be executed.
#2: A utility or UAP is placed in lock-release wait status until the shutdown status is released. After the shutdown status is released, the utility or UAP can be executed by opening the RDAREA, which has been closed.

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
Reflection processing for online reorganization (pdorend command)YYSSSY
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
Reflection processing for online reorganization (pdorend command)SSYYSS
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 shutdownSynchronization shutdownOnline reorganization hold
OpenClosedOpenClosedOpenClosed
Database structure modification utilitySSSSYY
Database load utilityNNW#W#YY
Database reorganization utilityNNW#W#YY
Reflection processing for online reorganization (pdorend command)SSSSYY
Legend:
Y: Can be set to check pending status.
W: Waits until the shutdown status is released and then sets the 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.

#: A utility or UAP is placed in lock-release wait status until the shutdown status is released. After the shutdown status is released, the utility or UAP can be executed.