BLOCKED - Teradata Vantage - Database Engine 20

Database Utilities
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2026-03-26
dita:mapPath
ron1747160181474.ditamap
dita:ditavalPath
ft:empty
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantage™

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

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