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