Try OpenEdge Now
skip to main content
Database Management
Examining Data from an OpenEdge Database : Understanding OpenEdge database views : Storage Areas view
 

Storage Areas view

The Storage Areas view allows you to view the status of your database storage areas.
From the Database details page, click Storage Areas in the Operational Views section. The Storage Areas view appears and you can find more information in the following sections:
*System areas
*Application data areas
*Before imaging areas
*After imaging areas.
Additionally, you can find graphs displaying the percentage of use for each area, the size of each area, and an area's percentage of reads and writes relative to the monitored database's reads and writes. For more information about graphs, see Graphical Displays of Database Data
While interpreting the data presented on the Storage Areas view page, remember the following points:
*Reads and writes are in database blocks.
*The percentage listed in the Reads column and the Writes column is the percentage of the database's total reads or writes.
The absence of an entry in the Reads column or the Writes column indicates that no reads or writes have taken place.
*An entry of less than one percent in the Reads column or the Writes column indicates that reads or writes took place, but not enough to reach one percent.
*The High Water Mark (HWM) column indicates the greatest number of blocks used in a storage area. The following equation produces the percentage displayed in the HWM column: x/y, where x is the number of the HWM block and y is the total number of blocks existing in the storage area. For example, if your database's HWM block is 5 and its total number of existing blocks in the storage area is 8, the data displayed in the HWM column would be 63% (or 5/8=.625 rounded).
*The Used column indicates the amount of space used on a storage area's free chain. The following equation produces the percentage displayed in the Used column: (x-z)/y, where x is the number of the HWM block, z is the total number of free blocks in the area's extents, and y is the total number of blocks existing in the storage area.
*Double question marks in a data column indicate that the database agent could not access the needed information. See After Imaging areas for more information about double question marks.
*Double exclamation points in a data column indicate that the table was unavailable at the time the Storage Areas page was built. For example, if the database agent is down and therefore unable to poll the database at the time of the view's creation, double exclamation points appear in the data columns.
* System areas
* Application data areas
* Before Imaging areas
* After Imaging areas