Each type of dbspace stores a particular type of Sybase IQ data.
Dbspace type |
Data stored |
Files contained by dbspace |
Number of dbspaces |
|---|---|---|---|
The SYSTEM dbspace |
System tables, views, stored procedures, SQL Anywhere tables, and function definitions |
One |
One or more |
Other catalog dbspaces |
SQL Anywhere tables |
One |
One or more |
IQ_SYSTEM_MAIN |
IQ database structures including IQ rollforward/rollback data for each committed transaction and each active checkpointed transaction, the incremental backup metadata, and database space and identity metadata. IQ user objects may be stored here but Sybase recommends that you put them in other main dbspaces. |
One or more |
One |
Other main dbspaces (also called user dbspaces) |
IQ objects such as tables, indexes, join indexes, and table metadata. |
One or more |
One or more |
IQ_SYSTEM_TEMP |
Set of 1 to n temporary dbfiles that define a single temporary dbspace for a standalone database or multiplex node |
One or more |
One |
IQ_SHARED_TEMP |
Set of 1 to n temporary dbfiles that define a single temporary dbspace shared by all multiplex nodes. |
One or more (initially has no files) |
One |
IQ_SYSTEM_MSG |
External file that logs messages about database activity |
One per multiplex node |
One |
The dbspace of a table or join index is implicitly or explicitly specified. For base tables and join indexes, the value of the DEFAULT_DBSPACE option implicitly determines the dbspace location, or you can explicitly specify the location using the CREATE TABLE IN dbspace_name clause or CREATE JOIN INDEX IN dbspace_name clause. Base tables are typically created in a dbspace in the IQ main store, but may also be created without IQ indexes in a dbspace in the catalog store.
For global temporary tables, specify the IN SYSTEM clause to explicitly create an SA global temporary table. By default, IQ temporary tables are created in IQ_SYSTEM_TEMP.