A dbspace is composed of one or more files. The total
number of dbfiles is 16383. A Sybase IQ agent must be running on the machine where
you create the dbspace.
- Right-click Dbspaces, point to New,
and choose Dbspace.
- Describe the dbspace you want to create, including the
name, storage location, and striping options.
See Reference: Statements and Options > ALTER DBSPACE statement for
more information about striping options.
- Click Next.
- Click Add.
- On the File details dialog, specify the properties of
the new file:
Option
|
Description
|
Specify the logical name for the file
|
Logical name for the file.
The logical name for the file is the actual file name of the
dbspace, with a path where necessary. Any
relative directory is relative to that initial dbspace. Be sure
to specify the file name suffix – .iq for a
Sybase IQ main store,.iqtmp for a Sybase IQ temporary store.
|
Specify the path to the physical file
on disk
|
Path to the file location.
A file name without an explicit path reference is created
in the same directory as the initial dbspace of that store.
|
This is a raw device
|
If the dbspace is a dbfile, deselect
the option This is a raw device, then specify the file size in MB, KB, GB or TB.
|
Reserve size... Megabytes
|
Amount of space to reserve in megabytes,
so that the dbspace can be increased in size in the future. The
size can be any number greater than 0. The reserve cannot be changed
after the dbspace is created.
When you specify reserve size, the database uses more space
for internal (free list) structures.
|
- Click OK.
- Click one of the following:
- Add
to add another file to the dbspace.
- Click Finish to close the Wizard.
Next
Sybase recommends that, immediately after creating a database,
administrators create a second main dbspace (a user main dbspace)
and set it to be the default dbspace. To prevent users from placing
tables and indexes in IQ_SYSTEM_MAIN, revoke CREATE
privilege in IQ_SYSTEM_MAIN from PUBLIC and grant
it to the new user main dbspace. Although it is best to create all
required dbspaces at database creation, Sybase IQ allows database administrators
to add new dbspaces at any time to increase space available to the
database.
Once a dbspace is created, you can add or remove files. You can add multiple files to any dbspace, but you can only add multiple dbspaces to the main store.