Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Master block (_MstrBlk)
 
Master block (_MstrBlk)
The _MstrBlk VST displays before-image and after-image information about the master block and other master block status.1
Field name
Data type
Description
_MstrBlk-AiBlksize
INTEGER
Number of bytes in an AI block
_MstrBlk-BiBlksize
INTEGER
Number of bytes in a BI block
_MstrBlk-BiOpen
CHARACTER
Date and time the BI file was last opened
_MstrBlk-BiPrev
CHARACTER
Previous value of _MstrBlk-biopen
_MstrBlk-BiState
INTEGER
Current state of BI file
_MstrBlk-Cfilnum
INTEGER
Highest file number currently defined in the database
_MstrBlk-Crdate
CHARACTER
Date and time of database creation
_MstrBlk-Dbstate
INTEGER
Current state of the database
_MstrBlk-Dbvers
INTEGER
Database version number
_MstrBlk-Fbdate
CHARACTER
Date and time of the last full backup
_MstrBlk-Hiwater
INTEGER
Database blocks high-water mark
_MstrBlk-Ibdate
CHARACTER
Date and time of most recent incremental backup
_MstrBlk-Ibseq
INTEGER
Sequence of last incremental backup
_MstrBlk-Integrity
INTEGER
Database integrity enabled flag
_MstrBlk-Lasttask
INTEGER
Last transaction ID
_MstrBlk-Oppdate
CHARACTER
Date and time of previous database open
_MstrBlk-Oprdate
CHARACTER
Date and time of most recent database open
_MstrBlk-Rlclsize
INTEGER
Current BI cluster size
_MstrBlk-Rltime
CHARACTER
Time since last before-image file truncate
_MstrBlk-Tainted
INTEGER
Database damaged flags
_MstrBlk-Timestamp
CHARACTER
Schema cache file time stamp
_MstrBlk-Totblks
INT64
Number of blocks allocated to the database

1 Activity and status of ABL temp-tables is available in this virtual system table. The statistics gathered allow you to monitor the operation and performance of deployed client temp-tables. Specify the range of temp-tables to track with the -ttbasetable and -tttablerangesize startup parameters. Specify temp table indexes with -ttbaseindex and -ttindexrangesize startup parameters. For more information monitoring and debugging temp tables with VSTs, see OpenEdge Development: Debugging and Troubleshooting.