16.10 - Query Session States - 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

Query Session provides information on the following possible states of a session.

The Session State... Indicates that...
ABORTING the session is aborting its latest request.
ACTIVE the session has sent steps to the dispatcher and possibly to one or more AMP vprocs.
BLOCKED an active session is waiting for a database lock to be released.
DELAYED the session is being delayed because query limit, imposed by a Teradata Active System Management (TASM) throttle rule, has been met.
IDLE the Teradata Database system recognizes a session, but no processing is taking place.
INDOUBT a two-phase commit session is in doubt.
INDOUBT PARSING a two-phase commit session is in doubt and is parsing a vote or commit request.
PARSING the session is active in the Teradata SQL parser phase, before the steps are dispatched to the AMP vprocs.
QTDELAYED the session is waiting for rows to be inserted into a queue table.
QUIESCED ABORT the session is blocked from executing further requests because transactions associated with this session are being aborted.
QUIESCED ABORT WITH LOGOFF the session is quiesced because the transactions or requests associated with this session are being aborted, after which this session will be logged off the machine.
QUIESCED INDOUBT the session is blocked from exercising further requests because the outstanding transaction/request will be terminated.
RESPONSE a response to a session request is in process.
SESDELAYED the session is being delayed because a utility limit, imposed by a TASM throttle rule, has been met.