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 SAP SQL Anywhere
relational database system. SAP SQL Anywhere can exist with or
without SAP Sybase IQ. You may have
SAP SQL Anywhere-style tables in your catalog store along
with your SAP Sybase IQ tables, or you may have a separate
SAP SQL Anywhere database. Each catalog dbspace contains
exactly one file.
- Other catalog dbspaces – you can create SAP 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.