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 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 expansion3 | 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 utility3 | Y4 | N | Y4 | N | Y4 | N | ||
Database reorganization utility3 | Reorganization (-k rorg) | Y2, 4 | N | Y | N | Y2, 4 | N | |
Unloading (-k unld) | Y | N | Y | N | Y | N | ||
Reloading (-k reld) | Y2, 4 | N | Y | N | Y2, 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 utility3 | 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 | ||
UAP | Y | N | N | N | Y1 | N |
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 expansion4 | 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 utility4 | N | N | N | N | N | ||
Database reorganization utility4 | 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 utility4 | 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 | Y1 | 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 | Y2 | N | Y2 | 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 | ||
UAP | Y3 | N | Y | N | N |
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 expansion8 | 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 configuratin 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 utility8 | N | N | N | N | Y3, 10 | N | ||
Database reorganization utility8 | Reorganization (-k rorg) | N | N | N | N | Y4, 5, 10 | N | |
Unloading (-k unld) | N | N | N | N | Y5 | N | ||
Reloading (-k reld) | N | N | N | N | Y4, 5, 10 | N | ||
Batch creation of index (-k ixmk) | N | N | N | N | Y5 | N | ||
Re-creation of index (-k ixrc) | N | N | N | N | Y5 | N | ||
Re-organization of index (-k ixor) | N | N | N | N | Y5 | N | ||
Free page release utility8 | 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 | Y9 | N | ||
Optimizing information collection utility | N | N | N | N | N7 | N | ||
Dictionary import/export utility | N | N | ![]() | ![]() | ![]() | ![]() | ||
Database definition utility | N | N | ![]() | ![]() | ![]() | ![]() | ||
Integrity check utility | N | N | Y11 | N12 | Y | N | ||
Reflection processing for online reorganization (pdorend command) | N | N | N | N | Y | N | ||
UAP | Y1 | N | Y2 | Y2 | Y6 | Y6 |
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 expansion4 | 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 utility4 | Y5 | Y5 | Y5 | N | Y5 | Y5 | ||
Database reorganization utility4 | Reorganization (-k rorg) | Y3, 5 | Y3, 5 | Y | N | Y3, 5 | Y3, 5 | |
Unloading (-k unld) | Y | Y | Y | N | Y | Y | ||
Reloading (-k reld) | Y3, 5 | Y3, 5 | Y | N | Y3, 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 utility4 | 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 | 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 | Y | Y | N | Y | Y | ||
Optimizing information collection utility | Y | Y | N | N | Y | Y | ||
Dictionary import/export utility1 | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ||
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 | ||
UAP | Y | Y | N | N | Y2 | Y2 |
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 expansion5 | 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 utility5 | N | N | N | N | N | N | ||
Database reorganization utility5 | 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 utility5 | 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 | Y1 | Y1 | 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 | Y3 | Y3 | Y3 | Y3 | N | N | ||
Dictionary import/export utility2 | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ||
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 | ||
UAP | Y4 | Y4 | Y | Y | N | N |
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 expansion9 | 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 utility9 | N | N | N | N | Y5, 11 | Y5, 11 | ||
Database reorganization utility9 | 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 utility9 | 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 | Y10 | Y10 | ||
Optimizing information collection utility | N | N | N | N | N8 | N | ||
Dictionary import/export utility1 | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ||
Database definition utility | N | N | ![]() | ![]() | ![]() | ![]() | ||
Integrity check utility | N | N | Y12 | Y12 | Y | Y | ||
Reflection processing for online reorganization (pdorend command) | N | N | N | N | Y | Y | ||
UAP | Y2 | Y2 | Y3 | Y3 | Y7 | Y7 |