Tables

Problem: Table Compression

How do I compress a table in order to reduce the number of extents and restore them to one contiguous chunk?

Solution: Exports, Alters, or Alter Fragment

There are several ways to do this, depending upon which version of the IDS engine your have.

• Export the table to a flatfile, drop and rebuild the table, and import the table back into the newly built table.

• ALTER INDEX TO CLUSTER (requires enough space for a duplicate copy of the table.

• ALTER FRAGMENT ON TABLE tablename INIT in spacename. This works for later versions of IDS and is the fastest, most efficient method.