set sbspace accesstime argument: Control access time tracking (SQL administration API)

Use the set sbspace accesstime argument with the admin() or task() function to start or stop tracking the time of access for all smart large objects stored in the sbspace.

Syntax

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

>--+-"set sbspace accesstime off"-+--,--"sbspace"--)--;--------><
   '-"set sbspace accesstime on"--'                       

Element Description Key Considerations
sbspace The name of the sbspace.  

Usage

Use the set sbspace accesstime off argument to turn off tracking of access times.

Use the set sbspace accesstime on argument to turn on tracking of access times for all smart large objects stored in the sbspace.

This function is equivalent to the onspaces -ch command.

Example

The following example turns off tracking of access times for the sbspace named sbsp1:
EXECUTE FUNCTION task("set sbspace accesstime off","sbsp1");

Copyright© 2019 HCL Technologies Limited