[Progress Communities] [Progress OpenEdge ABL] VST to report the fields stored in the object blocks

  • Thread starter Thread starter George Potemkin
  • Start date Start date
Status
Not open for further replies.
G

George Potemkin

Guest
The object blocks store the useful information about the objects resided in the type II storage areas: totalBlocks, hiWaterBlock, numBlocksOnChain[3] etc. This information, for example, can be used to a quick estimation of table’s and index’ sizes before creating the complicated query. _AreaStatus VST reports this information only for "Area Control Object" object blocks. _ObjectStatus could do the same for all objects in SAT2. Also it would be useful to get the value of bk_updctr field for these blocks (and in _AreaStatus as well). It will give an estimation of how often the chains of an objects are updated (= increase of bk_updctr minus increase of totalBlocks devided by DCS).

Continue reading...
 
Status
Not open for further replies.
Back
Top