Specify how SAP Sybase IQ allocates disk space and make sure
that data is organized on disk for optimal performance.
Space Allocation
All SAP Sybase IQ databases are preallocated, whether they reside in a file system or a raw partition.
Types of Dbspaces
Each type of dbspace stores a particular type of SAP 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.
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.
Dbspace Management Example
This section illustrates the dbspace management process from creating a new database and adding objects and data to the database, through relocating objects and dropping the empty dbspace. This example includes sample SQL code and the output of the related system stored procedures.
Data Storage
A DBA can determine which tables and indexes reside on a given dbspace, relocate objects to other dbspaces, and drop any dbspace after emptying it of data.
Cache Dbspace for Direct-Attached Storage
Add direct-attached storage devices, such as solid-state disks (SSDs), to a multiplex node or a simplex server by configuring a cache dbspace local to each node. Local direct-attached storage provides an SSD buffer pool extension to your database, which can improve I/O performance in general, and shared SAN device performance in particular. Although multiplex configurations gain the most benefit from direct-attached storage, simplex servers can benefit too.
Created December 19, 2013. Send feedback on this help topic to Technical Publications:
pubs@sap.com