Controlling the Size of the Catalog Store

An IQ database consists of an IQ store and an underlying catalog store.

BACKUP makes a full backup of the catalog store at the start of every backup, both full and incremental. Ordinarily the catalog store is quite small, containing only the system tables, metadata, and other information Sybase IQ needs to manage your database. However, it is possible to create non-IQ tables in the catalog store. You can improve IQ backup performance by keeping any non-IQ data in a separate SQL Anywhere-only database, rather than in the catalog store.

Backup copies only the latest committed version of the database. Other version pages used by open transactions are not backed up.