Use the cache dbspace to
add direct-attached storage devices, such as high-performance solid-state disks (SSDs), to
your multiplex nodes or simplex server. 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.
Configure a cache dbspace local to each node. The server then caches
copies of locally used read-only pages—for the IQ main store dbspaces to which this node
has affinity—in the cache dbspace. In subsequent reads from the IQ main store dbspace
files, the server first checks the cache dbspace to see if the page exists. If it does
exist, the server reads the page from the high-speed SSD cache dbspace, rather than the
shared SAN IQ main store dbspace, thereby increasing performance.
Use SAP Control Center and
these stored procedures to report key performance indicators for your direct-attached storage:
- sp_iqcheckdb
- sp_iqdbspace
- sp_iqfile
- sp_iqstatus
The CREATE DBSPACE statement now
supports cache dbspaces. You can also create the cache dbspace, and manage the dbspace
and its storage, using SAP Control Center.
See these topics in the SAP Sybase IQ
16.0 SP2 documentation:
- Cache Dbspace for Direct-Attached Storage in
Administration: Database
- Creating the Cache Dbspace in Administration: Database
- Dropping the Cache Dbspace in Administration: Database
- Adding Storage to the Cache Dbspace
in Administration: Database
- Removing Storage from the Cache
Dbspace in Administration: Database
- Disabling and Re-enabling the Cache
Dbspace in Administration: Database
- Changing the Readonly/Readwrite Status of
a Cache Dbspace DBfile in Administration: Database
- Monitoring the Cache Dbspace in
Administration: Database
- CREATE DBSPACE Statement in
Reference: Statements and Options
- sp_iqcheckdb Procedure in
Reference: Building Blocks, Tables, and Procedures
- sp_iqdbspace Procedure in
Reference: Building Blocks, Tables, and Procedures
- sp_iqfile Procedure in
Reference: Building Blocks, Tables, and Procedures
- sp_iqstatus Procedure in
Reference: Building Blocks, Tables, and Procedures