Kbase P26932: How can I tell which 9.1x or 10.x database extent is currently being written to?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
How can I tell which 9.1x or 10.x database extent is currently being written to?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
FIX:
In order to get an accurate reading, you will have to write a 4GL application to query the data contained within the _AreaStatus VST, specifically the _AreaStatus-Lastextent field.
4GL EXAMPLE:
For each AreaStatus.
Display _AreaStatus-Lastextent.
The data in this field indicates the last extent that was written to in that particular storage area. Keep in mind, if your database uses multiple storage areas, you will have to query each storage area for this information.