8.7.2 Cross-reference by purpose

Required options and control statements depend on the type of index re-creation.

The options listed in (1) and the control statements are mandatory. The items in (2) are related to the options and control statements presented in the Reference column. For details about the options, see Section 8.9.2.

Organization of this subsection
(1) Required items
(2) Information to be specified depending on the index re-creation method

(1) Required items

ItemReference
OptionControl statement
Type of pdrorg processing-k ixrc(1)[Figure][Figure]
Name of the table subject to index re-creation-t(3)[Figure][Figure]
File containing the control statementscontrol-information-filename(19)[Figure][Figure]
Information about the index information file or index[Figure][Figure]index or idxname statement8.9.5 or 8.9.6
[Figure]: Not applicable

(2) Information to be specified depending on the index re-creation method

ItemReference location
OptionControl statement
Acquiring or not acquiring database update log-l(5)[Figure][Figure]
Changing the pdrorg executor's user authorization identifier to a value other than the value of environment variable PDUSER1-u(10)[Figure][Figure]
Re-creating in batch input/output mode using local buffer instead of global buffer2-n(11)[Figure][Figure]
Automatically deleting index information files after index re-creation-o(15)[Figure][Figure]
Changing an index re-creation status message output interval to a value other than 100,000 lines-m(16)[Figure][Figure]
Monitoring the response time for server-to-server communication-X(17)[Figure][Figure]
Not enough space in the /tmp directory when index is re-created in units of index storage RDAREAs (using the index statement)[Figure][Figure]sort statement8.9.8
Not enough space in the /tmp directory when index is re-created in units of indexes (using the idxname statement)[Figure][Figure]idxwork statement8.9.7
sort statement8.9.8
Monitoring the execution time of pdrorg[Figure][Figure]option statement8.9.16
Changing the percentage of free space in index during index re-creation3[Figure][Figure]option statement8.9.16
The inner replica facility is used-q(18)[Figure][Figure]

[Figure]: Not applicable

1 If omitted, the system assumes the value of the PDUSER environment variable. If the PDUSER environment variable has not been specified, the system assumes the user name in the login window.

2 By specifying the number of batch input/output pages, you can reduce the number of I/O operations because data is input/output in units of specified pages in batch mode.

3 If a space shortage occurs in an RDAREA during execution of pdrorg, you can complete the processing without having to expand the RDAREA temporarily (except for an index whose percentage of free space is 0).