16.10 - State Information Displays - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

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.
  • If the lock is requested for a database, the column displays the information:

    X.*

    where:

    X is the database name.

  • If the lock is requested for a table or row, the column displays the information:

    X.T

    where:

    X is the database name, and T is the table name.

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

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