Release Lock Impact

Database
Enthusiast

Release Lock Impact

Hi, I am new to TD. I have a query about locks. If user palced a lock on database to execute a batch of transactions and DBA by mistake releases the lock with override on that specific database. Will it roll back that batch of transactions or what will happen exactly and may it harm the business logic or can leave some inconsistencies etc. if there is some effect because of this which log table have its record? Thank You


Accepted Solutions
Junior Contributor

Re: Release Lock Impact

No DBA can release a transaction lock (unless he aborts the session).

The RELEASE LOCK WITH OVERRIDE applies only to ARC-locks, i.e. Backup/Restore.

1 ACCEPTED SOLUTION
2 REPLIES
Junior Contributor

Re: Release Lock Impact

No DBA can release a transaction lock (unless he aborts the session).

The RELEASE LOCK WITH OVERRIDE applies only to ARC-locks, i.e. Backup/Restore.

Enthusiast

Re: Release Lock Impact

Thank You for your prompt reply.