dead lock errors

[logic4fun]

Hi all,
I have an embedded sql program (C + SQL) which is throwing me a dead lock errors(sqlcod -911) sometimes when it updates a column in a table. Normally to my knowledge when it throws deadLock error for inserts or delets we can avoid it by frequent commits. but dont understand how to deal this. This particular applications runs on 8 nodes simultaneously trying to update a column of a table on its respective node.


Thanks in advance
Logic4fun

 

[sathyarams]

Not too sure if you verified that you are getting deadlocks and not timeouts ... (-911 could mean either)

Search this forum deadlocks .

There have been a number of posts in

http://www.dbforums.com/f8

on deadlocks and locktimeouts ... You can try searching that forum also

Cheers
Sathyaram



More DB2 questions answered at

http://www.dbforums.com/f8