0

I have some kind of bug leaving lock on table in application that is connecting to Progress OpenEdge Database. Because of the lock I'm not able to test what app is doing wrong there (since I can't test it more than once because of lock and lock seems to last for very long).

Is there a way to remove all locks from table?

RolandoMySQLDBA
  • 185,223
  • 33
  • 326
  • 536
korda
  • 635
  • 2
  • 7
  • 11

2 Answers2

2

The only way to "remove" locks from a OE db is for

  1. the transaction to go to completion (and all buffers are re-read NO-LOCK or go out of scope),
  2. the client to crash, or
  3. the db to go down.

There's no programmatic way to clear the locks generated by a client session.

Tim Kuehn
  • 221
  • 1
  • 7
1

You can use locking hints to select from tables that have locks on them.

select * from tblUser with (NOLOCK) ;

This is ok practice with adhoc sql.

Note Don't use in productioncode without reading and understanding documentation fully.

If you want to kill blocking processes: http://www.kodyaz.com/articles/identify-kill-blocking-sql-server-processes.aspx

Martin Sjöberg
  • 673
  • 1
  • 6
  • 13