The database reorganization utility (pdrorg) is used to maintain tables and indexes. Table 8-1 Use and functions of pdrorg lists the use and functions of pdrorg, and Figure 8-1 Overview of pdrorg functions 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