Queries States - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 23.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
23.04
Published
April 2023
Language
English (United States)
Last Update
2023-05-05
dita:mapPath
cxb1678987903668.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
Product Category
Analytical Ecosystem

The Queries list before the summary table allows you to select a state so that only queries in that state are displayed.

Teradata System States

All
Sessions in the system
Not Idle
Sessions in any state except idle
Active
Sessions processing queries
Block
Sessions processing a query waiting for a locked resource, such as a database table or view
Defer
Sessions waiting under deferred queue to be processed
Delay
Sessions waiting to be processed
Abort
Sessions in the process of aborting (rolling back changes made by the query)
Resp
Sessions running a query that has completed and is sending (responding) spooled data back to the user
Idle
Sessions not currently running a query
Parse
Sessions running a query that is being parsed and has not begun to execute
Other
Sessions whose status is unknown and do not fall into another category
QTDelayed
Sessions delayed due to a queue table restriction
SesDelayed
Utility sessions that are in the workload delay queue
Response-Held
In SLES 11, sessions running a query whose response is being held until a specified number of seconds elapses

Aster System States

All
Sessions in the system
Active
Sessions processing queries
Idle
Sessions not running
Canceled
Processes that were stopped
Pending
Sessions waiting to be processed