B09. Why use Automatic Space Management?

Mike Walker /xDB Systems

Traditionally, one of the more mundane jobs of a DBA has been to add space when needed.  The introduction of automatic space management in Informix has made that task simpler, and at the same time given the DBA additional ways to perform that task. You can now stretch out cooked chunks, automatically or manually…no more “dbspace is full” errors, and no need to keep adding chunks to a growing dbspace! You can also allocate chunks to a dbspace with a single command, or even let Informix do it for you. This presentation will show how to enable and configure Informix’s space management, and how you can use the feature to make your job easier, while still maintaining control. It will cover some of the things that you now need to plan for, to monitor, and some of the issues that can occur.