create tempdbspace argument: Create a temporary dbspace (SQL administration API)

Use the create tempdbspace argument with the admin() or task() function to create a temporary dbspace.

Syntax

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

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

>--+----------------------------------------------------------------------------------------+-->
   '-,--"initial_chunk_size"--+-----------------------------------------------------------+-'   
                              '-,--"offset"--+------------------------------------------+-'     
                                             '-,--"page"--+---------------------------+-'       
                                                          '-,--"first"--+-----------+-'         
                                                                        '-,--"next"-'           

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

Element Description Key Considerations
first Size, in kilobytes, of the first extent for the tblspace tblspace. See admin() and task() Argument Size Specifications.
initial_chunk_size Size, in kilobytes, of the initial chunk of the new temporary dbspace. See admin() and task() Argument Size Specifications.
next Size, in kilobytes, of the next extents in the tblspace tblspace. See admin() and task() Argument Size Specifications.
offset Offset, in kilobytes, into the disk partition or into the device to reach the initial chunk of the new temporary dbspace. See admin() and task() Argument Size Specifications
page Non-default page size, in kilobytes, for the new temporary dbspace. Valid page sizes depend on the default page size for the computer:
  • 2 KiB default page size: 2, 4, 6, 8, 10, 12, or 16 KiB
  • 4 KiB default page size: 4, 8, 12, or 16 KiB
path_name Path to the disk partition or device of the initial chunk of the temporary dbspace that you are creating.  
tempdbspace Name of the temporary dbspace to be created. Cannot exceed 128 bytes. It must begin with a letter or underscore, and can include only letters, digits, underscore ( _ ) symbols, or the $ character.

Usage

Use the create with_check tempdbspace argument to check the specified path name and return an error if the path does not exist.

Use the create unencrypted tempdbspace argument to create an unencrypted temporary dbspace when encryption is enabled by the DISK_ENCRYPTION configuration parameter.

This function is equivalent to the onspaces -c -d -t command.

Example

The following example creates a temporary dbspace that has a size of 20 MiB with an offset of 0:

EXECUTE FUNCTION task("create tempdbspace","tempdbspace3", 
"$INFORMIXDIR/WORK/tempdbspace3","20 M","0");

For the admin() or task() syntax to create a permanent dbspace from the storage pool, see create dbspace from storagepool argument: Create a dbspace from the storage pool (SQL administration API).


Copyright© 2019 HCL Technologies Limited