Uncompressing tables and table fragments

Uncompress tables and table fragments that were previously compressed.

Prerequisite: For the space optimization actions, the HCL OpenAdmin Tool (OAT) for Informix® requires HCL Informix 11.50.xC6 or later.
Uncompressing also stops compression of insert and update operations, deactivates the compression dictionary, and allocates new pages for rows that do not fit on their original pages.

To uncompress tables and table fragments:

  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 and fragments.
  4. Click Actions > Optimize Space.
  5. Select Uncompress.
  6. Optional: To place an exclusive lock on the tables and fragments to prevent access to the data during the uncompress operation, select Offline.

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

Parent topic: Optimizing storage space
Copyright© 2018 HCL Technologies Limited