Kbase P11835: How to monitor before-image growth with Virtual System Tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/05/2011 |
|
Status: Verified
GOAL:
How to monitor before-image growth with Virtual System Tables
FACT(s) (Environment):
Progress 8.x
Progress 9.x
All Supported Operating Systems
OpenEdge 10.x
FIX:
As with all VST monitoring, routines may be customized according to specific needs. Below is a sample of how this can be achieved:
/* Before-image Logging Information*/
FOR EACH _Logging NO-LOCK:
DISPLAY
_Logging-BiClAge COLON 32 LABEL "Before-image cluster age time"
_Logging-LastCkp COLON 32 LABEL "Time of last checkpoint"
FORMAT "X(30)"
_Logging-BiBlkSize COLON 32 LABEL "Before-image block size"
_Logging-BiClSize COLON 32 LABEL "Before-image cluster size"
_Logging-BiExtents COLON 32 LABEL "Number of before-image extents"
_Logging-BiLogSize COLON 32 LABEL "Before-image log size (kb)"
_Logging-BiBytesFree COLON 32 LABEL "Bytes remaining in current cluster"
_Logging-BiBytesFree COLON 32 LABEL "Bytes free in current cluster"
_Logging-LastCkp COLON 32 LABEL "Last checkpoint was at"
_Logging-BiBuffs COLON 32 LABEL "Number of BI buffers"
_Logging-BiFullBuffs COLON 32 LABEL "Number of Full BI buffers"
WITH FRAME biLoggingFrame TITLE "BI logging status"
SIDE-LABELS THREE-D CENTERED.
END.
/* _ActBILog VST Table displays before-image log activity in more detail*/