Creating the Cache Dbspace

Create a cache dbspace to add direct-attached storage (DAS) devices to a simplex or multiplex node. The cache dbspace increases performance by reducing reads from the storage area network. Each multiplex and simplex node can have one cache dbspace.

Prerequisites

Requires MANAGE ANY DBSPACE system privilege.

Task

Connect to a simplex or multiplex node.
Create the cache dbspace and dbfiles. Specify the IQ CACHE STORE keywords in the CREATE DBSPACE statement.
```
CREATE DBSPACE myDAS
USING FILE iqdas1
'/dev/rdsk/ssd104' IQ CACHE STORE
```