State Filter | System State | Teradata Viewpoint - State Filter Bar - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
Product Category
Analytical Ecosystem

The state filter bar allows you to display specific states in the view. For a Teradata system, if the number of states exceeds the available space, you can select another state from the Overflow Menu. The new state replaces the last state on the state filter bar.


Viewpoint state filter bar

The state filter buttons provide a count of sessions for each state category. Click a state in the state filter bar to display only sessions with a query in the selected state. For example, click Delay to display the sessions running a query that is queued and waiting to run. Hover over a state filter button to display the full state name or number.

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
Deferred
Sessions running a query that is in deferred queue waiting to run.
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
Direct Blockers*
Sessions that immediately block the current session

For example, if session 1 is blocking session 2, which in turn is blocking session 3, the Blocked By tab for session 3 shows both sessions 1 and 2 under All. Under Direct Blockers, it shows only session 2.

Root Cause*
Sessions that are not blocked, but are causing other sessions to be blocked
Granted*
Sessions that are blocked and are blocking other sessions because they have been granted a lock
Waiting*
Sessions that are blocked and are ahead of other blocked sessions in the queue

*Appears when By Blocker has been selected from the menu and when connected to Teradata Database 15.0 and later.

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

Teradata Machine Learning Engine States

All
Sessions in the system
Active
Sessions processing queries
Idle
Sessions not running