What is RHL lock mode

Database

What is RHL lock mode

Hi,

All of my table in a database is locked for insert/update/drop. When i run lokdisp command, i get following output. What does Mode: RHL mean in following output. The database is locked even after I restart the system using 'tpa stop' and 'tpa start'. How do I get out of this situation.

Thank you.

AWS Teradata version: 14.0

/opt/teradata/tdat/tdbms/14.00.00.00/bin # ./lokdisp


 db all

- The following amps are available: 

    0     1 

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

 a

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

                   GRANTED LOCK REQUEST(S): 

Tran:  7800 000003FB

Hash Locks:     0

Host:     0 Session:     0,    0 Mode: RHL  User: ALL                           

Database: DEMO_DEV                    

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

                   GRANTED LOCK REQUEST(S): 

Tran:  7800 000003FB

Hash Locks:     0

Host:     0 Session:     0,    0 Mode: RHL  User: ALL                           

Database: DEMO_DEV                    

-------------< END OF OUTPUT >-------------

Tags (3)
1 REPLY
Teradata Employee

Re: What is RHL lock mode

RHL = Read HUT Lock

In other words, this is an archive lock; it would also show up if you run showlocks utility.

In arcmain, you can explicitly RELEASE LOCK (DEMO_DEV), OVERRIDE;

OVERRIDE can be omitted if you log on as the user that owns the lock.

To use OVERRIDE, the user must have DROP DATABASE access or be an owner of the database, e.g. user DBC.