17.10 - BLOCKED - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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