Space Allocation

All Sybase IQ databases are pre-allocated, 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.

• Types of Dbspaces
  Each type of dbspace stores a particular type of Sybase IQ data.
• Space for Databases
  The first dbspace for each store is created automatically when you create the database. You can create additional dbspaces as needed.
• Space Requirements for IQ Stores and Temporary Stores
  The amount of data, and the number and types of indexes you create, determine how much space you need in your IQ database.
• Sizing Guidelines for Main and Temporary Stores
  The Sybase IQ architecture influences guidelines for data storage.
• Estimating Space and Dbspaces Required
  To avoid difficulties when a database or a particular dbspace is full, estimate dbspace requirements before you create the database and the objects in it.
• Dbfiles and Output Files
  The SYSDBFILE view shows all the dbfiles in your database, including the catalog dbspace file, the IQ message file, dbfiles in the IQ main and temporary dbspaces, the transaction log file, and the SA temporary file.