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