17.10 - State Filter Bar - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-2206-101K
Language
English (United States)

The state filter bar allows you to display specific states in the view. If more than six states are available in a Teradata Database system, you can select another state from the Overflow Menu to replace the state in the last position.



The state filter buttons provide a count of sessions for each state category. Click any button to filter for the selected state or select a state from the list. For example, click Delay to display the sessions running a query that is queued and waiting to run in the selected system. Hover over a state filter button to display the expanded content for large, abbreviated numbers or truncated state names.

All
Sessions currently running in the selected Teradata Database system
Not Idle
Sessions in any state except idle
Active
Sessions running a query that is in progress
Block
Sessions running a query that is waiting for a locked resource, such as a database table or view
Defer
Sessions running a query that is in deferred queue waiting to run.
Delay
Sessions running a query that is queued waiting to run
Abort
Sessions running a query that is 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. It has not begun to execute.
Other
Sessions whose status is unknown and do not fall into any of the above categories
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