Query Session States - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

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 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.