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.
Avoid using IN SYSTEM on CREATE TABLE statements.
Issue COMMIT statements after running system stored procedures.
Issue COMMIT statements after long-running transactions
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.