The current status of the instance of the database
manager.
Table 1. Snapshot
Monitoring Information| Snapshot Level |
Logical Data Grouping |
Monitor
Switch |
|---|
| Database Manager |
db2 |
Basic |
- Usage
- You can use this element
to determine the state of your database
manager instance.
Values for this element are:
| API Constant |
Value |
Description |
|---|
| SQLM_DB2_ACTIVE |
0 |
The database
manager instance is active. |
| SQLM_DB2_QUIESCE_PEND |
1 |
The instance
and the databases in the instance
are in quiesce-pending state. New connections to any instance 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_DB2_QUIESCED |
2 |
The instance
and the databases in the instance
has been quiesced. New connections to any instance database are not
permitted and new units of work cannot be started. |
DB2 Version 9.7 for Linux, UNIX, and Windows