The catalog store contains the metadata for the
SAP Sybase IQ database.
Metadata describes the layout of tables, columns, and indexes. The catalog store
is sometimes referred to simply as the catalog.
- The SYSTEM dbspace – The catalog dbspace SYSTEM contains metadata for your database,
stored in the same format as tables in a SQL Anywhere
relational database system. SQL Anywhere can exist with or
without SAP Sybase IQ. You may have
SQL Anywhere-style tables in your catalog store along
with your SAP Sybase IQ tables, or you may have a separate
SQL Anywhere database. Each catalog dbspace contains
exactly one file.
- Other catalog dbspaces – you can create SQL Anywhere tables
in a separate dbspace from the SYSTEM dbspace.
You can preallocate space to your catalog store by executing an ALTER DBSPACE statement.