Background documentationdb_state Locate this document in the navigation structure

 

You display the operational state of the database instance.

Prerequisites

You have the DBInfoRead server authorization.

Structure

db_state [-v]

-v

The fill level of the database instance log and data area is displayed.

Result

OK

<operational_state>

Log Full = <value>

Database Full = <value>

Values for the Reply Fields

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.

Database Operational States

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.