15.00 - Query Session States - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

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