QUERY STATE Command - Advanced SQL Engine - Teradata Database

Database Introduction

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
qia1556235689628.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1091
lifecycle
previous
Product Category
Teradata Vantageā„¢

Teradata Database is always in one of several states. You can monitor these states using the QUERY STATE command from the DBW Supervisor window.

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.