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
EXECUTE FUNCTION
{
admin
| task
}
(
{
"set sbspace accesstime off"
| "set sbspace accesstime on"
}
,"sbspace"
);
| 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");