Returns the operational status of the system.
The following table lists the valid system states.
|Database is not running||System has not been started; it cannot be accessed from a client or used for processing.|
|Database Startup||System is undergoing startup processing and is not yet ready to accept requests.|
|Logons are disabled - Users are logged on||No new sessions can log on, but existing sessions are still logged on.|
|Logons are disabled - The system is quiescent||Logons are disabled and no sessions are logged 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||Logons are enabled, but no sessions are logged on.|
|Only user DBC Logons are enabled||Only new DBC sessions can log on and work is in process.|
|RECONFIG is running||The system is being reconfigured.|
|System is operational without PEs - Sessions are not allowed||Either there are no PEs configured into the system or all PEs are offline/down.|
|TABLEINIT is running||System startup has detected that there are no tables on the system and is running TABLEINIT to create the system tables.
This usually occurs during the next 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