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.