IBM Books

Status of DB2 Instance


Snapshot Information Level
Database Manager

API Structure(s)
sqlm_db2

Monitor Group
Basic

Resettable

No

 

API Element Name
Element Type

db2_status
information

 

Description:  The current status of the instance of the database manager.

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

Values for this field are:
API Constant Description
SQLM_DB2_ACTIVE SQLM_DB2_ACTIVE is the only valid value for this field.
SQLM_DB2_QUIESCE_PEND The instance of the database manager is in quiesce-pending state. New connections to the instance and its databases 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_DB2_QUIESCED The instance of the database manager has been quiesced. New connections to the instance and its databases 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 ]