Locks on DB

Post Reply
haamid.gazi0
Posts: 4
Joined: Wed Oct 07, 2009 6:32 am

Locks on DB

Post by haamid.gazi0 »

Hi Team,

we have recently seen issues with locks getting created on testdb. we tried to run the rmlocks command but that didnt help. Eventually we had to clear the semaphore and then clear locks. This solution doesnt seem to be clean. we wanted to know why do locks get created on database and how can we avoid it. In the above scenario what is the cleanes method to handle this issue.

Please let us know your opinion on this as it impacts the user expectation.

Regards
Haamid
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Locks on DB

Post by John »

I'm not sure I understand where the problem is, normally locks will be continually created and released to prevent multiple processes trying to write to files at the same time, or read partial records.
John Turnbull
Thunderstone Software
Post Reply