Release 10.1A: OpenEdge Data Management:
Database Administration

> ## PROUTIL SETTABLETOSSLIMIT qualifier

> Set the toss limit for the specified table.

> #### Syntax

>     proutil db-name -C settabletosslimit table-name toss-limit

> #### Parameters

> ``db-name``

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

> ``table-name``

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

> ``toss-limit``

> Specifies the new toss limit.

> #### Notes

> - For a Type II area, SETTABLETOSSLIMIT sets the table toss limit for the specified table. For a Type I area, SETTABLECREATELIMIT issues a warning that all tables and BLOBs in an area must have the same toss limit, and prompts you to confirm setting the toss limit for all tables and BLOBs in the area containing the specified table.

> - 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 create limit is 150. For all other database block sizes, the default create limit is 300.

> - The database must be offline when setting create 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