Whether or not a utility or UAP can be executed depends on the RDAREA's open timing and status. Table C-3 Availability of utility or UAP execution depending on RDAREA status (when open timing is set to INITIAL) (1/3) through Table C-8 Availability of utility or UAP execution depending on RDAREA status (when open timing is set to DEFER or SCHEDULE) (3/3) 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 expansion#3	Y	N	Y	N	Y	N
	Modification of RDAREA attribute	N	N	N	Y	N	Y
Database load utility		Y#3	N	Y#3, #4	N	Y#3, #4	N
Database reorganization utility	Reorganization (-k rorg)	Y#2, #3	N	Y	N	Y#2, #3	N
	Unloading (-k unld)	Y	N	Y	N	Y	N
	Reloading (-k reld)	Y#2, #3	N	Y	N	Y#2, #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
Audit log output utility for JP1/NETM/Audit		Y	N	N	N	Y	N
UAP		Y	N	N	N	Y#1	N

Legend:

Y: Can be executed

N: Cannot be executed

--: Not applicable

config: configuration

Ref: reference

#1: Only a UAP that executes referencing operations can be executed.

#2: A utility or UAP cannot be executed on a falsification prevented table.

#3: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.

#4: The utility cannot be executed when a table is defined by importing data (when pdload -b -W -w all is specified).

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	Y#1	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		Y#2	N	Y#2	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
Audit log output utility for JP1/NETM/Audit		Y	N	Y	N	N
UAP		Y#3	N	Y	N	N

Legend:

Y: Can be executed

N: Cannot be executed

--: Not applicable

#1: A utility or UAP cannot be executed if an updating transaction is being executed.

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

#3: 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
Audit log output utility for JP1/NETM/Audit		N	N
UAP		Y#	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 expansion#4	Y	Y	Y	N	Y	N
	Modification of RDAREA attribute	N	N	N	Y	N	Y
Database load utility		Y#4	Y#4, #6	Y#4, #6	N	Y#4, #6	Y#4, #6
Database reorganization utility	Reorganization (-k rorg)	Y#3, #4	Y#3, #4	Y	N	Y#3, 4	Y#3, #4
	Unloading (-k unld)	Y	Y	Y	N	Y	Y
	Reloading (-k reld)	Y#3, #4	Y#3, #4	Y	N	Y#3, #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	N#5	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 utility#1		--	--	--	--	--	--
Database definition utility		Y	N	N	N	N	N
Integrity check utility		Y	Y	N	N	N	N
Audit log output utility for JP1/NETM/Audit		Y	Y	N	N	Y	Y
UAP		Y	Y	N	N	Y#2	Y#2

Legend:

Y: Can be executed

N: Cannot be executed

--: Not applicable

config: configuration

Ref: Reference

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

#2: Only a UAP that executes referencing operations can be executed.

#3: A utility or UAP cannot be executed on a falsification prevented table.

#4: 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.

#5: The pdcopy command with the -M x option specified can be executed, but if an update SQL statement or a utility (or a command) that updates the database is executed during the processing, the integrity of the data being backed up is not guaranteed.

#6: The utility cannot be executed when a table is defined by importing data (when pdload -b -W -w all is specified).

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	Y#1	Y#1	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		Y#3	Y#3	Y#3	Y#3	N	N
Dictionary import/export utility#2		--	--	--	--	--	--
Database definition utility		N	N	Y	Y	N	N
Integrity check utility		N	N	Y	Y	N	N
Audit log output utility for JP1/NETM/Audit		Y	Y	Y	Y	N	N
UAP		Y#4	Y#4	Y	Y	N	N

Legend:

Y: Can be executed

N: Cannot be executed

--: Not applicable

config: configuration

Ref: Reference

#1: A utility or UAP cannot be executed if an updating transaction is being executed.

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

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

#4: 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
Audit log output utility for JP1/NETM/Audit		N	N
UAP		Y#	Y#

Legend:

Y: Can be executed

N: Cannot be executed

--: Not applicable

config: configuration

#: Only the PURGE TABLE statement can be executed.