17.10 - QUERY STATE - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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; 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