In the event that you run out of space to perform an operation, you see a message telling you to add more disk space. Before this occurs, set the options MAIN_RESERVED_DBSPACE_MB and TEMP_RESERVED_DBSPACE_MB. These options provide room for checkpoint, commit, and release savepoint operations so that you can add more space under all conditions. These options are set at run-time to accommodate half of your last dbspace up to 200MB, but may need adjusting, depending on the number of concurrent connections and your IQ page size. Do not wait until you have run out of space to set these options. See Chapter 2, “Database Options” in the Sybase IQ Reference Manual for option details.
