Kbase 21805: PROMON Fails to Display Correct Database Status
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/19/2002 |
|
SUMMARY:
In Progress Version 9.x, PROMON fails to report the correct information for some entries displayed under the database status option (7). The database blocks high water mark, as well as the free blocks below the high water mark, will display an incorrect
value of 0.
EXPLANATION:
This issue has been logged as bug 20010712-020.
SOLUTION:
The current workaround is to query the Virtual System Tables (VSTs) for this information. The two tables you should examine are:
-- _AreaStatus
_AreaStatus contains an entry for each area along with the area
name, total number of blocks in the area, the highwater mark (the
highest block ever used), the number of extents, the extent containing
the highwater mark (so you can tell if the extents after that are unused), and the number of blocks on the Free and RM chain.
-- _FileList
_FileList contains an entry for each file in the database along
with the block size, file name, open mode (buffered or unbuffered), and the file size.
You can query these tables as you would any other 4GL table, and they
should give you an approximation of what you are looking for.
NOTE: For more information on the VSTs and their contents, see the chapter, "Virtual System Tables" in the Progress Database Administration Guide and Reference.
References to Written Documentation:
Database Administration Guide and Reference Manual, "Virtual System Tables"