![[Contents]](FIGURE/CONTENT.GIF)
Nonstop Database, HiRDB Version 9 Command Reference
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
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
![[Figure]](FIGURE/ZU080010.GIF)
All Rights Reserved. Copyright (C) 2014, Hitachi, Ltd.