15.00 - DB - 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

DB

Purpose  

The DB command identifies the databases that have a database-level lock request.

Syntax  

 

Syntax element...

Specifies...

DBname

the name of a database.

ALL

that all databases that have a database-level lock request will be considered.

ALL is the default if you do not specify a database name.

Usage Notes

The following table shows the components of DB command output.

 

Component...

Specifies...

Tran

currently running transactions with locks being applied.

Host

the logical host ID (the origin of the transaction).

Session

the session number for the transaction.

Mode

the lock mode:

  • Access
  • Read
  • Write
  • Exclusive
  • User

    the logon-ID for whom the lock is being requested.

    Database

    the name of the database being locked.

    Example

    The following example shows locks on a sampling on all AMPs for the RECBDQTAC database:

    >lokdisp

    Amp Utility
     _______
        |                                |              |
        |    ___     __     ____         |    ____    __|__    ____
        |   /      |/  \    ____|    ____|    ____|     |      ____|
        |   ---    |       /    |   /    |   /    |     |     /    |
        |   \___   |       \____|   \____|   \____|     |__   \____|

        Release 14.00.00.00 Version 14.00.00.00
        LOCK DISPLAY UTILITY (June 2000)

    LOCK DISPLAY UTILITY Command String Syntax:

        Help or ?
        TRan     [ProcId Uniq1 Uniq2] | [ALL]
        Db       [DBname] | [ALL]
        TAble    [DBname.Tablename] | [ALL]
        ROWRange [DBname.Tablename TypeAndIndex] | [ALL]
        ROWHash  [DBname.Tablename TypeAndIndex, RowHash1 RowHash2] | [ALL]
        Blockers [TRAN [ProcId Uniq1 Uniq2] | [ALL]] | [LIMIT [Number] | [NONE]]
        Quit

    -> Please enter your selection from the list: db

    - The following amps are available: 

        0     1     2     3 

    -> Which amp(s) do you want to request on (S=Sampling/A=all/C=cancel/Q=quit):
    a>
    a

    ---------------- AMP 0 REPORTS 1 LOCK ENTRIES -------------

                       GRANTED LOCK REQUEST(S):

    Tran: 16383 00000114
    Host:  2049 Session:     0, 1000 Mode: WR*  User: DBC
    Database: RECBDQTAC


    ---------------- AMP 2 REPORTS 1 LOCK ENTRIES -------------

                       GRANTED LOCK REQUEST(S):

    Tran: 16383 00000114
    Host:  2049 Session:     0, 1000 Mode: WR*  User: DBC
    Database: RECBDQTAC

    Example  

    The following example tries to display database-level locks while trying to create database USER1. The first lock is an Intentional Write Lock on database DBC (user DBC), and the second lock is an Intentional Exclusive Lock on database USER1 (user DBC).

    LOKDISP >>
     
    DB ALL
     
     - The following amps are available:
     
        0
     
     -> Which amp(s) do you want to request on (S=Sampling/A=all/C=cancel/Q=quit):
    A
     
    ---------------- AMP 0 REPORTS 2 LOCK ENTRIES -------------
     
     
                       GRANTED LOCK REQUEST(S):
     
    Tran: 16383 000008B8
    Host:  7169 Session:     0, 1010 Mode: WR*  User: ??????????????????????????????
     
    Database: ??????????????????????????????
     
    Host:  7169 Session:     0, 1010 Mode: EX*  User: ??????????????????????????????
     
    Database: ??????????????????????????????