QUERY STATE Command - Teradata Vantage - Analytics Database

Database Introduction

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-09-27
dita:mapPath
gtm1628096154303.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dsm1472253642401
lifecycle
latest
Product Category
Teradata Vantageā„¢

Vantage is always in one of the following states, which you can monitor using the QUERY STATE command from the DBW Supervisor window.

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.