create blobspace argument: Create a blobspace (SQL administration API)

Use the create blobspace argument with the admin() or task() function to create a blobspace.

Syntax

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

>--"create--+-------------+--+------------+--blobspace"--,--"blobspace"--,--"path_name"-->
            '-unencrypted-'  '-with_check-'                                               

>--+--------------------------------------------------------------+-->
   '-,--"initial_chunk_size"--+---------------------------------+-'   
                              '-,--"offset"--+----------------+-'     
                                             '-,--"page_size"-'       

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

Element Description Key Considerations
blobspace The name of the blobspace to be created.  
initial_chunk_size The size, in kilobytes, of the initial chunk of the new blobspace. 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 blobspace. See admin() and task() Argument Size Specifications.
page_size The blobspace blobpage size.

You specify the size of a blobpage in multiples of the default Informix® page size for your operating system.

For more information, see blobpage size considerations in the HCL Informix Performance Guide.

path_name The disk partition or device of the initial chunk of the blobspace that you are creating.  

Usage

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

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

This function is equivalent to the onspaces -c -b command.

Example

The following example creates a blobspace that has a size of 20 MB with an offset of 0 and page size of 2. The blob pages are 2*base page size = 8 K on Windows (4 K base page size).

EXECUTE FUNCTION task ("create with_check blobspace","blobs3", 
"$INFORMIXDIR/WORK/blobs3","20 M","0","2");

Copyright© 2019 HCL Technologies Limited