You must have the MANAGE ANY DBSPACE system privilege.
The SAP Sybase IQ resource is authenticated and
running.
In a multiplex
configuration, the coordinator node is running.
Task
In the Perspective Resources view, select the resource, and
select Resource > Administration Console.
In the left pane, expand IQ Servers > Space Management, and then select Dbspaces.
Click the arrow next to Dbspaces and select
New.
On the General Details page, specify:
Option
Description
Resource
From the list, select the resource for which the dbspace will be
created.
Name of dbspace to create
A unique name for the new dbspace.
Store
The store in which to create the new dbspace:
Main (for IQ user data)
Catalog (for IQ metadata)
RLV (Row-Level Versioning store for in-memory data)
Cache
(cache dbspace for direct-attached storage)
Note:
Only one dbspace can be created in the RLV store. RLV is
available in a 16.0 or later simplex environment only.
You
can create a maximum of one cache dbspace for a simplex
server. In a multiplex environment, you can create a maximum
of one cache dbspace per node. Cache dbspace is available in
16.0 SP2 or later.
Striping
(Main only) Enables or disables disk striping for this dbspace.
Stripe size (Kb)
(Main only) The number of kilobytes (KB) to write to each file before the
disk-striping algorithm moves to the next stripe for this dbspace.
Default value is 1.
Multiplex Node
(Cache only) In a multiplex, select the target
multiplex node to which you are attaching the cache dbspace. The
cache dbspace will be specific to this selected node.
Note: If you are creating a cache dbspace on a
simplex server, you do not specify a node. The cache dbspace is
created on the selected server resource.
Click Next.
On the DB Files page, click Add to add files to the
dbspace.
For a cache dbspace, you can add multiple DB Files to a
multiplex node, but only one file at a time. For a cache dbspace on a simplex,
you can add multiple DB files at once.
In the DB File Details view, specify:
Option
Description
Logical name
User-defined name of the DB file.
Path to physical file on disk
Path to the physical file on disk. It is usually best to use an absolute path. A relative path works for simplex servers and for multiplexes that use the SCC shared-disk facility and have the SCC installation directory mounted in the same location on each multiplex server host. If you specify a relative path for a simplex that is later converted to a multiplex, the relative path might cause an error.
Raw device
A check mark indicates the file is on a raw device. Cache dbspaces
normally use raw device files.
File Size
Space you allocate to the DB file in kilobytes (KB), megabytes (MB),
gigabytes (GB), or terabytes (TB). Unavailable on raw devices; required
if the file is not on a raw device. Minimum file size is 8 MB.
Reserve size
(Not applicable to cache dbspaces) Specify a reserve size value and
units: kilobytes (KB), megabytes (MB), gigabytes (GB), or terabytes
(TB).