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.
|