Database status (_DbStatus)

The _DbStatus VST displays a wide variety of status data.

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 Code page name.
_DbStatus-Collation CHARACTER Collation table name.
_DbStatus-CreateDate CHARACTER Date and time of database creation.
_DbStatus-databaseRole CHARACTER Database role.
Valid values are:
  • Replication source
  • Replication target
  • Normal
Note: If replication is not enabled, the database role will be reported as Normal.

Format X(8)
_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-InitiateDiag LOGICAL Set to begin diagnostic data collection immediately
_DbStatus-Integrity CHARACTER DbStatus-Integrity enabled flag (-i).
_DbStatus-IntFlags INTEGER Integrity flags.
_DbStatus-LastLgTruncateTime CHARACTER Date and time of the most recent truncation of the database log file. The datetime displays in the format Thu Dec 23 16:24:20 2021.
_DbStatus-LastLgTruncateTime-TZ TIMESTAMP Date and time of the most recent truncation of the database log file. The datetime displays in datetime-tz format, for example, 12/23/2021 16:24:20.881-05:00.
_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-Wordrule-Number INTEGER Word-rule file number.
_DbStatus-Wordrule-CRC INTEGER Word-rule file CRC (cyclic redundancy check) value.
_DbStatus-ZeroStatsDate CHARACTER Date and time of the last PROUTIL ZEROSTATS operation on the database. The datetime displays in the format Thu Dec 23 16:24:20 2021.
_DbStatus-ZeroStatsDate-TZ TIMESTAMP The date and time of the last PROUTIL ZEROSTATS operation on this area. The datetime displays in datetime-tz format, for example: 12/23/2021 16:24:20.881-05:00.
_DbStatus-OEVersion CHARACTER OpenEdge version information. The version string displays in the same format as the PROVERSION(1) function. For example, 12.8.0.0.1013, where:
  • 12.8 is the release number.
  • 0 is the update number.
  • 0 is a constant value that is no longer used in the current release model.
  • 1013 is the build number.