Managing Disk Space

You are responsible for planning and implementing the layout of information managed by the database server on disks. The way you distribute the data can greatly affect the performance of the database server.

Data Storage, explains the advantages and drawbacks of different disk configurations. Managing Disk Space, describes the actual disk-management tasks.

If you plan to use more than one database server instance on the same computer, refer to Multiple Residency, to familiarize yourself with the issues of multiple residency.

For information on how to fragment tables and indexes over multiple disks to improve performance, concurrency, data availability, and backups, refer to Table Fragmentation and PDQ, and to your IBM Informix: Performance Guide.