8.2.2 Cross-reference by purpose

Required options and control statements depend on the type of reorganization.

The options listed in (1) and the control statements are mandatory. The items in (2) through (4) 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 attribute of the table being reorganized
(3) Information to be specified depending on the type of unload data file or LOB data unload file
(4) Information to be specified depending on the reorganization method

(1) Required items

ItemReference
OptionControl statement
Type of pdrorg processing-k rorg(1)[Figure][Figure]
Reorganization of a user-defined table (can be omitted because the default is -c user)-c user(2)[Figure][Figure]
Name of the table to be reorganized-t(3)[Figure][Figure]
File containing the control statementscontrol-information-filename(19)[Figure][Figure]
Information about an unload data file[Figure][Figure]unload statement8.9.4

[Figure]: Not applicable

(2) Information to be specified depending on the attribute of the table being reorganized

ItemReference location
OptionControl statement
Indexes are defined-i(6)index statement8.9.5
-o(15)idxwork statement8.9.7
sort statement8.9.8
There are LOB columns-j(9)lobunld statement8.9.9
There are columns of abstract data type provided by a plug-in (LOB attribute)-j(9)unld_func statement8.9.13
reld_func statement8.9.14
Consecutive trailing spaces are to be removed from a table with suppress option specified*-S(14)[Figure][Figure]
There are constraint definitions[Figure][Figure]constraint statement8.9.15
Inner replica facility is used-q(18)[Figure][Figure]

[Figure]: Not applicable

* This option helps you reduce the processing time and the size of the unload data file.

(3) Information to be specified depending on the type of unload data file or LOB data unload file

ItemReference location
OptionControl statement
Integrating data into a single file-g(8)[Figure][Figure]
Using EasyMT-f(12)mtguide statement8.9.3
emtdef statement8.9.3
Using HiRDB files-f(12)[Figure][Figure]
Specifying the unload data storage sequence (in order of cluster key, index, or data storage)-b(13)[Figure][Figure]

[Figure]: Not applicable

(4) Information to be specified depending on the reorganization method

ItemReference location
OptionControl statement
Reorganizing only some of the RDAREAs for a row-partitioned table-r(4)[Figure][Figure]
Acquiring or not acquiring database update log-l(5)[Figure][Figure]
Specifying synchronization points when reorganizing a large amount of data[Figure][Figure]option statement8.9.16
Monitoring the execution time of pdrorg[Figure][Figure]option statement8.9.16
Forcibly restoring the table status to normal[Figure][Figure]option statement8.9.16
Changing the pdrorg executor's user authorization identifier to a value other than the value of environment variable PDUSER1-u(10)[Figure][Figure]
Reorganizing in batch input/output mode using local buffer instead of global buffer2-n(11)[Figure][Figure]
Changing a reorganization 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]
Using the same space character in the entire table data[Figure][Figure]option statement8.9.16
Changing the percentage of free space in table and index during reorganization3[Figure][Figure]option statement8.9.16
Obtaining tuning information during the execution of pdrorg[Figure][Figure]report statement8.9.17
Deleting unneeded data during reorganization[Figure][Figure]unlduoc statement8.9.10

[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 a table or index whose percentage of free space is 0).