CREATE DBSPACE

>>-CREATE--+------+--DBSPACE--dbspace_name---------------------->
           '-TEMP-'

>--+--------------------+--+----------------------+------------->
   '-THRESHOLD--percent-'  '-FRAGMENTS--fragments-'

>--| Chunk Definition |--+-----------------------+-------------->
                         '-| Mirror Definition |-'

>--+-------------------------------+---------------------------><
   '-COSERVER--+-coserver_number-+-'
               '-coserver_name---'

Chunk Definition:

|--CHUNK--"--pathname--"--+----------------+--SIZE--size-------->
                          '-OFFSET--offset-'

>--+--------+---------------------------------------------------|
   +-KBYTES-+
   +-MBYTES-+
   '-GBYTES-'

Mirror Definition:

|--MIRROR--"--pathname--"--+----------------+-------------------|
                           '-OFFSET--offset-'

Element	Purpose	Restrictions	Syntax
dbspace_name	The dbspace to create	For the restrictions, see creating a dbspace in the chapter on managing disk space in the IBM Informix: Administrator's Guide.	See Dbspace Name.
fragments	The approximate number of fragments the new dbspace will contain	Value is between 3 and 65500	Decimal or hexidecimal integer.
percent	The percentage of the total space in the dbspace which, when used, triggers an alarm.	Value is between 1 and 100	Decimal or hexidecimal integer.
coserver_ name	Name of the coserver on which the dbspace is to reside	The coserver name must have the following format: dbservername.coserver_number The value for dbservername must be the same value that the DBSERVERNAME configuration parameter specifies. The value for coserver_number must be one of the integers that the COSERVER configuration parameter specifies.	See Coserver Name.
coserver_ number	The number of the coserver on which the dbspace is to reside	The coserver number must be one of the integers that the COSERVER configuration parameter specifies.	Unsigned integer.
pathname	The file or raw device of the first chunk of the new dbspace	The chunk must be an existing file or raw device. Use a full pathname.	Pathname must conform to the rules specific to your operating system.
offset	The offset, in kilobytes, into the file or raw device to reach the chunk	Value must be greater than 0. See allocating raw disk space on UNIX in the chapter on managing disk space in the IBM Informix: Administrator's Guide.	Unsigned integer.
size	The size of the initial chunk of the new dbspace	Value must be greater than 0. Size must not exceed 4 gigabytes.	Unsigned integer; default size unit is kilobytes.

Use the onutil CREATE DBSPACE command to create a new dbspace or temporary dbspace on a coserver. The database server must be in online or quiescent mode when you create a dbspace or temporary dbspace.

When you create separate dbspaces without using a dbslice, a specific coserver owns and manages each dbspace. The physical disk on which the dbspace resides belongs to the node on which the coserver executes. This coserver is referred to as the home coserver.

Keyword: Description
DBSPACE: Specifies the name of the new dbspace.
CHUNK: Specifies the file or raw device of the chunk that you want to add. Use the SIZE option in the chunk definition, followed by a size in either kilobytes, megabytes, or gigabytes, to specify a size for the new dbspace.
MIRROR: Specifies the file or raw device of the chunk that performs the mirroring. Use the MIRROR keyword when you want to mirror the new chunk.

CREATE DBSPACE

Syntax

Usage