16.10 - QUERY STATE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

Returns the operational status of Teradata Database.

Syntax



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 Reconfiguration is being run.
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 SYSINIT.

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