create tempsbspace argument: Create a temporary sbspace (SQL administration API)

Use the create sbspace argument with the admin() or task() function to create an sbspace.


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

            | '-unencrypted-' |                                                   


Element Description Key Considerations
initial_chunk_size The size, in kilobytes, of the initial chunk of the new temporary sbspace. See admin() and task() Argument Size Specifications.
offset The offset, in kilobytes, into the disk partition or into the device to reach the initial chunk of the new temporary sbspace.  
path_name The disk partition or unbuffered device of the initial chunk of the temporary sbspace.  
tempsbspace The name of the temporary sbspace to be created.  


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

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

This function is equivalent to the onspaces -c -S command with the -t option for creating a temporary sbspace.


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

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

Copyright© 2019 HCL Technologies Limited