Defragmenting extents

Merge extents in tables, indexes, and fragments to reduce the number of extents and to improve query performance.

Prerequisites: For the space optimization actions, the HCL OpenAdmin Tool (OAT) for Informix® requires HCL Informix 11.50.xC6 or later. For the defragment action, OAT requires Informix 11.70 or later. To compress indexes and simple large objects (TEXT and BYTE data types), OAT requires Informix 12.10.

To defragment extents:

  1. On the OAT menu, click Space Administration > Storage.
  2. With the database server selected, expand the Tables and Indexes panel.
  3. Select the tables, indexes, and fragments.
  4. Click Actions > Optimize Space.
  5. Select Defragment extents.
  6. Optional: Select additional actions:
    • To compress the tables, indexes, and fragments, select Compress.
    • To consolidate free space, select Repack.
    • To return any free space to the dbspace, select Shrink.

To monitor the progress of the task, click the Task Status tab.

Copyright© 2018 HCL Technologies Limited