15.00 - State Information Displays - 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

State Information Displays

This following sections provide session information for each possible state:

  • ABORTING
  • ACTIVE
  • BLOCKED
  • DELAYED
  • IDLE
  • INDOUBT
  • INDOUBT PARSING
  • PARSING
  • QTDELAYED
  • QUIESCED ABORT
  • QUIESCED ABORT WITH LOGOFF
  • QUIESCED INDOUBT
  • RESPONSE
  • SESDELAYED
  • ABORTING State

    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 State

    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 State

    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 State

    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 State

    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 State

    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 State

    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 State

    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 State

    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 State

    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 State

    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 State

    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 State

    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 stored procedure in execution.

    SESDELAYED State

    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