monOpenDatabases

Description

Provides state and statistical information pertaining to databases that are currently in the server’s metadata cache.

If the value of number of open databases is too low, Adaptive Server may flush database descriptors from the metadata cache. If this occurs, Adaptive Server loses the database statistics, but the statistics are reinitialized the next time the database descriptor is installed in the metadata cache.

Enable the enable monitoring configuration parameter for this monitoring table to collect data.

Columns

The columns for monOpenDatabases are:

Name	Datatype	Attributes	Description
DBID	int		Unique identifier for the database
InstanceID	int		(Cluster environments only) ID of an instance in a shared-disk cluster.
BackupInProgress	int		Specifies whether a backup is currently in progress for the database
LastBackupFailed	int		Specifies whether the last backup of the database failed
TransactionLogFull	int		Specifies whether the database transaction log is full
AppendLogRequests	int	Counter	Number of semaphore requests when attempting to append to the database transaction log
AppendLogWaits	int	Counter	Number of times a task had to wait for the append log semaphore to be granted
DBName	varchar(30)	Null	Name of the database
BackupStartTime	datetime	Null	Date the last full database backup started
SuspendedProcesses	int	Null	Number of processes currently suspended due to the database transaction log being full
QuiesceTag	varchar(30)	Null	Tag used in the quiesce database command for this database if the database is in a quiesced state
LastCheckpointTime	datetime	Null	Date and time checkpoint last ran for this database
LastTranLogDumpTime	datetime	Null	Date and time of this database’s most recently successful transaction log dump. The time is not updated if the transaction is dumped using the truncate_only or no_log.
PRSUpdateCount	int	Counter	Number of updates to precomputed result sets caused by insert, update, or deletes to the base table.
PRSSelectCount	int	Counter	The number of times the optimizer selected precomputed result sets in this database when generating a query plan.
PRSRewriteCount	int	Counter	The number of times the optimizer determined the precomputed result sets in this database were valid when generating the query plan.