Optimizing storage space automatically

Configure the database server to automatically compress, repack, shrink, and defragment tables and fragments to optimize data storage.

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

You can enable or disable the Scheduler task that implements the optimization policies. The policies set the thresholds that determine when to compress, shrink, repack, and defragment the tables and fragments. You can update the thresholds for each of these operations or disable any of them. You can also specify when the Scheduler task runs.

Simple large objects (TEXT and BYTE data types) are included when tables and table fragments are compressed.

To configure the database server to optimize storage space automatically:

  1. On the OAT menu, click Space Administration > Storage.
  2. With the database server selected, expand the Tables and Indexes panel.
  3. Click the Server Optimization Policies tab.
  4. Complete the fields on the page.

Copyright© 2018 HCL Technologies Limited