Re: How to prevent dead locks ???

>We are getting dead lock errors in our production system, I looked at >informix manual for any hints on preventing it. It was mentioned that >by using certain algorithms dead lock can be prevented. Two main things that I can think of off the top of my head. 1) Use row level locking 2) Access your data in the same direction. A quick explaination about number 2 ... Deadly embraces occur because two threads access the same data but in oposite order. One thread locks some rows in table A and then goes after data in table B. The other thread locks rows in table B and then goes after data in table A. Madison Pruet