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

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

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