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

TABLE

Purpose  

The TABLE command identifies a table-level lock request.

Syntax  

 

Syntax element...

Specifies...

DBname.Tablename

the name of a database and the name of a table separated by a required period (.).

ALL

that all tables (from all databases) that have a table-level lock request are considered.

ALL is the default if you do not specify an object name.

Usage Notes  

The following table shows the components of TABLE command output.

 

Component...

Specifies...

Tran

the currently running transactions with locks being applied.

Host

the logical host ID (origin of the transaction).

Session

the session number for the transaction.

Mode

the type of 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.

    Table

    the name of the locked table.

    Example

    The following example shows the locks on AMP 0 on the database RECBDQTAC and table T1:

    table

    - 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                   Table: T1

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

                       GRANTED LOCK REQUEST(S):

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

    Example  

    The following is an example of trying to display table-level locks on a table while trying to create the table.

    table 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 
     
    Host:     7169   Session:       0, 1441 Mode: EX    User: DBC 
     
    Database: STAFF                               Table: ??????????????????????????????
     
    Table name is not printed.