This following sections provide session information for each possible state:
ABORTING
The ABORTING state indicates that the session is aborting its latest request.
The ABORTING state display is shown below.
State Details : ABORTING Statements Code Time CPU Usage Accesses ---------- ---- -------- --------- -------- 1 1043 14:22:09 2 22
The columns on the ABORTING state display provide the following information.
| The column named... | Contains the... |
|---|---|
| Statements | statements, up to the number displayed, that are aborting. |
| Code | error that caused the abort. |
| Time | time that the abort step was sent to the AMP. |
| CPU Usage | accumulated time in thousandths of a second that all AMPs spent processing the current request. |
| Accesses | total number of segment access calls executed on all AMPs for the session request. |
ACTIVE
The ACTIVE state indicates that the session has sent steps to the dispatcher and possibly to one or more AMP vprocs.
The ACTIVE state display for a session not part of a FastLoad, MultiLoad, FastExport or Archive and Recovery operation is shown below.
State Details : ACTIVE Statements Dispatched Time CPU Usage Accesses ---------- ---------- -------- --------- -------- 1 1 14:22:09 2 22
The columns on the ACTIVE state display provide the following information.
| The column named... | Contains the... |
|---|---|
| Statements | total number of statements in the current session request. |
| Dispatched | highest statement number dispatched to the AMPs. |
| Time | time that the last step in the highest statement number was sent to the AMPs. |
| CPU Usage | accumulated time in thousandths of a second that all AMPs spent processing the current request. |
| Accesses | total number of segment access calls executed on all AMPs for the session request. |
BLOCKED
The BLOCKED state indicates that an active session is waiting for a database lock to be released.
The BLOCKED state display for a session is shown below.
State Details : BLOCKED Resource ------------------------------------------------------- X.T Statement AMPs Mode AMP Vproc HUT --------- ---- ---- --------- --- 1 1 READ 19 NO
The columns on the BLOCKED state display provide the following information.
| The column named... | Contains the... |
|---|---|
| Resource | database or table for which the lock is requested.
|
| Statement | highest statement number for which steps have been dispatched to the AMPs. |
| AMPs | number of AMPs for which the session is waiting to acquire a lock. |
| Mode | type of lock requested by the session. |
| AMP Vproc | number of the AMP with the blocked session. |
| HUT | host utility lock (if encountered). |
DELAYED
The DELAYED state indicates that an SQL request is delayed because a query limit has been exceeded. When the limit is no longer exceeded, the delayed requests are processed.
Teradata Viewpoint Workload Designer portlet allows you to define and manage throttle rules, which restrict the number of requests that can be simultaneously executed against Teradata Database. These rules delay or reject database requests based on specified conditions, such as the number of concurrent queries or the duration of queries. A delayed request is allowed to proceed when the rule’s limit is no longer exceeded.
The DELAYED state display for a session is shown below.
State Details : DELAYED
IDLE
The IDLE state indicates that the Teradata Database system recognizes a session, but no processing is taking place.
The IDLE state display for a session is shown below.
State Details : IDLE
INDOUBT
The INDOUBT state indicates that a two-phase commit session is in doubt. This state continues until an abort or commit is received from the host application.
The INDOUBT state display for a session is shown below.
State Details : INDOUBT
INDOUBT PARSING
The INDOUBT PARSING state indicates that a two-phase commit session is in doubt and is parsing a vote or commit request.
The INDOUBT PARSING state display for a session is shown below.
State Details : INDOUBT PARSING
PARSING
The PARSING state indicates that the session is active in the Teradata SQL parser phase, before the steps are dispatched to the AMP vprocs. The PARSING state displays no column information and only the word PARSING.
The PARSING state for a session display is shown below.
State Details : PARSING
QTDELAYED
The QTDELAYED state indicates that a session is waiting for rows to be inserted into a queue table. The QTDELAYED state is limited to 20% of the total possible sessions, which is 120 x the number of PEs. If the 20% limit is exceeded, then error message 3128 appears:
3128 Transaction aborted due to exceeding the maximum consume statement limit.
You must decrease the number of sessions consuming queue table rows. For detailed information on error message 3128, refer to Teradata Vantage™ - Database Messages, B035-1096.
The QTDELAYED state display for a session is shown below.
State Details : QTDELAYED
QUIESCED ABORT
The QUIESCED ABORT state indicates that the session is blocked from executing further requests because transactions associated with this session are being aborted. The outstanding transaction or request will be aborted.
The QUIESCED ABORT state for a session display is shown below.
State Details : QUIESCED ABORT
QUIESCED ABORT WITH LOGOFF
The QUIESCED ABORT WITH LOGOFF state indicates that the session is quiesced because the transactions or requests associated with this session are being aborted. The session is logged off.
The QUIESCED ABORT WITH LOGOFF state for a session display is shown below.
State Details : QUIESCED ABORT WITH LOGOFF
QUIESCED INDOUBT
The QUIESCED INDOUBT state indicates that the session is blocked from exercising further requests because the outstanding transaction/request will be terminated by the resolver base module.
The QUIESCED INDOUBT state for a session display is shown below.
State Details : QUIESCED INDOUBT
RESPONSE
The RESPONSE state indicates a response to a session request is in process.
The RESPONSE state for a session display is shown below.
State Details : RESPONSE Statements ---------- 1
This column for the RESPONSE display contains the following information.
| The column named... | Contains the... |
|---|---|
| Statements | highest statement number for which a response has been returned to the host or the SQL or external stored procedure in execution. |
SESDELAYED
The SESDELAYED state indicates that a session is delayed because a utility limit has been exceeded. The utilities that can be limited are FastLoad, MultiLoad, FastExport, and ARC. When the limit is no longer exceeded, the delayed requests are processed.
Teradata Viewpoint Workload Designer portlet allows you to define and manage throttle rules, which restrict the type and number of utilities that are allowed to run concurrently.
The SESDELAYED state display for a session is shown below.
State Details : SESDELAYED