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
	Definition of an RDAREA replica	Original RDAREA	Y	Y	Y	Y	Y	Y
		Replica RDAREA	--	--	--	--	--	--
	Copying of RDAREA configuration information	Copy source	Y	Y	Y	Y	Y	Y
		Copy target	N	N	N	Y	N	Y
	Integration of RDAREAs	Original RDAREA	N	N	N	Y	N	Y
		Replica RDAREA	N	N	N	Y	N	Y
Database load utility#3			Y#4	N	Y#4, #5	N	Y#4, #5	N
Database reorganization utility#3	Reorganization (-k rorg)		Y#2, #4	N	Y	N	Y#2, #4	N
	Unloading (-k unld)		Y	N	Y	N	Y	N
	Reloading (-k reld)		Y#2, #4	N	Y	N	Y#2, #4	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#3			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
Reflection processing for online reorganization (pdorend command)			N	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: This cannot be executed if the original RDAREA in online reorganization hold status in the same replica group is the current RDAREA.

#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 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		--	--	--	--	--
	RDAREA re-initialization		N	N	N	N	Y
	RDAREA expansion#4		N	N	N	N	N
	RDAREA modification		N	N	N	N	N
	Definition of an RDAREA replica	Original RDAREA	Y	Y	Y	Y	Y
		Replica RDAREA	--	--	--	--	--
	Copying of RDAREA configuration information	Copy source	Y	Y	Y	Y	Y
		Copy target	N	N	N	N	N
	Integration of RDAREAs	Original RDAREA	N	N	N	N	N
		Replica RDAREA	N	N	N	N	N
Database load utility#4			N	N	N	N	N
Database reorganization utility#4	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#4			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
Reflection processing for online reorganization (pdorend command)			N	N	N	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.

#4: This cannot be executed if the original RDAREA in online reorganization hold status in the same replica group is the current RDAREA.

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		Synchronization shutdown		Online reorganization hold
			Open	Closed	Open	Closed	Open	Closed
Database structure modification utility	RDAREA addition		--	--	--	--	--	--
	RDAREA deletion		N	Y	N	N	N	N
	RDAREA re-initialization		N	Y	N	Y	N	Y
	RDAREA expansion#8		N	N	N	N	Y	N
	RDAREA modification		N	N	N	N	N	N
	Definition of an RDAREA replica	Original RDAREA	Y	Y	Y	Y	Y	Y
		Replica RDAREA	--	--	--	--	--	--
	Copying of RDAREA configuration information	Copy source	Y	Y	Y	Y	Y	Y
		Copy target	N	N	N	N	N	N
	Integration of RDAREAs	Original RDAREA	N	N	N	N	N	N
		Replica RDAREA	N	N	N	N	N	N
Database load utility#8			N	N	N	N	Y#3, #10, #13	N
Database reorganization utility#8	Reorganization (-k rorg)		N	N	N	N	Y#4, #5, #10	N
	Unloading (-k unld)		N	N	N	N	Y#5	N
	Reloading (-k reld)		N	N	N	N	Y#4,# 5, #10	N
	Batch creation of index (-k ixmk)		N	N	N	N	Y#5	N
	Re-creation of index (-k ixrc)		N	N	N	N	Y#5	N
	Re-organization of index (-k ixor)		N	N	N	N	Y#5	N
Free page release utility#8			N	N	N	N	Y	N
Global buffer residence utility			N	N	N	N	Y	N
Rebalancing utility			N	N	N	N	N	N
Database copy utility	-M x		N	Y	N	N	N	Y
	-M r		N	N	N	N	Y	Y
	-M s		Y	Y	N	N	Y	Y
Database recovery utility			N	Y	N	Y	N	N
Database condition analysis utility			N	N	N	N	Y#9	N
Optimizing information collection utility			N	N	N	N	N#7	N
Dictionary import/export utility			N	N	--	--	--	--
Database definition utility			N	N	--	--	--	--
Integrity check utility			N	N	Y#11	N#12	Y	N
Reflection processing for online reorganization (pdorend command)			N	N	N	N	Y	N
Audit log output utility for JP1/NETM/Audit			N	N	Y#11	N#12	Y	N
UAP			Y#1	N	Y#2	Y#2	Y#6	Y#6

Legend:

Y: Can be executed

N: Cannot be executed

--: Not applicable

config: configuration

#1: Only the PURGE TABLE statement can be executed.

#2: A utility or UAP will be placed in lock-release wait status.

#3: The utility cannot be executed if the creation mode, no-log mode (or pre-update log acquisition mode), or the number of local buffer sectors for batch output is specified for a replica RDAREA, or on a table for which a LOB column has been defined.

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

#5: This cannot be executed on a replica RDAREA.

#6: Only an SQL statement in the log acquisition mode that accesses the current RDAREA can be executed (except in the case of the CREATE TABLE, CREATE INDEX, ALTER TABLE, DROP TABLE, DROP INDEX, DROP SCHEMA, PURGE TABLE, or LOCK statement).

#7: The utility can be executed if -c lvl1 is specified for the replica RDAREA.

#8: This cannot be executed if the original RDAREA in online reorganization hold status in the same replica group is the current RDAREA.

#9: This cannot be executed when the -s option is specified.

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

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

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

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

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
	Definition of an RDAREA replica	Original RDAREA	Y	Y	Y	Y	Y	Y
		Replica RDAREA	--	--	--	--	--	--
	Copying of RDAREA configuration information	Copy source	Y	Y	Y	Y	Y	Y
		Copy target	N	N	N	Y	N	Y
	Integration of RDAREAs	Original RDAREA	N	N	N	Y	N	Y
		Replica RDAREA	N	N	N	Y	N	Y
Database load utility#4			Y#5	Y#5, #7	Y#5, #7	N	Y#5, #7	Y#5, #7
Database reorganization utility#4	Reorganization (-k rorg)		Y#3, #5	Y#3, 5	Y	N	Y#3, #5	Y#3, #5
	Unloading (-k unld)		Y	Y	Y	N	Y	Y
	Reloading (-k reld)		Y#3, #5	Y#3, #5	Y	N	Y#3, #5	#3, #5
	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#4			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#6	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
Reflection processing for online reorganization (pdorend command)			N	N	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: This cannot be executed if the original RDAREA in online reorganization hold status in the same replica group is the current RDAREA.

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

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

#7: 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#5		N	N	N	N	N	N
	RDAREA modification		N	N	N	N	N	N
	Definition of an RDAREA replica	Original RDAREA	Y	Y	Y	Y	Y	Y
		Replica RDAREA	--	--	--	--	--	--
	Copying of RDAREA configuration information	Copy source	Y	Y	Y	Y	Y	Y
		Copy target	N	N	N	N	N	N
	Integration of RDAREAs	Original RDAREA	N	N	N	N	N	N
		Replica RDAREA	N	N	N	N	N	N
Database load utility#5			N	N	N	N	N	N
Database reorganization utility#5	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#5			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
Reflection processing for online reorganization (pdorend command)			N	N	N	N	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.

#5: This cannot be executed if the original RDAREA in online reorganization hold status in the same replica group is the current RDAREA.

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		Synchronization shutdown		Online reorganization hold
			Open	Closed	Open	Closed	Open	Closed
Database structure modification utility	RDAREA addition		--	--	N	N	--	--
	RDAREA deletion		N	Y	N	N	N	N
	RDAREA re-initialization		N	Y	N	Y	N	Y
	RDAREA expansion#9		N	N	N	N	Y	N
	RDAREA modification		N	N	N	N	N	N
	Definition of an RDAREA replica	Original RDAREA	Y	Y	Y	Y	Y	Y
		Replica RDAREA	--	--	--	--	--	--
	Copying of RDAREA configuration information	Copy source	Y	Y	Y	Y	Y	Y
		Copy target	N	N	N	N	N	N
	Integration of RDAREAs	Original RDAREA	N	N	N	N	N	N
		Replica RDAREA	N	N	N	N	N	N
Database load utility#9			N	N	N	N	Y5, 11, 13	Y5, 11, 13
Database reorganization utility#9	Reorganization (-k rorg)		N	N	N	N	Y4, 6, 11	Y4, 6, 11
	Unloading (-k unld)		N	N	N	N	Y6	Y6
	Reloading (-k reld)		N	N	N	N	Y4, 6, 11	Y4, 6, 11
	Batch creation of index (-k ixmk)		N	N	N	N	Y6	Y6
	Re-creation of index (-k ixrc)		N	N	N	N	Y6	Y6
	Re-organization of index (-k ixor)		N	N	N	N	Y6	Y6
Free page release utility#9			N	N	N	N	Y	Y
Global buffer residence utility			N	N	N	N	Y	Y
Rebalancing utility			N	N	N	N	N	N
Database copy utility	-M x		N	Y	N	N	N	Y
	-M r		N	N	N	N	Y	Y
	-M s		Y	Y	N	N	N	Y
Database recovery utility			N	Y	N	Y	N	N
Database condition analysis utility			N	N	N	N	Y#10	Y#10
Optimizing information collection utility			N	N	N	N	N#8	N
Dictionary import/export utility1			--	--	--	--	--	--
Database definition utility			N	N	--	--	--	--
Integrity check utility			N	N	Y#12	Y#12	Y	Y
Reflection processing for online reorganization (pdorend command)			N	N	N	N	Y	Y
Audit log output utility for JP1/NETM/Audit			N	N	Y#12	Y#12	Y	Y
UAP			Y#2	Y#2	Y#3	Y#3	Y#7	Y#7

Legend:

Y: Can be executed

N: Cannot be executed

--: Not applicable

config: configuration

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

#2: Only the PURGE TABLE statement can be executed.

#3: A utility or UAP will be placed in lock-release wait status.

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

#5: The utility cannot be executed if the creation mode, no-log mode (or pre-update log acquisition mode), or the number of local buffer sectors for batch output is specified for a replica RDAREA, or on a table for which a LOB column has been defined.

#6: This cannot be executed on a replica RDAREA.

#7: Only an SQL statement in the log acquisition mode that accesses the current RDAREA can be executed (except in the case of the CREATE TABLE, CREATE INDEX, ALTER TABLE, DROP TABLE, DROP INDEX, DROP SCHEMA, PURGE TABLE, or LOCK statement).

#8: The utility can be executed if -c lvl1 is specified for the replica RDAREA.

#9: This cannot be executed if the original RDAREA in online reorganization hold status in the same replica group is the current RDAREA.

#10: This cannot be executed when the -s option is specified.

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

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

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