Release 10.1A: OpenEdge Data Management:
Database Administration

> ## PROUTIL SETBLOBCREATELIMIT qualifier

> Set the create limit for the specified BLOB.

> #### Syntax

>     proutil db-name -C setblobcreatelimit blob-id create-limit

> #### Parameters

> ``db-name``

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

> ``blob-id``

> Specifies the BLOB object for which you are setting the create limit.

> ``create-limit``

> Specifies the new create limit.

> #### Notes

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

> - The create limit value must be greater than 32 and less than the block size minus 128 bytes.

> - For databases with a 1K block size, the default create limit is 75. For all other database block sizes, the default create limit is 150.

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

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

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