15.00 - Interpreting the Show Locks Display - Teradata Database

Teradata Database Utilities

Teradata Database
Release Number
Content Type
Publication ID
English (United States)
Last Update

Interpreting the Show Locks Display

The Show Locks utility display provides this information:

  • Summary of the showlocks function
  • Name of the databases and tables on which locks are placed
  • Username that placed each lock
  • Lock mode: read, write, exclusive, or access
  • Number of the AMPs on which the locked database or table resides
  • Show Locks reports All AMPs rather than individual AMP numbers when the locked database or table resides on all AMPs. Information is provided for only the most restrictive lock a user has placed on an object. An example of a complete Show Locks display is shown below.

        |                          |          |
        |   ___    __   ____       |  ____  __|__  ____
        |  /     |/  \  ____|  ____|  ____|   |    ____|
        |  ---   |     /    | /    | /    |   |   /    |
        |  \___  |     \____| \____| \____|   |__ \____|

        Release Version
        Show Locks Utility (May 95)

         This program queries all AMPs and reports all Host Utility locks.
     which currently exist at both the data base level and the table level.

     For each lock which is found, an entry will appear on your console
     which includes the following information:
    - Data Base Name
    - Table Name (if applicable)
    - User Name of user who placed lock
    - Lock Mode
    - AMP Number
       USER ADMIN    MODE Read    AMP  All AMPs
       USER PETERS   MODE Read    AMP  24
       USER ACCMGR   MODE Excl    AMP  27
       USER DBC      MODE Excel   AMP  3
    --ShowLocks Processing Complete--

    In the previous example, exclusive locks are placed on the employee table in the personnel database and on the entire service database. One read lock is placed on the parts database, and another read lock on the invoice table in the accounting database. Also, the following locks are applied.



    Placed the lock on the...


    invoice table that resides on all AMPs.


    parts database which resides on AMP 24.


    portion of the employee table that resides on AMP 27.


    portion of the service database that resides on AMP 3.

    When no locks are found, Showlocks reports this message:

    There are currently no host utility locks in the DBS.