Tablespaces, dbspaces, dbfiles, and stores are units in which Sybase IQ stores data.
A tablespace is a unit of storage within the database that you can administer as a logical subset of the total storage. Individual objects and subobjects may be allocated to individual tablespaces. Each database includes multiple tablespaces.
In Sybase IQ 15.4, 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.
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.