create sbspace with accesstime argument: Create an sbspace that tracks access time (SQL administration API)

Use the create sbspace with accesstime argument with the admin() or task() function to create an sbspace that tracks the time of access for all smart large objects stored in the sbspace.

Syntax

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

>--"create--+-------------+--+------------+--sbspace with accesstime"--,--"sbspace"--,--"path_name"-->
            '-unencrypted-'  '-with_check-'                                                           

>--+------------------------------------------+--)--;----------><
   '-,--"initial_chunk_size"--+-------------+-'         
                              '-,--"offset"-'           

Element Description Key Considerations
initial_chunk_size The size, in kilobytes, of the initial chunk of the new 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 sbspace.  
path_name The disk partition or unbuffered device of the initial chunk of the sbspace.  
sbspace The name of the sbspace to be created.  

Usage

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

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

This function is equivalent to the onspaces -c -S command for creating an sbspace and using the set sbspace accesstime argument with the admin() or task() function to start tracking the time of access for all smart large objects stored in the sbspace.

Example

The following example creates a new sbspace that tracks access time. This sbspace has a size of 20 MB with an offset of 0:

EXECUTE FUNCTION task ("create sbspace with accesstime","sbspace4", 
"$INFORMIXDIR/WORK/sbspace4","20 M","0");

Copyright© 2019 HCL Technologies Limited