8. Database Reorganization Utility (pdrorg)

This chapter explains the database reorganization utility (pdrorg) for maintaining tables and indexes.

This chapter contains the following sections:

Organization of this chapter
8.1 Overview
8.2 Reorganizing a table
8.3 Unloading a table
8.4 Reloading to a table
8.5 Reorganizing data dictionary tables
8.6 Creating indexes in batch mode
8.7 Re-creating indexes
8.8 Reorganizing indexes
8.9 Command format
8.10 Reorganization using a UOC
8.11 Notes on executing pdrorg on special tables
8.12 Rules and notes
8.13 Database status in the event of an error and recovery method