Managing Dbspace Size

Growth of catalog files is normal and varies depending on application and catalog content.

The size of the .db file does not affect performance, and free pages within the .db file are reused as necessary. To minimize catalog file growth:

Avoid using IN SYSTEM on CREATE TABLE statements.
Issue COMMIT statements after running system stored procedures.
Issue COMMIT statements after long-running transactions

If the catalog store cannot extend one of its files (.tmp, .db, or .iqmsg), Sybase IQ returns the error A dbspace has reached its maximum file size. To prevent this problem:

Monitor space usage periodically.
Verify that there are no operating system file size limits (such as Sun Solaris ulimit) where the .tmp, .db, or .iqmsg files are located. The .db and .tmp files are typically in the main Sybase IQ database directory. The .tmp file is located under $IQTMP15/<servername>/tmp, or if $IQTMP15 is not set, under /tmp/.SQLAnywhere/<servername>/tmp.