Whether or not a utility or UAP can be executed depends on the RDAREA's open timing and status. Tables C-3 through C-8 describe the availability of utility or UAP execution depending on the RDAREA status.

Table C-3 Availability of utility or UAP execution depending on RDAREA status (when open timing is set to INITIAL) (1/3)

Utility or UAP		No shutdown		Command shutdown		Ref-possible shutdown
		Open	Closed	Open	Closed	Open	Closed
Database structure modification utility	RDAREA addition
	RDAREA deletion	N	N	N	Y	N	Y
	RDAREA re-initialization	N	N	N	Y	N	Y
	RDAREA expansion3	Y	N	Y	N	Y	N
	Modification of RDAREA attribute	N	N	N	Y	N	Y
Database load utility		Y3	N	Y3	N	Y3	N
Database reorganization utility	Reorganization (-k rorg)	Y2, 3	N	Y	N	Y2, 3	N
	Unloading (-k unld)	Y	N	Y	N	Y	N
	Reloading (-k reld)	Y2, 3	N	Y	N	Y2, 3	N
	Batch creation of index (-k ixmk)	Y	N	Y	N	Y	N
	Re-creation of index (-k ixrc)	Y	N	Y	N	Y	N
	Re-organization of index (-k ixor)	Y	N	Y	N	Y	N
Free page release utility		Y	N	Y	N	Y	N
Global buffer residence utility		Y	N	N	N	Y	N
Rebalancing utility		Y	N	Y	N	Y	N
Database copy utility	-M x	N	Y	N	Y	N	Y
	-M r	Y	Y	Y	Y	Y	Y
	-M s	Y	Y	Y	Y	Y	Y
Database recovery utility		N	N	N	Y	N	N
Database condition analysis utility		Y	N	Y	N	Y	N
Optimizing information collection utility		Y	N	N	N	Y	N
Dictionary import/export utility		Y	N	N	N	N	N
Database definition utility		Y	N	N	N	N	N
Integrity check utility		Y	N	N	N	N	N
UAP		Y	N	N	N	Y1	N

Legend:

Y: Can be executed

N: Cannot be executed

: Not applicable

config: configuration

Ref: reference

¹ Only a UAP that executes referencing operations can be executed.

² A utility or UAP cannot be executed on a falsification prevented table.

³ For whether or not the referencing table can be placed in check pending status by executing the utility on the referenced table, see C.3 Whether or not the check pending status can be set.

Table C-4 Availability of utility or UAP execution depending on RDAREA status (when open timing is set to INITIAL) (2/3)

Utility or UAP		Reference- possible backup hold		Updatable backup-hold	Error shutdown
		Open	Closed	Open	Open	Closed
Database structure modification utility	RDAREA addition
	RDAREA deletion	N	N	N	N	Y
	RDAREA re-initialization	N	N	N	N	Y
	RDAREA expansion	N	N	N	N	N
	RDAREA modification	N	N	N	N	N
Database load utility		N	N	N	N	N
Database reorganization utility	Reorganization (-k rorg)	N	N	N	N	N
	Unloading (-k unld)	Y	N	Y	N	N
	Reloading (-k reld)	N	N	N	N	N
	Batch creation of index (-k ixmk)	N	N	N	N	N
	Re-creation of index (-k ixrc)	N	N	N	N	N
	Re-organization of index (-k ixor)	N	N	N	N	N
Free page release utility		N	N	N	N	N
Global buffer residence utility		Y	N	Y	N	N
Rebalancing utility		N	N	N	N	N
Database copy utility	-M x	N	Y	N	N	Y
	-M r	Y	Y	Y1	N	N
	-M s	Y	Y	Y	Y	Y
Database recovery utility		N	N	N	N	Y
Database condition analysis utility		Y	N	Y	N	N
Optimizing information collection utility		Y2	N	Y2	N	N
Dictionary import/export utility		N	N	Y	N	N
Database definition utility		N	N	Y	N	N
Integrity check utility		Y	N	Y	N	N
UAP		Y3	N	Y	N	N

Legend:

Y: Can be executed

N: Cannot be executed

: Not applicable

¹ A utility or UAP cannot be executed if an updating transaction is being executed.

² A utility or UAP cannot be executed if the dictionary RDAREA is in reference-possible backup hold status.

³ Only a UAP that executes referencing operations can be executed.

Table C-5 Availability of utility or UAP execution depending on RDAREA status (when open timing is set to INITIAL) (3/3)

Utility or UAP		No-log shutdown
		Open	Closed
Database structure modification utility	RDAREA addition
	RDAREA deletion	N	Y
	RDAREA re-initialization	N	Y
	RDAREA expansion	N	N
	RDAREA modification	N	N
Database load utility		N	N
Database reorganization utility	Reorganization (-k rorg)	N	N
	Unloading (-k unld)	N	N
	Reloading (-k reld)	N	N
	Batch creation of index (-k ixmk)	N	N
	Re-creation of index (-k ixrc)	N	N
	Re-organization of index (-k ixor)	N	N
Free page release utility		N	N
Global buffer residence utility		N	N
Rebalancing utility		N	N
Database copy utility	-M x	N	Y
	-M r	N	N
	-M s	Y	Y
Database recovery utility		N	Y
Database condition analysis utility		N	N
Optimizing information collection utility		N	N
Dictionary import/export utility		N	N
Database definition utility		N	N
Integrity check utility		N	N
UAP		Y1	N

Legend:

Y: Can be executed

N: Cannot be executed

: Not applicable

config: configuration

¹ Only the PURGE TABLE statement can be executed.

Table C-6 Availability of utility or UAP execution depending on RDAREA status (when open timing is set to DEFER or SCHEDULE) (1/3)

Utility or UAP		No shutdown		Command shutdown		Ref-possible shutdown
		Open	Closed	Open	Closed	Open	Closed
Database structure modification utility	RDAREA addition
	RDAREA deletion	N	N	N	Y	N	Y
	RDAREA re-initialization	N	N	N	Y	N	Y
	RDAREA expansion4	Y	Y	Y	N	Y	N
	Modification of RDAREA attribute	N	N	N	Y	N	Y
Database load utility		Y4	Y4	Y4	N	Y4	Y4
Database reorganization utility	Reorganization (-k rorg)	Y3, 4	Y3, 4	Y	N	Y3, 4	Y3, 4
	Unloading (-k unld)	Y	Y	Y	N	Y	Y
	Reloading (-k reld)	Y3, 4	Y3, 4	Y	N	Y3, 4	3, 4
	Batch creation of index (-k ixmk)	Y	Y	Y	N	Y	Y
	Re-creation of index (-k ixrc)	Y	Y	Y	N	Y	Y
	Re-organization of index (-k ixor)	Y	Y	Y	N	Y	Y
Free page release utility		Y	Y	Y	N	Y	Y
Global buffer residence utility		Y	Y	N	N	Y	Y
Rebalancing utility		Y	Y	Y	N	Y	Y
Database copy utility	-M x	N	Y	N	Y	N	Y
	-M r	Y	Y	Y	Y	Y	Y
	-M s	Y	Y	Y	Y	Y	Y
Database recovery utility		N	N	N	Y	N	N
Database condition analysis utility		Y	Y	Y	N	Y	Y
Optimizing information collection utility		Y	Y	N	N	Y	Y
Dictionary import/export utility1
Database definition utility		Y	N	N	N	N	N
Integrity check utility		Y	Y	N	N	N	N
UAP		Y	Y	N	N	Y2	Y2

Legend:

Y: Can be executed

N: Cannot be executed

: Not applicable

config: configuration

Ref: Reference

¹ This utility is not applicable because the RDAREA's open timing can never be DEFER or SCHEDULE.

² Only a UAP that executes referencing operations can be executed.

³ A utility or UAP cannot be executed on a falsification prevented table.

⁴ For whether or not the referencing table can be placed in check pending status by executing the utility on the referenced table, see C.3 Whether or not the check pending status can be set.

Table C-7 Availability of utility or UAP execution depending on RDAREA status (when open timing is set to DEFER or SCHEDULE) (2/3)

Utility or UAP		Ref-possible backup hold		Updatable backup-hold		Error shutdown
		Open	Closed	Open	Closed	Open	Closed
Database structure modification utility	RDAREA addition
	RDAREA deletion	N	N	N	N	N	Y
	RDAREA re-initialization	N	N	N	N	N	Y
	RDAREA expansion	N	N	N	N	N	N
	RDAREA modification	N	N	N	N	N	N
Database load utility		N	N	N	N	N	N
Database reorganization utility	Reorganization (-k rorg)	N	N	N	N	N	N
	Unloading (-k unld)	Y	Y	Y	Y	N	N
	Reloading (-k reld)	N	N	N	N	N	N
	Batch creation of index (-k ixmk)	N	N	N	N	N	N
	Re-creation of index (-k ixrc)	N	N	N	N	N	N
	Re-organization of index (-k ixor)	N	N	N	N	N	N
Free page release utility		N	N	N	N	N	N
Global buffer residence utility		Y	Y	Y	Y	N	N
Rebalancing utility		N	N	N	N	N	N
Database copy utility	-M x	N	Y	N	Y	N	Y
	-M r	Y	Y	Y1	Y1	N	N
	-M s	Y	Y	Y	Y	Y	Y
Database recovery utility		N	N	N	N	N	Y
Database condition analysis utility		Y	Y	Y	Y	N	N
Optimizing information collection utility		Y3	Y3	Y3	Y3	N	N
Dictionary import/export utility2
Database definition utility		N	N	Y	Y	N	N
Integrity check utility		N	N	Y	Y	N	N
UAP		Y4	Y4	Y	Y	N	N

Legend:

Y: Can be executed

N: Cannot be executed

: Not applicable

config: configuration

Ref: Reference

¹ A utility or UAP cannot be executed if an updating transaction is being executed.

² This utility is not applicable because the RDAREA's open timing can never be DEFER or SCHEDULE.

³ A utility or UAP cannot be executed if the dictionary RDAREA is in reference-possible backup hold status.

⁴ Only a UAP that executes referencing operations can be executed.

Table C-8 Availability of utility or UAP execution depending on RDAREA status (when open timing is set to DEFER or SCHEDULE) (3/3)

Utility or UAP		No-log shutdown
		Open	Closed
Database structure modification utility	RDAREA addition
	RDAREA deletion	N	Y
	RDAREA re-initialization	N	Y
	RDAREA expansion	N	N
	RDAREA modification	N	N
Database load utility		N	N
Database reorganization utility	Reorganization (-k rorg)	N	N
	Unloading (-k unld)	N	N
	Reloading (-k reld)	N	N
	Batch creation of index (-k ixmk)	N	N
	Re-creation of index (-k ixrc)	N	N
	Re-organization of index (-k ixor)	N	N
Free page release utility		N	N
Global buffer residence utility		N	N
Rebalancing utility		N	N
Database copy utility	-M x	N	Y
	-M r	N	N
	-M s	Y	Y
Database recovery utility		N	Y
Database condition analysis utility		N	N
Optimizing information collection utility		N	N
Dictionary import/export utility1
Database definition utility		N	N
Integrity check utility		N	N
UAP		Y2	Y2

Legend:

Y: Can be executed

N: Cannot be executed

: Not applicable

config: configuration

¹ This utility is not applicable because the RDAREA's open timing can never be DEFER or SCHEDULE.

² Only the PURGE TABLE statement can be executed.

³ A utility or UAP will be placed in lock-release wait status.

⁴ A utility or UAP cannot be executed on a falsification prevented table.