Openedge index rebuild full#

Openedge index rebuild full#

Index Block (Ix Block) Index Anchor Block Free Blocks Empty Blocks Notes:ĥ Master Block This stores the “master” information for the database including: Area Status (opened, closed, crashed) Last opened date & time High water mark for the area Last backup date & time This information and more can be retrieved through the virtual system tables (VSTs) Notes:Ħ Data Blocks These are also known as RM (Record Manager) blocksĬan contain information from one or more tables They can be “full” (RM Blocks) Partially full (RM Chain blocks) Notes:ħ Record Storage In most environments, records are mixed from different tables in the same block Progress can store from 1 to 256 records per block per storage area All areas for a database must have the same block size (1 – 8kb) Total records per area is fixed More records per block equals lower total blocks Notes: Prior to version 9 any block 4k or less could only have 32 records and 8k blocks could have 64 records. Index blocks Other block types Physical Layout Data storage areas Primary recovery area After image journal Other storageĤ Database Blocks Master Blocks Data Block (RM Block) of Technology White Star SoftwareĢ Agenda Progress architecture Hardware configuration discussionĭatabase maintenance Performance tuning Database future directionģ Database Internals Internal Blocks Physical Layout Data blocks 1 Progress Database Setup, Maintenance and TuningĪdam Backman V.P.