Creating the RLV Dbspace

In order to use RLV storage with tables, you first need to create the RLV dbspace with a minimum of one dbfile added to it.

Prerequisites

Task

Use the statement CREATE DBSPACE dbspace name IQ RLV STORE:

CREATE DBSPACE d1  using file f1  '/dev/raw/raw1/f1.iq' size 1000 IQ RLV STORE

Disk striping is always OFF for the RLV dbspace. Creating the RLV dbspace with STRIPING ON | OFF or using the STRIPESIZEKB option is not supported.