All 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 may be administered as a logical subset of total storage. You may allocate individual objects and subobjects to individual tablespaces.
A dbspace is a tablespace that consists of one or more operating system files. There are three types of dbspaces, each designed to store a particular type of Sybase IQ data:
IQ main store
IQ temporary store
IQ catalog store
