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
Reflection processing for online reorganization (pdorend command)	Y	S	S	S	S	S

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
Reflection processing for online reorganization (pdorend command)	S	S	Y	S	S

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		Synchronization shutdown		Online reorganization hold
	Open	Closed	Open	Closed	Open	Closed
Database structure modification utility	S	S	S	S	Y	S
Database load utility	N	N	W1	N2	Y	N
Database reorganization utility	N	N	W1	N2	Y	N
Reflection processing for online reorganization (pdorend command)	S	S	S	S	Y	S

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.

² 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)

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
Reflection processing for online reorganization (pdorend command)	Y	Y	S	S	S	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
Reflection processing for online reorganization (pdorend command)	S	S	Y	Y	S	S

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		Synchronization shutdown		Online reorganization hold
	Open	Closed	Open	Closed	Open	Closed
Database structure modification utility	S	S	S	S	Y	Y
Database load utility	N	N	W*	W*	Y	Y
Database reorganization utility	N	N	W*	W*	Y	Y
Reflection processing for online reorganization (pdorend command)	S	S	S	S	Y	Y

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.