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