8.1.1 Functions of pdrorg

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

ClassificationUsepdrorg function
ABCDEFG
TableImproving table storage efficiency (use pddbst to check)Y[Figure][Figure]Y[Figure][Figure][Figure]
Message KFPH00212-I or KFPH22017-I issuedY[Figure][Figure]Y[Figure][Figure][Figure]
Expected search performance not obtainedY[Figure][Figure]Y[Figure][Figure][Figure]
Migrating data to another table[Figure]YY[Figure][Figure][Figure][Figure]
Modifying table partitioning conditions[Figure]YY[Figure][Figure][Figure][Figure]
Using unload data for pdload's input data file or with a UAP[Figure]Y[Figure][Figure][Figure][Figure][Figure]
Reorganizing tables for unloading purposes separately from reloading purposes[Figure]YY[Figure][Figure][Figure][Figure]
IndexSpecifying -i n during execution of pdload or pdrorg[Figure][Figure][Figure][Figure]Y[Figure][Figure]
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[Figure][Figure][Figure][Figure]Y[Figure][Figure]
Creating plug-in index in delayed batch creation mode[Figure][Figure][Figure][Figure]Y[Figure][Figure]
Releasing used free index storage pages that resulted from addition, deletion, or updating of a large amount of data[Figure][Figure][Figure][Figure][Figure]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[Figure][Figure][Figure][Figure][Figure]Y[Figure]
Creating an index in uncreated status after executing CREATE INDEX specifying EMPTY[Figure][Figure][Figure][Figure][Figure]Y[Figure]
Re-creating a plug-in index[Figure][Figure][Figure][Figure][Figure]Y[Figure]
Specifying -i x during the execution of pdload[Figure][Figure][Figure][Figure][Figure]Y[Figure]
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

* 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