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

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(------------------------------->
                     '-task--'      

>--"create--+-+-------------+-+--dbspace"--,--"dbspace"--,--"path_name"-->
            | '-unencrypted-' |                                           
            '-+------------+--'                                           
              '-with_check-'                                              

>--+------------------------------------------------------------------------------------------------+-->
   '-,--"initial_chunk_size"--+-------------------------------------------------------------------+-'   
                              '-,--"offset"--+--------------------------------------------------+-'     
                                             '-,--"page_size"--+------------------------------+-'       
                                                               '-| Extents and mirror chunk |-'         

>--)--;--------------------------------------------------------><

Extents and mirror chunk

|--+-----------------------------------------------------------------------------------------+--|
   '-,--"first_extsize"--+-----------------------------------------------------------------+-'   
                         '-,--"next_extsize"--+------------------------------------------+-'     
                                              '-,--"mirror_path"--+--------------------+-'       
                                                                  '-,--"mirror_offset"-'         

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:
  • 2 KB default page size: 2, 4, 6, 8, 10, 12, or 16 KB
  • 4 KB default page size: 4, 8, 12, or 16 KB

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");

Copyright© 2019 HCL Technologies Limited