Returns the operational status of the system.
Syntax
QUERY STATE
Usage Notes
The following table lists the valid system states.
| System State | Description |
|---|---|
| Database is not running | System has not been started and cannot be accessed from a client or used for processing. |
| Database Startup | System is starting but is not yet ready to accept requests. |
| Logons are disabled - Users are logged on | Sessions are logged on but no new sessions can log on. |
| Logons are disabled - The system is quiescent | No sessions are logged on and no new sessions can log on. |
| Logons are enabled - Users are logged on | New sessions can log on and work is in process. |
| Logons are enabled - The system is quiescent | New sessions can log on but none have done so. |
| Only user DBC Logons are enabled | Only new DBC sessions can log on and work is in process. |
| RECONFIG is running | System is being reconfigured. |
| System is operational without PEs - Sessions are not allowed | No PEs are configured into system or all PEs are offline/down. |
| TABLEINIT is running | System startup detected that system has no tables and is running TABLEINIT to create system tables. This state usually occurs during system restart after a system initialization. |
Following are valid system substates of System Startup:
- Initializing Database VProcs
- Initializing Database Configuration
- Starting AMP Partitions
- Starting PE Partitions
- Voting for Transaction Recovery
- Starting Transaction Recovery
- Recovering Down AMPs
- Recovering Database Partitions
Example: Displaying the operational status of the system
This example shows the current operational status of the system.
query state TPA is in state: Logons are enabled - The system is quiescent