The state filter bar allows you to display specific states by drilling down to the details view.
The state filter buttons provide a count of sessions for each state category. Click a state in the queries state filter bar to drill down to the details view. The details view displays only sessions with a query in the selected state.
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