pdorbegin (Commit a database for online reorganization)
Function
The pdorbegin command places specified original RDAREAs and replica RDAREAs of a specified generation in the replica group in online reorganization hold status.
When a table is specified, the command processes all RDAREAs related to that table and places each original RDAREA and the specified generation of replica RDAREAs in the replica group in online reorganization hold status. For details about related RDAREAs, see pdrdrefls. To also process the related areas in the constraint definition, specify the -c option. For details, see the description of the -c option.
Once you execute the pdorbegin command, any transaction that accesses an RDAREA in the replica group that contains the specified original RDAREA is placed in wait status until the pdorchg command has executed.
To release online reorganization hold status, specify the -u option.
You can execute the pdorbegin command only when HiRDB Staticizer Option has been installed and the pd_max_reflect_process_count and pd_inner_replica_control operands have both been specified in the system definition.
Executor
HiRDB administrator
Format
Format 1 (for placing RDAREAs in online reorganization hold status and releasing them from this status):
pdorbegin {-r original-RDAREA-name[,original-RDAREA-name]... |
Format 2 (for releasing a shared RDAREA or a shared table from online reorganization hold status (applicable to a HiRDB/Parallel Server only)):
pdorbegin {-r original-RDAREA-name[,original-RDAREA-name]... |
Options
Specifies the names of RDAREAs that are to be placed in online reorganization hold status.
<identifier> ((authorization identifier: 1-8, table identifier: 1-30))
Specifies the name of a table that is to be placed in online reorganization hold status.
The command processes the RDAREAs related to the specified table and places each original RDAREA and the specified generation of replica RDAREAs in the replica group in online reorganization hold status.
When the -t option is specified, the number of RDAREAs storing the specified table must not exceed 4,096.
When the authorization identifier is omitted, the pdorbegin command assumes the authorization identifier set in the PDUSER environment variable at the time of execution. If the PDUSER environment variable has not been set, the command assumes the user name specified in the logon window.
If the authorization identifier or table identifier is enclosed in double quotation marks ("), the command treats it as being case sensitive. If it is not enclosed in double quotation marks ("), the command treats it as in all uppercase letters. If you are using sh (Bourne shell), csh (C shell), or ksh (Korn shell), you must enclose the entire identifier in single quotation marks (').
Specifies servers for which the processing is to be performed. The following guidelines apply to specifying the -s option:
Specifies the generation number of the replica RDAREAs in the replica group that are to be placed in online reorganization hold status.
You cannot specify 0, which is the generation number of original RDAREAs.
Specifies the lock-release wait time in seconds for the online reorganization hold.
When this option is omitted, the command assumes the value of the pd_lck_wait_timeout operand in the system definition. If the value of the pd_lck_wait_timeout operand is 0 in the system definition, the command assumes 3,600.
Specifies that online reorganization hold is to be released. When this option is specified, the -r and -t options must also be specified.
When the processing target includes a shared RDAREA, processing is performed at all back-end servers in the batch mode. If it is not possible to release all the target RDAREAs from online reorganization hold status, an error results. If the shared RDAREA needs to be released from online reorganization hold status for each server for reasons such as a specific back-end server being inactive, you can specify the -s option to release the online reorganization hold.
When you release online reorganization hold, you must specify the same resources as when the processing target was placed in online reorganization hold status (otherwise, an error occurs). The following table shows the relationships between the options specified when the processing target was placed in online reorganization hold status and the options that are specified when it is released from online reorganization hold status:
pdorbegin command options when online reorganization hold is released | pdorbegin command options when the processing target was placed in online reorganization hold status | ||
---|---|---|---|
-r RDAREA | -t table | -t table -c ref | |
-r RDAREA -u | Y# | N | N |
-t table -u | N | Y | N |
-t table -c ref | N | N | Y |
Specifies that the associated RDAREAs in the constraint definition are also to be placed in online reorganization hold status. When you specify this option, you must also specify the -t option. Specifying this option without specifying the -t option results in an error.
Specifies that only the updated columns are to be applied during reflection processing for online reorganization when the pdorend command is executed. For notes about the -e option specification, see the manual HiRDB Staticizer Option Version 7 Description and User's Guide.
Rules
Processing target | Option | Whether or not executable | Execution range | Command execution format | |||||
---|---|---|---|---|---|---|---|---|---|
-t | -r | -s | -u | -c | |||||
Table | Non-partitioned table (including shared tables for HiRDB/Single Server) | S | ![]() | ![]() | ![]() | ![]() | Y | All related RDAREAs2 | Format 1 |
S | ![]() | ![]() | S | ![]() | Y | ||||
S | ![]() | S | ![]() | ![]() | Y1 | RDAREAs related to the specified back-end server2 | |||
S | ![]() | S | S | ![]() | Y1 | ||||
S | ![]() | ![]() | ![]() | S | Y | All related RDAREAs3 | |||
S | ![]() | ![]() | S | S | Y | ||||
S | ![]() | S | ![]() | S | Y1 | All RDAREAs related to the specified back-end server3 | |||
S | ![]() | S | S | S | Y1 | ||||
Row-partitioned table | S | ![]() | ![]() | ![]() | ![]() | Y | All related RDAREAs2 | ||
S | ![]() | ![]() | S | ![]() | Y | ||||
S | ![]() | S | ![]() | ![]() | Y1 | RDAREAs related to the specified back-end server2 | |||
S | ![]() | S | S | ![]() | Y1 | ||||
S | ![]() | ![]() | ![]() | S | Y | All related RDAREAs3 | |||
S | ![]() | ![]() | S | S | Y | ||||
S | ![]() | S | ![]() | S | Y1 | All RDAREAs related to the specified back-end server3 | |||
S | ![]() | S | S | S | Y1 | ||||
Shared table (applicable to a HiRDB/Parallel Server only) | S | ![]() | ![]() | ![]() | ![]() | Y | RDAREAs related to all back-end servers2 | ||
S | ![]() | ![]() | S | ![]() | Y | Format 2 | |||
S | ![]() | S | ![]() | ![]() | N | Not applicable | Format 1 | ||
S | ![]() | S | S | ![]() | Y | RDAREAs related to the specified back-end server2 | Format 2 | ||
S | ![]() | ![]() | ![]() | S | Y | RDAREAs related to all back-end servers3 | Format 1 | ||
S | ![]() | ![]() | S | S | Y | Format 2 | |||
S | ![]() | S | ![]() | S | N | Not applicable | Format 1 | ||
S | ![]() | S | S | S | Y | RDAREAs related to the specified back-end server3 | Format 2 | ||
RDAREA | Non-shared RDAREA only | ![]() | S | ![]() | ![]() | ![]() | Y | Only the specified RDAREAs | Format 1 |
![]() | S | ![]() | S | ![]() | Y | ||||
![]() | S | S | ![]() | ![]() | N | Not applicable | |||
![]() | S | S | S | ![]() | N | ||||
![]() | S | ![]() | ![]() | S | N | ||||
Shared RDAREA only | ![]() | S | ![]() | ![]() | ![]() | Y | All back-end servers | ||
![]() | S | ![]() | S | ![]() | Y | Format 2 | |||
![]() | S | S | ![]() | ![]() | N | Not applicable | Format 1 | ||
![]() | S | S | S | ![]() | Y | Specified back-end servers | Format 2 | ||
![]() | S | ![]() | ![]() | S | N | Not applicable | Format 1 | ||
Both non-shared and shared RDAREAs | ![]() | S | ![]() | ![]() | ![]() | Y | All back-end servers | Format 1 | |
![]() | S | ![]() | S | ![]() | Y | Format 2 | |||
![]() | S | S | ![]() | ![]() | N | Not applicable | Format 1 | ||
![]() | S | S | S | ![]() | N | Format 2 | |||
![]() | S | ![]() | ![]() | S | N | Format 1 |
Notes