Try OpenEdge Now
skip to main content
Database Administration
Reference : PROUTIL Utility : PROUTIL SETLOBTOSSLIMIT qualifier
 

PROUTIL SETLOBTOSSLIMIT qualifier

Set the toss limit for the specified LOB.

Syntax

proutil db-name -C setlobtosslimit lob-name toss-limit  
    [ tenant tenant-name| group group-name|
partition partition-name | composite initial]

Parameters

db-name
Specifies the database where you are setting the toss limit.
lob-name
Specifies the LOB object for which you are setting the toss limit.
toss-limit
Specifies the new toss limit.
tenant tenant-name
Specifies that the toss limit is to be set on the LOB object associated with tenant-name. If tenant-name is not valid, is part of a group, or is not associated with the specified LOB object, SETLOBTOSSLIMIT exits with an error. Specifying tenant is only allowed on databases enabled for multi-tenancy.
group group-name
Specifies that the toss limit is to be set on LOB object associated with group-name. If group-name is not valid or is not associated with partition in the area, SETLOBTOSSLIMIT exits with an error. Specifying group is only allowed on databases enabled for multi-tenancy.
partition partition-name
Specifies that the toss limit is to be set on LOB object associated with the table partition partition-name. If partition-name is not valid or is not associated with the specified LOB object, SETLOBTOSSLIMIT exits with an error. Specifying partition is only allowed on databases enabled for table partitioning.
composite initial
Specifies that the toss limit is to be set on LOB object associated with the composite initial partition of lob-name. If lob-name is not associated with a partitioned table, SETLOBTOSSLIMIT exits with an error. Specifying composite initial is only allowed on databases enabled for table partitioning.

Notes

*For a Type II area, SETLOBTOSSLIMIT sets the LOB toss limit for the specified LOB. For a Type I area, SETLOBTOSSLIMIT issues a warning that all tables and LOBs in an area must have the same toss limit, and prompts you to confirm setting the toss limit for all tables and LOBs in the area containing the specified LOB.
*The toss limit value must be greater than zero (0) and less than the block size minus 128 bytes.
*For databases with a 1K block size, the default toss limit is 150. For all other database block sizes, the default toss limit is 300.
*For more information on setting toss limits, see Database fragmentation.