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
Database load utilityY#3NY#3, #4NY#3, #4N
Database reorganization utilityReorganization (-k rorg)Y#2, #3NYNY#2, #3N
Unloading (-k unld)YNYNYN
Reloading (-k reld)Y#2, #3NYNY#2, #3N
Batch creation of index (-k ixmk)YNYNYN
Re-creation of index (-k ixrc)YNYNYN
Re-organization of index (-k ixor)YNYNYN
Free page release utilityYNYNYN
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
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: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 UAPReference- possible backup holdUpdatable backup-holdError shutdown
OpenClosedOpenOpenClosed
Database structure modification utilityRDAREA addition----------
RDAREA deletionNNNNY
RDAREA re-initializationNNNNY
RDAREA expansionNNNNN
RDAREA modificationNNNNN
Database load utilityNNNNN
Database reorganization utilityReorganization (-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 utilityNNNNN
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
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.

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 shutdown
OpenClosed
Database structure modification utilityRDAREA addition----
RDAREA deletionNY
RDAREA re-initializationNY
RDAREA expansionNN
RDAREA modificationNN
Database load utilityNN
Database reorganization utilityReorganization (-k rorg)NN
Unloading (-k unld)NN
Reloading (-k reld)NN
Batch creation of index (-k ixmk)NN
Re-creation of index (-k ixrc)NN
Re-organization of index (-k ixor)NN
Free page release utilityNN
Global buffer residence utilityNN
Rebalancing utilityNN
Database copy utility-M xNY
-M rNN
-M sYY
Database recovery utilityNY
Database condition analysis utilityNN
Optimizing information collection utilityNN
Dictionary import/export utilityNN
Database definition utilityNN
Integrity check utilityNN
Audit log output utility for JP1/NETM/AuditNN
UAPY#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 UAPNo shutdownCommand shutdownRef-possible shutdown
OpenClosedOpenClosedOpenClosed
Database structure modification utilityRDAREA addition------------
RDAREA deletionNNNYNY
RDAREA re-initializationNNNYNY
RDAREA expansion#4YYYNYN
Modification of RDAREA attributeNNNYNY
Database load utilityY#4Y#4, #6Y#4, #6NY#4, #6Y#4, #6
Database reorganization utilityReorganization (-k rorg)Y#3, #4Y#3, #4YNY#3, 4Y#3, #4
Unloading (-k unld)YYYNYY
Reloading (-k reld)Y#3, #4Y#3, #4YNY#3, #4#3, #4
Batch creation of index (-k ixmk)YYYNYY
Re-creation of index (-k ixrc)YYYNYY
Re-organization of index (-k ixor)YYYNYY
Free page release utilityYYYNYY
Global buffer residence utilityYYNNYY
Rebalancing utilityYYYNYY
Database copy utility-M xNN#5NYNY
-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
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: 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 UAPRef-possible backup holdUpdatable backup-holdError shutdown
OpenClosedOpenClosedOpenClosed
Database structure modification utilityRDAREA addition------------
RDAREA deletionNNNNNY
RDAREA re-initializationNNNNNY
RDAREA expansionNNNNNN
RDAREA modificationNNNNNN
Database load utilityNNNNNN
Database reorganization utilityReorganization (-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 utilityNNNNNN
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
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.

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 shutdown
OpenClosed
Database structure modification utilityRDAREA addition----
RDAREA deletionNY
RDAREA re-initializationNY
RDAREA expansionNN
RDAREA modificationNN
Database load utilityNN
Database reorganization utilityReorganization (-k rorg)NN
Unloading (-k unld)NN
Reloading (-k reld)NN
Batch creation of index (-k ixmk)NN
Re-creation of index (-k ixrc)NN
Re-organization of index (-k ixor)NN
Free page release utilityNN
Global buffer residence utilityNN
Rebalancing utilityNN
Database copy utility-M xNY
-M rNN
-M sYY
Database recovery utilityNY
Database condition analysis utilityNN
Optimizing information collection utilityNN
Dictionary import/export utility1----
Database definition utilityNN
Integrity check utilityNN
Audit log output utility for JP1/NETM/AuditNN
UAPY#Y#
Legend:
Y: Can be executed
N: Cannot be executed
--: Not applicable
config: configuration
#: Only the PURGE TABLE statement can be executed.