set sbspace logging argument: Change the logging of an sbspace (SQL administration API)

Use the set sbspace logging argument with the admin() or task() function to specify whether the database server logs changes to the user data area of the sbspace.

Syntax

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

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

Element Description Key Considerations
sbspace The name of the sbspace.  

Usage

Use the set sbspace logging on argument to log changes to the user data area of the sbspace.

Use the set sbspace logging off argument to not log changes to the user data area of the sbspace.

This function is equivalent to the onspaces -ch command.

Example

The following example starts sbspace logging for an sbspace named sbsp1:
EXECUTE FUNCTION task("set sbspace logging on","sbsp1");

Copyright© 2019 HCL Technologies Limited