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

ROWRANGE

Purpose  

The ROWRANGE command identifies a rowrange-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 (.).

TypeAndIndex

a subtable identifier.

A table is composed logically of one or more subtables. TypeAndIndex specifies one of these subtables. For example:

  • 0 is the table header.
  • hex 400 (decimal 1024) is a primary subtable.
  • hex values 404, 408, and 40C (decimal values 1028, 1032, and 1036), and other +4 incremental values, are secondary index subtables.
  • hex values 800, C00, and 1000 (decimal values 2048, 3072, and 4096), and other multiples of hex 400 (decimal 1024) are fallback subtables.
  • ALL

    that all tables that have a rowrange-level lock request are considered.

    ALL is the default if you do not specify the command parameters.

    Usage Notes

    The following table shows the components of ROWRANGE 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 table being locked.

    Row Range

    the range of rows being locked.

    Example  

    The following example shows locks on AMP 0 on Database STAFF and Table MANAGEMENT.

     
    > rowrange staff.management 0
    rowrange staff.management 0
    - The following amps are available: 
     
        0     1     2 
     
    -> 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 -------------
                   
                   
                       BLOCKED LOCK REQUEST(S): 
                   
    Tran: 16383 00001354
    Host:     0  Session:     0, 2053       Mode: Ac   User: TD 
    Database: STAFF                         Table: MANAGEMENT 
    Row Range Lock                          Subtable ID: 0
    Row Hash1:     0,    1                  Row Hash2: 0,   2    #