create dbspace argument: Create a dbspace (SQL administration API)
Use the create dbspace argument with the admin() or task() function to create a dbspace.
Syntax
Extents and mirror chunk
| Element | Description | Key Considerations |
|---|---|---|
| dbspace | The name of the dbspace to be created. | |
| first_extsize | The size, in KB, of the first extent for the tblspace tblspace. | See admin() and task() Argument Size Specifications. |
| initial_chunk_size | The size, in KB, of the initial chunk of the new dbspace. The size is rounded to a multiple of the page size. | See admin() and task() Argument Size Specifications. |
| mirror_offset | The offset, in KB, of the mirror chunk. | |
| mirror_path | The path name to the chunk that mirrors the initial chunk of the dbspace. | |
| next_extsize | The size, in KB, of the next extents in the tblspace tblspace. | See admin() and task() Argument Size Specifications. |
| offset | The offset, in KB, into the disk partition or into the device to reach the initial chunk of the new dbspace. | |
| page_size | The non-default page size, in KB, for the new dbspace. | See admin() and task() Argument Size Specifications. |
| path_name | The disk partition or device of the initial chunk of the dbspace that you are creating. | Valid page sizes depend on the default page
size for the computer:
|
Usage
Use the create with_check dbspace argument to check the specified path name and return an error if it does not exist.
Use the create unencrypted dbspace argument to create an unencrypted dbspace when encryption is enabled by the DISK_ENCRYPTION configuration parameter.
This function is equivalent to the onspaces -c -d command.
Example
The following example creates a dbspace that has a size of 20 MB with an offset of 0.
EXECUTE FUNCTION task ("create dbspace", "dbspace3",
"$INFORMIXDIR/WORK/dbspace3", "20 M", "0");