Purpose
Returns the operational status of Teradata Database.
Syntax
QUERY STATE
Usage Notes
The following table lists the valid system states.
| System State | Description |
|---|---|
| Database is not running | Teradata Database has not been started; it cannot be accessed from a client or used for processing. |
| Database Startup | Teradata Database 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 | Database 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 Teradata Database 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 Teradata Database
This example shows the current operational status of Teradata Database.
query state TPA is in state: Logons are enabled - The system is quiescent