Automatic space management: If you upgrade to version 11.70, you can configure Informix to automatically expand an existing storage space when the space is full. You can also configure Informix to expand the space before it is full, when its free pages fall below a specified threshold. When you enable and configure automatic storage provisioning, you do not need to manually add storage space to avoid out-of-space errors. Even if you prefer to add space manually, automatic storage expansion greatly simplifies the process of adding space, because you do not need to determine where to get the space.
Defragmenting partitions to merge non-contiguous extents: If you upgrade to version 11.70, you can also defragment partitions to merge noncontiguous extents. Because a frequently updated table can become fragmented over time leading to performance degradation, the ability to merge non-contiguous extents can improve performance. Defragmenting a table brings data rows closer together and avoids partition header page overflow problems.
New SQL administration API functions: You use new SQL administration API task() or admin() functions to implement these new space management features.
New Scheduler task for automatically optimizing data storage: With version 11.70, you can also configure the automatic compressing, shrinking, repacking, and defragmenting of tables and extents by updating the auto_crsd Scheduler task.