The database reorganization utility (pdrorg) is used to maintain tables and indexes. Table 8-1 lists the use and functions of pdrorg, and Figure 8-1 shows an overview of the functions of pdrorg.
Table 8-1 Use and functions of pdrorg
Classification | Use | pdrorg function | ||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | ||
Table | Improving table storage efficiency (use pddbst to check) | Y | ![]() | ![]() | Y | ![]() | ![]() | ![]() |
Message KFPH00212-I or KFPH22017-I issued | Y | ![]() | ![]() | Y | ![]() | ![]() | ![]() | |
Expected search performance not obtained | Y | ![]() | ![]() | Y | ![]() | ![]() | ![]() | |
Migrating data to another table | ![]() | Y | Y | ![]() | ![]() | ![]() | ![]() | |
Modifying table partitioning conditions | ![]() | Y | Y | ![]() | ![]() | ![]() | ![]() | |
Using unload data for pdload's input data file or with a UAP | ![]() | Y | ![]() | ![]() | ![]() | ![]() | ![]() | |
Reorganizing tables for unloading purposes separately from reloading purposes | ![]() | Y | Y | ![]() | ![]() | ![]() | ![]() | |
Index | Specifying -i n during execution of pdload or pdrorg | ![]() | ![]() | ![]() | ![]() | Y | ![]() | ![]() |
Loading data in units of RDAREAs using pdload on a table with non-partitioned indexes, or reorganizing and reloading data in units of RDAREAs using pdrorg | ![]() | ![]() | ![]() | ![]() | Y | ![]() | ![]() | |
Creating plug-in index in delayed batch creation mode | ![]() | ![]() | ![]() | ![]() | Y | ![]() | ![]() | |
Releasing used free index storage pages that resulted from addition, deletion, or updating of a large amount of data | ![]() | ![]() | ![]() | ![]() | ![]() | Y* | Y* | |
Reinitializing an RDAREA to which only indexes were stored using pdmod and then restoring the indexes from the RDAREA in the initialized status | ![]() | ![]() | ![]() | ![]() | ![]() | Y | ![]() | |
Creating an index in uncreated status after executing CREATE INDEX specifying EMPTY | ![]() | ![]() | ![]() | ![]() | ![]() | Y | ![]() | |
Re-creating a plug-in index | ![]() | ![]() | ![]() | ![]() | ![]() | Y | ![]() | |
Specifying -i x during the execution of pdload | ![]() | ![]() | ![]() | ![]() | ![]() | Y | ![]() |
* Normally execute index reorganization. Index re-creation involves a data search in the table, but index reorganization does not; therefore, processing speed is faster with index reorganization.
Figure 8-1 Overview of pdrorg functions