All Forums Database
karun.poudel 2 posts Joined 06/13
12 Apr 2015
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 >-------------

 

 

Fred 1096 posts Joined 08/04
16 Apr 2015

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.

You must sign in to leave a comment.