Appendix C.2 Availability of utility or UAP execution depending on RDAREA status

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 UAPNo shutdownCommand shutdownRef-possible shutdown
OpenClosedOpenClosedOpenClosed
Database structure modification utilityRDAREA addition------------
RDAREA deletionNNNYNY
RDAREA re-initializationNNNYNY
RDAREA expansion#3YNYNYN
Modification of RDAREA attributeNNNYNY
Definition of an RDAREA replicaOriginal RDAREAYYYYYY
Replica RDAREA------------
Copying of RDAREA configuration informationCopy sourceYYYYYY
Copy targetNNNYNY
Integration of RDAREAsOriginal RDAREANNNYNY
Replica RDAREANNNYNY
Database load utility#3Y#4NY#4, #5NY#4, #5N
Database reorganization utility#3Reorganization (-k rorg)Y#2, #4NYNY#2, #4N
Unloading (-k unld)YNYNYN
Reloading (-k reld)Y#2, #4NYNY#2, #4N
Batch creation of index (-k ixmk)YNYNYN
Re-creation of index (-k ixrc)YNYNYN
Re-organization of index (-k ixor)YNYNYN
Free page release utility#3YNYNYN
Global buffer residence utilityYNNNYN
Rebalancing utilityYNYNYN
Database copy utility-M xNYNYNY
-M rYYYYYY
-M sYYYYYY
Database recovery utilityNNNYNN
Database condition analysis utilityYNYNYN
Optimizing information collection utilityYNNNYN
Dictionary import/export utilityYNNNNN
Database definition utilityYNNNNN
Integrity check utilityYNNNNN
Reflection processing for online reorganization (pdorend command)NNNNNN
Audit log output utility for JP1/NETM/AuditYNNNYN
UAPYNNNY#1N
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 UAPReference- possible backup holdUpdatable backup-holdError shutdown
OpenClosedOpenOpenClosed
Database structure modification utilityRDAREA addition----------
RDAREA deletion----------
RDAREA re-initializationNNNNY
RDAREA expansion#4NNNNN
RDAREA modificationNNNNN
Definition of an RDAREA replicaOriginal RDAREAYYYYY
Replica RDAREA----------
Copying of RDAREA configuration informationCopy sourceYYYYY
Copy targetNNNNN
Integration of RDAREAsOriginal RDAREANNNNN
Replica RDAREANNNNN
Database load utility#4NNNNN
Database reorganization utility#4Reorganization (-k rorg)NNNNN
Unloading (-k unld)YNYNN
Reloading (-k reld)NNNNN
Batch creation of index (-k ixmk)NNNNN
Re-creation of index (-k ixrc)NNNNN
Re-organization of index (-k ixor)NNNNN
Free page release utility#4NNNNN
Global buffer residence utilityYNYNN
Rebalancing utilityNNNNN
Database copy utility-M xNYNNY
-M rYYY#1NN
-M sYYYYY
Database recovery utilityNNNNY
Database condition analysis utilityYNYNN
Optimizing information collection utilityY#2NY#2NN
Dictionary import/export utilityNNYNN
Database definition utilityNNYNN
Integrity check utilityYNYNN
Reflection processing for online reorganization (pdorend command)NNNNN
Audit log output utility for JP1/NETM/AuditYNYNN
UAPY#3NYNN
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 UAPNo-log shutdownSynchronization shutdownOnline reorganization hold
OpenClosedOpenClosedOpenClosed
Database structure modification utilityRDAREA addition------------
RDAREA deletionNYNNNN
RDAREA re-initializationNYNYNY
RDAREA expansion#8NNNNYN
RDAREA modificationNNNNNN
Definition of an RDAREA replicaOriginal RDAREAYYYYYY
Replica RDAREA------------
Copying of RDAREA configuration informationCopy sourceYYYYYY
Copy targetNNNNNN
Integration of RDAREAsOriginal RDAREANNNNNN
Replica RDAREANNNNNN
Database load utility#8NNNNY#3, #10, #13N
Database reorganization utility#8Reorganization (-k rorg)NNNNY#4, #5, #10N
Unloading (-k unld)NNNNY#5N
Reloading (-k reld)NNNNY#4,# 5, #10N
Batch creation of index (-k ixmk)NNNNY#5N
Re-creation of index (-k ixrc)NNNNY#5N
Re-organization of index (-k ixor)NNNNY#5N
Free page release utility#8NNNNYN
Global buffer residence utilityNNNNYN
Rebalancing utilityNNNNNN
Database copy utility-M xNYNNNY
-M rNNNNYY
-M sYYNNYY
Database recovery utilityNYNYNN
Database condition analysis utilityNNNNY#9N
Optimizing information collection utilityNNNNN#7N
Dictionary import/export utilityNN--------
Database definition utilityNN--------
Integrity check utilityNNY#11N#12YN
Reflection processing for online reorganization (pdorend command)NNNNYN
Audit log output utility for JP1/NETM/AuditNNY#11N#12YN
UAPY#1NY#2Y#2Y#6Y#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 UAPNo shutdownCommand shutdownRef-possible shutdown
OpenClosedOpenClosedOpenClosed
Database structure modification utilityRDAREA addition------------
RDAREA deletionNNNYNY
RDAREA re-initializationNNNYNY
RDAREA expansion#4YYYNYN
Modification of RDAREA attributeNNNYNY
Definition of an RDAREA replicaOriginal RDAREAYYYYYY
Replica RDAREA------------
Copying of RDAREA configuration informationCopy sourceYYYYYY
Copy targetNNNYNY
Integration of RDAREAsOriginal RDAREANNNYNY
Replica RDAREANNNYNY
Database load utility#4Y#5Y#5, #7Y#5, #7NY#5, #7Y#5, #7
Database reorganization utility#4Reorganization (-k rorg)Y#3, #5Y#3, 5YNY#3, #5Y#3, #5
Unloading (-k unld)YYYNYY
Reloading (-k reld)Y#3, #5Y#3, #5YNY#3, #5#3, #5
Batch creation of index (-k ixmk)YYYNYY
Re-creation of index (-k ixrc)YYYNYY
Re-organization of index (-k ixor)YYYNYY
Free page release utility#4YYYNYY
Global buffer residence utilityYYNNYY
Rebalancing utilityYYYNYY
Database copy utility-M xNN#6NYNY
-M rYYYYYY
-M sYYYYYY
Database recovery utilityNNNYNN
Database condition analysis utilityYYYNYY
Optimizing information collection utilityYYNNYY
Dictionary import/export utility#1------------
Database definition utilityYNNNNN
Integrity check utilityYYNNNN
Reflection processing for online reorganization (pdorend command)NNNNNN
Audit log output utility for JP1/NETM/AuditYYNNYY
UAPYYNNY#2Y#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 UAPRef-possible backup holdUpdatable backup-holdError shutdown
OpenClosedOpenClosedOpenClosed
Database structure modification utilityRDAREA addition------------
RDAREA deletionNNNNNY
RDAREA re-initializationNNNNNY
RDAREA expansion#5NNNNNN
RDAREA modificationNNNNNN
Definition of an RDAREA replicaOriginal RDAREAYYYYYY
Replica RDAREA------------
Copying of RDAREA configuration informationCopy sourceYYYYYY
Copy targetNNNNNN
Integration of RDAREAsOriginal RDAREANNNNNN
Replica RDAREANNNNNN
Database load utility#5NNNNNN
Database reorganization utility#5Reorganization (-k rorg)NNNNNN
Unloading (-k unld)YYYYNN
Reloading (-k reld)NNNNNN
Batch creation of index (-k ixmk)NNNNNN
Re-creation of index (-k ixrc)NNNNNN
Re-organization of index (-k ixor)NNNNNN
Free page release utility#5NNNNNN
Global buffer residence utilityYYYYNN
Rebalancing utilityNNNNNN
Database copy utility-M xNYNYNY
-M rYYY#1Y#1NN
-M sYYYYYY
Database recovery utilityNNNNNY
Database condition analysis utilityYYYYNN
Optimizing information collection utilityY#3Y#3Y#3Y#3NN
Dictionary import/export utility#2------------
Database definition utilityNNYYNN
Integrity check utilityNNYYNN
Reflection processing for online reorganization (pdorend command)NNNNNN
Audit log output utility for JP1/NETM/AuditYYYYNN
UAPY#4Y#4YYNN
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 UAPNo-log shutdownSynchronization shutdownOnline reorganization hold
OpenClosedOpenClosedOpenClosed
Database structure modification utilityRDAREA addition----NN----
RDAREA deletionNYNNNN
RDAREA re-initializationNYNYNY
RDAREA expansion#9NNNNYN
RDAREA modificationNNNNNN
Definition of an RDAREA replicaOriginal RDAREAYYYYYY
Replica RDAREA------------
Copying of RDAREA configuration informationCopy sourceYYYYYY
Copy targetNNNNNN
Integration of RDAREAsOriginal RDAREANNNNNN
Replica RDAREANNNNNN
Database load utility#9NNNNY5, 11, 13Y5, 11, 13
Database reorganization utility#9Reorganization (-k rorg)NNNNY4, 6, 11Y4, 6, 11
Unloading (-k unld)NNNNY6Y6
Reloading (-k reld)NNNNY4, 6, 11Y4, 6, 11
Batch creation of index (-k ixmk)NNNNY6Y6
Re-creation of index (-k ixrc)NNNNY6Y6
Re-organization of index (-k ixor)NNNNY6Y6
Free page release utility#9NNNNYY
Global buffer residence utilityNNNNYY
Rebalancing utilityNNNNNN
Database copy utility-M xNYNNNY
-M rNNNNYY
-M sYYNNNY
Database recovery utilityNYNYNN
Database condition analysis utilityNNNNY#10Y#10
Optimizing information collection utilityNNNNN#8N
Dictionary import/export utility1------------
Database definition utilityNN--------
Integrity check utilityNNY#12Y#12YY
Reflection processing for online reorganization (pdorend command)NNNNYY
Audit log output utility for JP1/NETM/AuditNNY#12Y#12YY
UAPY#2Y#2Y#3Y#3Y#7Y#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).