In Sybase IQ 15.2, a dbspace is a tablespace that consists of one or more operating system files.
The meaning of the term varies according to the product version you are using. Sybase IQ 12.7 implemented one-to-one mapping between a dbspace and a database file. With DEFAULT_DISK_STRIPING option 'ON', Sybase IQ automatically distributed data across all available dbspaces for optimal performance and ease of administration. Users could not specify in which dbspace a table or index should be created.
The term dbfile, with a corresponding logical file name and physical file path, refers to each operating system file.
Each physical file path must be unique. The dbfile name can be the same as the dbspace name.
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 defined dbspaces.
The IQ temporary store contains the IQ_SYSTEM_TEMP dbspace.
For more information about these dbspaces, see “Types of dbspaces”.
