To find the Create limit and Toss Limit of a Storage Area, the
PROUTIL dispTossCreateLimits feature can be used:
$ proutil dbname -C dispTossCreateLimits <area_number>
Example output from
dispTossCreateLimits:
Object number: 2, type: 1, Toss Limit: 300, Create limit: 150.
Object number: 3, type: 1, Toss Limit: 300, Create limit: 150.
Object number: 4, type: 1, Toss Limit: 300, Create limit: 150.
Where:
- "Object number" is the _File._File-Num in the database meta schema, ie the database object (table/index/lob) number
- "type" refers to the Object Type:
Type 1: table
Type 2: index
Type 3: blob or clob
Type 8: master control object (or area object)
- "Toss Limit" is the minimum amount of free space needed in a block for it to remain on the RM Chain
- "Create Limit" is the minimum amount of free space that must be available in the block after a record is created to allow creation of a new record starting in that block
For further discussion on Toss and Create Limits, refer to Article:
