Reorganizing a table

Use the Reorganize Table window to reorganize a table. You can reorganize the table immediately or schedule reorganization of the table.

Fields and controls

Authorities and privileges

To reorganize your table immediately:

1. Open the Reorganize Table window.
2. Optional: In the Using system temporary table space field, change the name of the temporary table space where the table being reorganized can be temporarily stored.
3. Optional: In the Using index field, specify an index to use to reorganize the table rows.

   If you specify <none> (the default) the table rows are reorganized without regard to order.

4. Click on Reorganize Now to reorganize the table immediately.

Related information

• Reorganizing table data -- See the Administration Guide
• REORGANIZE TABLE command -- See the Command Reference