set sbspace avg_lo_size argument: Set the average size of smart large objects (SQL administration API)

Use the set sbspace avg_lo_size argument with the admin() or task() function to specify an expected average size of the smart large objects in the specified sbspace so that the database server can calculate the size of the metadata area.

Syntax

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

>--"set sbspace avg_lo_size"--,--"sbspace"--,--"average_size"--->

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

Element Description Key Considerations
sbspace The name of the sbspace.  
average_size The average size, in kilobytes, of the smart large object stored in the sbspace. Windows: 4 to 2**31

UNIX: 2 to 2**31

Usage

This function is equivalent to the onspaces -ch command.

Example

The following example sets the expected average size of smart large objects in the sbspace named sbsp1 to 8 KB:
EXECUTE FUNCTION task("set sbspace avg_lo_size","sbsp1","8");

Copyright© 2019 HCL Technologies Limited