Filter
Top Products
CHAPTER 11 Backup and Data Recovery
417
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 Adaptive
Server 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 Adaptive Server 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.