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.
AWS Teradata version: 14.0
/opt/teradata/tdat/tdbms/14.00.00.00/bin # ./lokdisp
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.