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