#Progress kinvey free software#
The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Refer to Article VST's to monitor space in a Type II Storage Area? With the introduction of Type II Storage Areas in OpenEdge 10, while the terminology remains, the behavior or use and re-use changes. The above discussion applies to Type I Storage Areas. Once a database block is formatted as an index block, when all the entries in a block are deleted, that block will be converted back to a Free block (technically first added to the Index Delete Chain then a Free Block). The Free Block is then available as a record block or an index block again as space is needed.Once a database block is formatted as a record block, it will remain a record block for the life of the database and its deleted entries will be reused as new records for any table's records that are added.
A FREE block can then become either an INDEX block or a RM (data) block. It won't be on the free chain for long the reason the high water mark moved was because the free chain was exhausted. Once the high water mark (HWM) goes above the block, it gets converted to a FREE block and is put on the FREE chain. RM - A block which contains record or blob/clob data information.Įvery database Storage Area has a High Water Mark (HWM).Ī database block starts out as an EMPTY block above the High Water Mark.INDEX - A block containing index key information.FREE - Same as empty, but below the high water mark and formatted with header information.EMPTY - A block above the high water mark.
It will be converted to either a Data (RM), Index or LOB block when needed. A Free block is an Empty block that has been formatted and moved below the HWM but remains empty.