Scalable Database Server, HiRDB Version 8 Command Reference

[Contents][Index][Back][Next]

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 UAP No shutdown Command shutdown Ref-possible shutdown
Open Closed Open Closed Open Closed
Database structure modification utility RDAREA addition [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
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 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
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

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 UAP Reference- possible backup hold Updatable backup-hold Error shutdown
Open Closed Open Open Closed
Database structure modification utility RDAREA addition [Figure] [Figure] [Figure] [Figure] [Figure]
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 [Figure] [Figure] [Figure] [Figure] [Figure]
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

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 UAP No-log shutdown Synchronization shutdown Online reorganization hold
Open Closed Open Closed Open Closed
Database structure modification utility RDAREA addition [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
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 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
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 [Figure] [Figure] [Figure] [Figure]
Database definition utility N N [Figure] [Figure] [Figure] [Figure]
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

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 UAP No shutdown Command shutdown Ref-possible shutdown
Open Closed Open Closed Open Closed
Database structure modification utility RDAREA addition [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
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 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
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 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
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

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 UAP Ref-possible backup hold Updatable backup-hold Error shutdown
Open Closed Open Closed Open Closed
Database structure modification utility RDAREA addition [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
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 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
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 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
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

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 UAP No-log shutdown Synchronization shutdown Online reorganization hold
Open Closed Open Closed Open Closed
Database structure modification utility RDAREA addition [Figure] [Figure] N N [Figure] [Figure]
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 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
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 [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
Database definition utility N N [Figure] [Figure] [Figure] [Figure]
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

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.

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.