17.10 - Query Session States - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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.