15.00 - Interpreting the Show Locks Display - 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

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 14.00.00.00 Version 14.00.00.00
        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
    accounting.invoice
       USER ADMIN    MODE Read    AMP  All AMPs
    parts
       USER PETERS   MODE Read    AMP  24
    personnel.employee
       USER ACCMGR   MODE Excl    AMP  27
    service
       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.

     

    Username...

    Placed the lock on the...

    ADMIN

    invoice table that resides on all AMPs.

    PETERS

    parts database which resides on AMP 24.

    ACCMGR

    portion of the employee table that resides on AMP 27.

    DBC

    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.