MDA_DATABASE

Databases

ROWID

(DB_NAME)

Columns

Name	Data Type	Description
INSTANCEID	long	Instance ID; 0 = non-CE
DB_NAME	string(32)	Database name
RECOVERID	long	Recovery order #; set by sp_dbrecovery_order()
ISTEMPDB	string(4)	D = Default tempdb (DBID = 2), U = User-defined tempdb, (blank) = Non-tempdb
DB_TRAN_DUMPED	time	Internal last transaction log dump time; includes frequent system-initiated transaction log dumps
HOURS_SINCE_DUMP	long	Number of hours since internal last transaction log dump time (DB_TRAN_DUMPED)
BACKUPSTARTTIME	time	Time that the last full database backup started
HOURS_SINCE_BACKUP	long	Number of hours since the last full database backup started (BACKUPSTARTTIME)
LASTCHECKPOINTTIME	time	Time of the last checkpoint on the database
HOURS_SINCE_CHECKPOINT	long	Number of hours since the last checkpoint on the database (LASTCHECKPOINTTIME)
BACKUPINPROGRESS	long	Whether a backup is currently in progress for the database
LASTBACKUPFAILED	long	Whether the last backup failed for the database
TRANSACTIONLOGFULL	long	Whether the transaction log is full for the database
SUSPENDEDPROCESSES	long	Number of processes currently suspended because the transaction log is full for the database
APPENDLOGREQUEST	double	Number of append log requests
APPENDLOGWAITS	double	Number of waits during append log requests
LASTTRANLOGDUMPTIME	time	Time of last transaction log dump initiated by user
QUIESCETAG	string(32)	Tag used in the quiesce database command, if the database is quiesced
SHRINKSTATUS	string(8)	Yes = Database shrink in progress; No = No shrink in progress; unknown = Unknown shrink status
ENCRYPTIONSTATUS	string(20)	Encryption status: normal encrypted being encrypted partially encrypted being decrypted partially decrypted unknown
TRANDUMPABLESTATUS	long	0 = Normal transaction log dump is allowed; >0 = Not dumpable due to some issue (see ASE docs for further interpretation); -1 = Unavailable dumpable status
DB_OWNER	string(32)	Database owner name
DB_CREATED	time	Time of database creation
DB_OPTIONS	string(124)	Database options; no options set = No database options set; otherwise, one or more options, including (but not limited to): abort tran on log full allow nulls by default archive async log service auto identity compressed data compressed log dbo use only ddl in tran delayed commit don't recover erase residual data failed upgrade has suspect pages/objects identity in nonunique index mixed log and data no chkpt on recovery no free space acctg not recovered offline online for standby access quiesce database read only scratch select into/bulkcopy/pllsort single user trunc log on chkpt unique auto_identity index user created temp db
DBTOTSIZE	double	Total allocated size of the database (data + log), in bytes
DBTOTUSED	double	Amount of space used in the database (data + log), in bytes
DBTOTPCNTFULL	double	% of total allocated size that is used (data + log)
DBDATASIZE	double	Total allocated size, for data, of the database, in bytes
DBDATAUSED	double	Amount of space used, for data, in the database, in bytes
DBDATAPCNTFULL	double	% of total allocated size, for data, that is used
DBLOGSIZE	double	Total allocated size, for log, of the database, in bytes
DBLOGUSED	double	Amount of space used, for log, in the database, in bytes
DBLOGPCNTFULL	double	% of total allocated size, for log, that is used
DBLOGONLY	string(8)	N = Mixed data/log, Y = Not mixed data/log (log only)
DBID	long	Database ID
MERGESTATUS	long	Internal-use merge status; created by Surveillance

Requirements

Attributes:	MDA
Minimum database version:	15.0.3