Sybase IQ distributes user data across multiple disks at the application level by representing each device as a dbspace. A dbspace can be an operating system file (dbfile) or a raw disk partition. Dbspaces can contain both user data and internal database structures used for startup, recovery, backup, and transaction management.
A store is one or more dbspaces that store persistent or temporary data for a special purpose. Sybase IQ has three stores:
The catalog store contains the SYSTEM dbspace and up to twelve additional 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.
For more about dbspaces, see Working with Database Objects in System Administration Guide: Volume 1.
Sybase recommends that, immediately after creating a database, administrators create a second main dbspace (a user main dbspace) and set it to be the default dbspace. To prevent users from placing tables and indexes in IQ_SYSTEM_MAIN, revoke CREATE privilege in IQ_SYSTEM_MAIN from PUBLIC and grant it to the new user main dbspace. Although it is best to create all required dbspaces at database creation, Sybase IQ allows database administrators to add new dbspaces at any time to increase space available to the database.
