Release 10.1A: OpenEdge Data Management:
Database Administration

> ## PROUTIL SETAREATOSSLIMIT qualifier

> Set the toss limit for the specified area.

> #### Syntax

>     proutil db-name -C setareatosslimit area-number toss-limit

> #### Parameters

> ``db-name``

> Specifies the database where you are setting the toss limit.

> ``area-number``

> Specifies the area where you are setting the toss limit.

> ``toss-limit``

> Specifies the new toss limit. The toss limit is the minimum amount of free space that must exist in a block for the block to remain on the free chain as a candidate for holding additional records.

> #### Notes

> - SETAREATOSSLIMIT will set the limit for all tables and BLOBs in the specified area.

> - The toss limit value must be greater than 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.

> - The database must be offline when setting toss limits.

> - For more information on setting toss limits, see the "Database fragmentation" section.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095