How do I manage system space?
- Monitoring space usage
Review information about space usage and the storage spaces for a database server. For a specific storage space, review information about the space usage and optimization, and the chunks, tables, and indexes in the space. - Managing space usage
Manage the storage space for a database server. - Adding storage space automatically
Configure the database server to add storage space automatically when more space is needed. Add entries to the storage pool that the server can use to expand a space and set the threshold for expanding a space. - 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. - Managing recovery logs
View and manage the checkpoints, logical logs, and physical logs for a database server.
Parent topic: HCL OpenAdmin Tool (OAT) for Informix