Business Intelligence Tutorial
Reorganizing a table rearranges it in physical storage, eliminating
fragmentation and making sure that the table is stored efficiently in the
database. You can also use reorganization to control the order in which
the rows of a table are stored, usually according to an index.
To reorganize the LOOKUP_MARKET table:
- From the DB2 Control Center, right-click on the LOOKUP_MARKET table and
click Reorganize.
The Reorganize Table window opens.
- In the Using system temporary table space field, specify the
name of the table space where the table being reorganized can be temporarily
stored. If you do not specify a table space, the temporary copy of the
table is stored in the same table space where the table currently
resides.
- In the Using index field, specify the index to use to
reorganize the table rows. If you do not specify an index, the table
rows are reorganized without regard to order.
- Click Reorganize Now to reorganize the table
immediately. Click Schedule to schedule the reorganization
for a specific date and time.

[ Top of Page | Previous Page | Next Page | Table of Contents ]