Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Database status (_DbStatus)
 
Database status (_DbStatus)
The _DbStatus VST displays a wide variety of status data.1
Field name
Data type
Description
_DbStatus-AiBlkSize
INTEGER
Number of bytes in an after-image block.
_DbStatus-BiBlkSize
INTEGER
Number of bytes in a before-image block.
_DbStatus-BiClSize
INTEGER
Number of kilobytes in the before-image cluster.
_DbStatus-BiOpen
CHARACTER
Most recent BI file open.
_DbStatus-BiSize
INT64
Logical size of the BI file. You can use this in conjunction with the _DbStatus-BiClSize value to determine the number of clusters in the BI file.
_DbStatus-BiTrunc
CHARACTER
Time since the last truncate.
_DbStatus-CacheStamp
CHARACTER
Schema cache file time stamp.
_DbStatus-Changed
INTEGER
Flag indicating if database has changed since last backup.
_DbStatus-ClVersMinor
INTEGER
Client minor version number.
_DbStatus-Codepage
CHARACTER
The value in this field is not maintained. This field will be removed in a future release.
_DbStatus-Collation
CHARACTER
The value in this field is not maintained. This field will be removed in a future release.
_DbStatus-CreateDate
CHARACTER
Date and time of database creation.
_DbStatus-DbBlkSize
INTEGER
Database block size.
_DbStatus-DbVers
INTEGER
Database version number.
_DbStatus-DbVersMinor
INTEGER
Database minor version number.
_DbStatus-EmptyBlks
INT64
Number of empty blocks in the database.
_DbStatus-FbDate
CHARACTER
Most recent full backup.
_DbStatus-FreeBlks
INT64
Number of free blocks in the database.
_DbStatus-HiWater
INTEGER
Database blocks high-water mark.
_DbStatus-IbDate
CHARACTER
Most recent incremental backup.
_DbStatus-IbSeq
INTEGER
Sequence of last incremental backup.
_DbStatus-Integrity
CHARACTER
DbStatus-Integrity enabled flag (-i).
_DbStatus-IntFlags
INTEGER
Integrity flags.
_DbStatus-LastOpen
CHARACTER
Most recent database open.
_DbStatus-LastTable
INTEGER
Highest table number defined.
_DbStatus-LastTran
INTEGER
Last transaction ID.
_DbStatus-MostLocks
INTEGER
Lock table high-water mark.
_DbStatus-NumAreas
INTEGER
Number of areas.
_DbStatus-NumLocks
INTEGER
Lock table entries in use.
_DbStatus-NumSems
INTEGER
Number of semaphores.
_DbStatus-PrevOpen
CHARACTER
Previous database open.
_DbStatus-RestrictMode
CHARACTER
The state of any access restrictions set by PROUTIL DBRESTRICT.
_DbStatus-RMFreeBlks
INT64
Number of rm blocks with free space.
_DbStatus-SharedMemVer
INTEGER
Shared memory version number.
_DbStatus-ShmVers
INTEGER
Shared memory version number.
_DbStatus-Starttime
CHARACTER
Time when the database was started.
_DbStatus-State
INTEGER
State of the database.
_DbStatus-Tainted
INTEGER
Damaged database flags.
_DbStatus-TotalBlks
INT64
Number of blocks allocated to the database.
_DbStatus-ZeroStatsDate
CHARACTER
Date/time of the last PROUTIL ZEROSTATS operation on 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.