IBM Books

Status of Database


Snapshot Information Level
Database

API Structure(s)
sqlm_dbase

Monitor Group
Basic

Resettable

No

 

API Element Name
Element Type

db_status
information

 

Description:  The current status of the database.

Usage:  You can use this element to determine the state of your database.

Values for this field are:
API Constant Description
SQLM_DB_ACTIVE SQLM_DB_ACTIVE is the only valid value for this field.
SQLM_DB_QUIESCE_PEND The database is in quiesce-pending state. New connections to the database are not permitted and new units of work cannot be started. Depending on the quiesce request, active units of work will be allowed to complete or will be rolled back immediately.
SQLM_DB_QUIESCED The database has been quiesced. New connections to the database are not permitted and new units of work cannot be started.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]