Catalog Store (for metadata)

The catalog store is also known as the database file since it has a .db file extension. It may also be referred to as the catalog.

There is one catalog store per SAP Sybase IQ database. It is always created on a file system and consists of one object for the SAP Sybase IQ database. It contains all information needed to manage the database, including metadata stored in the system tables and stored procedures (system and user).

It is also known as the database file and its physical file name is: dbname.db.

The catalog store consists of the SYSTEM and TEMPORARY dbpaces. It is not recommended that you overload the catalog store with additional dbspaces

All the information about tables in a database is held in the system tables within the catalog store. Data from the system tables may be browsed using the Interactive SQL or Sybase Control Center.

The catalog store resembles a SQL Anywhere database as it uses traditional row-based storage, typically on 4K (4096 byte) pages. The page size for the catalog is configured when you create the SAP Sybase IQ database.

For a complete listing of system tables and views, see Reference: Building Blocks, Tables, and Procedures.