Kbase P110710: How to understand the Create limit and Toss Limit of a Storage Area
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/02/2009 |
|
Status: Verified
GOAL:
How to find the Create limit and Toss Limit of a Storage Area
GOAL:
How to interpret the output from proutil -C dispTossCreateLimits
FACT(s) (Environment):
OpenEdge 10.x
All Supported Operating Systems
FIX:
$ proutil dbname -C dispTossCreateLimits <area_number>
OpenEdge Release 10.0B03 as of Thu Sep 8 09:15:50 EDT 2005
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:
o "Object number" is the _File._File-Num in the database meta schema, ie the database object (table/index/lob) number
o "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)
o "Toss Limit" is the minimum amount of free space needed in a block for it to remain on the RM Chain
o "Create Limit" is the minimum amount of free space required in a block to allow creation of a new record starting in that block
For further discussion on Toss and Create Limits, please refer to Progress Solution P97487, "How to optimize the database block toss and create limits ?"