Space Allocation

All SAP Sybase IQ databases are preallocated, whether they reside in a file system or a raw partition.

Each database includes multiple tablespaces. A tablespace is a unit of storage within the database that you can administer as a logical subset of total storage. You can allocate individual objects and subobjects to individual tablespaces.

A dbspace is a tablespace that consists of one or more operating system files.

A store is one or more dbspaces that store persistent or temporary data for a special purpose. SAP Sybase IQ has five stores:

The catalog store contains the SYSTEM dbspace and additional user-defined catalog dbspaces.
The IQ main store contains the IQ_SYSTEM_MAIN dbspace and other user dbspaces.
The IQ temporary store contains the IQ_SYSTEM_TEMP dbspace.
The IQ shared temporary store contains the IQ_SHARED_TEMP dbspace.
The row-level versioning (RLV) store is an in-memory store for high-performance row-level updates.