Database Reorganization Utility (pdrorg)

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

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 Processing performance information file; 8.11 Reorganization using a UOC; 8.12 Notes on executing pdrorg on special tables; 8.13 Rules and notes; 8.14 Database status in the event of an error and recovery method

8. Database Reorganization Utility (pdrorg)