Optimizing storage space

Compress tables, indexes, and fragments, consolidate free space (repack), return free space to the dbspace (shrink), and merge extents (defragment). Uncompress tables and table fragments.

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.
Parent topic: How do I manage system space?
Copyright© 2018 HCL Technologies Limited