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), SAP Sybase IQ returns A dbspace has reached its maximum file size. To prevent this problem:

Periodically monitor space usage.
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 SAP Sybase IQ database directory. The .tmp file is located under $IQTMP16/<servername>/tmp, or if $IQTMP16 is not set, under /tmp/.SQLAnywhere/<servername>/tmp.