You display the operational state of the database instance.
You have the DBInfoRead server authorization.
db_state [-v]
-v | The fill level of the database instance log and data area is displayed. |
OK
<operational_state>
Log Full = <value>
Database Full = <value>
Value | Description |
---|---|
<operational_state> | Operational state of the database instance. Possible values are, among others: ONLINE: The database instance is ready for operation. ADMIN: The database instance has been shut down. Only special administrative work can be done. OFFLINE: The database instance is not ready for operation. STOPPED INCORRECTLY: Only with a UNIX operating system. The database stopped after an error. UNKNOWN: The system cannot determine the operational state. |
Log Full = <value> | Fill level of the log area. Possible values are: YES: The log area is full. NO: The log area is not full. |
Database Full = <value> | Fill level of the data area. Possible values are: YES: The data area is full. NO: The data area is not full. |
Operational State |
Icon |
Description |
---|---|---|
ONLINE |
|
The database is running. Database users can log on and execute SQL statements. The database system administrator and DBM operators can perform administrative tasks. |
STANDBY |
- |
For standby databases in hot standby systems only. Note that you cannot connect to a standby database. It is in a constant restart state. |
ADMIN |
|
The database is only available for administration tasks. |
OFFLINE |
|
The database is not running. |