8.1.1 Functions of pdrorg

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

ClassificationUsepdrorg function
ABCDEFG
TableImproving table storage efficiency (use pddbst to check)Y----Y------
Message KFPH00212-I or KFPH22017-I issuedY----Y------
Expected search performance not obtainedY----Y------
Migrating data to another table--YY--------
Modifying table partitioning conditions--YY--------
Using unload data for pdload's input data file or with a UAP--Y----------
Reorganizing tables for unloading purposes separately from reloading purposes--YY--------
IndexSpecifying -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--
Legend:
A: Reorganize tables.
B: Unload tables.
C: Reload to tables.
D: Reorganize data dictionary tables.
E: Create indexes in batch.
F: Re-create indexes.
G: Reorganize indexes.
Y: pdrorg's function corresponding to the use
--: Not applicable

#: 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

[Figure]

Explanation:
Reorganizing table: 1 and 2
Unloading table: 1
Reloading table: 2
Reorganizing data dictionary table: 1 and 2
Creating indexes in batch mode: 5
Re-creating indexes: 3 and 5
Reorganizing indexes: 4 and 5