To reorganize all classes and database files in all user schemas that require reorganization
Select the Reorg command from the Schema menu and then select the Reorg All Schemas command from the submenu that is displayed. The Reorg command and the Reorg All Schemas command on the reorganization submenu are enabled only when a schema is marked for reorganization (indicated by a red light in Schema Needs Reorg toolbar button).
The Classes Needing Reorg dialog, shown in the following image, is then displayed, listing all schemas that are marked for reorganization.
The database files and their sizes are displayed at the end of the list, to enable you to estimate the potential disk requirements and time that the reorganization requires.
Perform the actions that you require by checking or unchecking the appropriate check boxes.
For details about the other actions that you can perform, see "Reorganizing Your Schema", in the previous section.