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. 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 UAPNo shutdownCommand shutdownRef-possible shutdown
OpenClosedOpenClosedOpenClosed
Database structure modification utilityRDAREA addition[Figure][Figure][Figure][Figure][Figure][Figure]
RDAREA deletionNNNYNY
RDAREA re-initializationNNNYNY
RDAREA expansion3YNYNYN
Modification of RDAREA attributeNNNYNY
Definition of an RDAREA replicaOriginal RDAREAYYYYYY
Replica RDAREA[Figure][Figure][Figure][Figure][Figure][Figure]
Copying of RDAREA configuration informationCopy sourceYYYYYY
Copy targetNNNYNY
Integration of RDAREAsOriginal RDAREANNNYNY
Replica RDAREANNNYNY
Database load utility3Y4NY4NY4N
Database reorganization utility3Reorganization (-k rorg)Y2, 4NYNY2, 4N
Unloading (-k unld)YNYNYN
Reloading (-k reld)Y2, 4NYNY2, 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 utility3YNYNYN
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
UAPYNNNY1N
Legend:
Y: Can be executed
N: Cannot be executed
[Figure]: 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.
4For 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 UAPReference- possible backup holdUpdatable backup-holdError shutdown
OpenClosedOpenOpenClosed
Database structure modification utilityRDAREA addition[Figure][Figure][Figure][Figure][Figure]
RDAREA deletionNNNNY
RDAREA re-initializationNNNNY
RDAREA expansion4NNNNN
RDAREA modificationNNNNN
Definition of an RDAREA replicaOriginal RDAREAYYYYY
Replica RDAREA[Figure][Figure][Figure][Figure][Figure]
Copying of RDAREA configuration informationCopy sourceYYYYY
Copy targetNNNNN
Integration of RDAREAsOriginal RDAREANNNNN
Replica RDAREANNNNN
Database load utility4NNNNN
Database reorganization utility4Reorganization (-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 utility4NNNNN
Global buffer residence utilityYNYNN
Rebalancing utilityNNNNN
Database copy utility-M xNYNNY
-M rYYY1NN
-M sYYYYY
Database recovery utilityNNNNY
Database condition analysis utilityYNYNN
Optimizing information collection utilityY2NY2NN
Dictionary import/export utilityNNYNN
Database definition utilityNNYNN
Integrity check utilityYNYNN
Reflection processing for online reorganization (pdorend command)NNNNN
UAPY3NYNN
Legend:
Y: Can be executed
N: Cannot be executed
[Figure]: 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[Figure][Figure][Figure][Figure][Figure][Figure]
RDAREA deletionNYNNNN
RDAREA re-initializationNYNYNY
RDAREA expansion8NNNNYN
RDAREA modificationNNNNNN
Definition of an RDAREA replicaOriginal RDAREAYYYYYY
Replica RDAREA[Figure][Figure][Figure][Figure][Figure][Figure]
Copying of RDAREA configuratin informationCopy sourceYYYYYY
Copy targetNNNNNN
Integration of RDAREAsOriginal RDAREANNNNNN
Replica RDAREANNNNNN
Database load utility8NNNNY3, 10N
Database reorganization utility8Reorganization (-k rorg)NNNNY4, 5, 10N
Unloading (-k unld)NNNNY5N
Reloading (-k reld)NNNNY4, 5, 10N
Batch creation of index (-k ixmk)NNNNY5N
Re-creation of index (-k ixrc)NNNNY5N
Re-organization of index (-k ixor)NNNNY5N
Free page release utility8NNNNYN
Global buffer residence utilityNNNNYN
Rebalancing utilityNNNNNN
Database copy utility-M xNYNNNY
-M rNNNNYY
-M sYYNNYY
Database recovery utilityNYNYNN
Database condition analysis utilityNNNNY9N
Optimizing information collection utilityNNNNN7N
Dictionary import/export utilityNN[Figure][Figure][Figure][Figure]
Database definition utilityNN[Figure][Figure][Figure][Figure]
Integrity check utilityNNY11N12YN
Reflection processing for online reorganization (pdorend command)NNNNYN
UAPY1NY2Y2Y6Y6
Legend:
Y: Can be executed
N: Cannot be executed
[Figure]: 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.

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[Figure][Figure][Figure][Figure][Figure][Figure]
RDAREA deletionNNNYNY
RDAREA re-initializationNNNYNY
RDAREA expansion4YYYNYN
Modification of RDAREA attributeNNNYNY
Definition of an RDAREA replicaOriginal RDAREAYYYYYY
Replica RDAREA[Figure][Figure][Figure][Figure][Figure][Figure]
Copying of RDAREA configuration informationCopy sourceYYYYYY
Copy targetNNNYNY
Integration of RDAREAsOriginal RDAREANNNYNY
Replica RDAREANNNYNY
Database load utility4Y5Y5Y5NY5Y5
Database reorganization utility4Reorganization (-k rorg)Y3, 5Y3, 5YNY3, 5Y3, 5
Unloading (-k unld)YYYNYY
Reloading (-k reld)Y3, 5Y3, 5YNY3, 53, 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 utility4YYYNYY
Global buffer residence utilityYYNNYY
Rebalancing utilityYYYNYY
Database copy utility-M xNYNYNY
-M rYYYYYY
-M sYYYYYY
Database recovery utilityNNNYNN
Database condition analysis utilityYYYNYY
Optimizing information collection utilityYYNNYY
Dictionary import/export utility1[Figure][Figure][Figure][Figure][Figure][Figure]
Database definition utilityYNNNNN
Integrity check utilityYYNNNN
Reflection processing for online reorganization (pdorend command)NNNNNN
UAPYYNNY2Y2
Legend:
Y: Can be executed
N: Cannot be executed
[Figure]: 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.
5For 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 UAPRef-possible backup holdUpdatable backup-holdError shutdown
OpenClosedOpenClosedOpenClosed
Database structure modification utilityRDAREA addition[Figure][Figure][Figure][Figure][Figure][Figure]
RDAREA deletionNNNNNY
RDAREA re-initializationNNNNNY
RDAREA expansion5NNNNNN
RDAREA modificationNNNNNN
Definition of an RDAREA replicaOriginal RDAREAYYYYYY
Replica RDAREA[Figure][Figure][Figure][Figure][Figure][Figure]
Copying of RDAREA configuration informationCopy sourceYYYYYY
Copy targetNNNNNN
Integration of RDAREAsOriginal RDAREANNNNNN
Replica RDAREANNNNNN
Database load utility5NNNNNN
Database reorganization utility5Reorganization (-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 utility5NNNNNN
Global buffer residence utilityYYYYNN
Rebalancing utilityNNNNNN
Database copy utility-M xNYNYNY
-M rYYY1Y1NN
-M sYYYYYY
Database recovery utilityNNNNNY
Database condition analysis utilityYYYYNN
Optimizing information collection utilityY3Y3Y3Y3NN
Dictionary import/export utility2[Figure][Figure][Figure][Figure][Figure][Figure]
Database definition utilityNNYYNN
Integrity check utilityNNYYNN
Reflection processing for online reorganization (pdorend command)NNNNNN
UAPY4Y4YYNN
Legend:
Y: Can be executed
N: Cannot be executed
[Figure]: 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[Figure][Figure]NN[Figure][Figure]
RDAREA deletionNYNNNN
RDAREA re-initializationNYNYNY
RDAREA expansion9NNNNYN
RDAREA modificationNNNNNN
Definition of an RDAREA replicaOriginal RDAREAYYYYYY
Replica RDAREA[Figure][Figure][Figure][Figure][Figure][Figure]
Copying of RDAREA configuration informationCopy sourceYYYYYY
Copy targetNNNNNN
Integration of RDAREAsOriginal RDAREANNNNNN
Replica RDAREANNNNNN
Database load utility9NNNNY5, 11Y5, 11
Database reorganization utility9Reorganization (-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 utility9NNNNYY
Global buffer residence utilityNNNNYY
Rebalancing utilityNNNNNN
Database copy utility-M xNYNNNY
-M rNNNNYY
-M sYYNNNY
Database recovery utilityNYNYNN
Database condition analysis utilityNNNNY10Y10
Optimizing information collection utilityNNNNN8N
Dictionary import/export utility1[Figure][Figure][Figure][Figure][Figure][Figure]
Database definition utilityNN[Figure][Figure][Figure][Figure]
Integrity check utilityNNY12Y12YY
Reflection processing for online reorganization (pdorend command)NNNNYY
UAPY2Y2Y3Y3Y7Y7
Legend:
Y: Can be executed
N: Cannot be executed
[Figure]: 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 Appendix 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.