release lock

Database
Enthusiast

release lock

i have some session locked by for some hours.
how can i release the lock ?
1 REPLY
Enthusiast

Re: release lock

Your problem is due to session block. One session might be holding up locks and does not release them until the transaction is completed. If the transaction is delayed due to some reason, the other sessions will be queued to acquire locks on objects held by the blocking session.

To release such locks held by blocking session abort the blocking session using PMON or Teradata Manager Session info facility.

Another way of releasing locks is to run RELEASE LOCK from BTEQ.I beleive this is not recommended unless until there is a serious requirement to release a lock (preferably a HUT lock).