|
View previous topic :: View next topic
|
| Author |
Message |
pradyutonnet
Currently Banned
New User
Joined: 13 Nov 2005
Posts: 29
Location: pune,mumbai
|
|
|
|
My Db2 table is accessed and updated from a large number of programs daily and because of that table got deadlocks on a daily basis. Can any one explain me how can I resolve this issue, what are the possible solution to prevent it from deadlock and also in order to improve access time of table.
Thanks
Prady |
|
| Back to top |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| I see Google has over 5,000,000 hits on "deadlock", including some really nice explanations on how to avoid them .... |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Have you verified that you are dealing with a deadlock rather than a timeout. Sometimes, they are mistakenly viewed as the same problem. They are not.
If there is a deadlock problem it is not the number of programs and "hits" that causes your deadlock problem. You have deadlocks because of the design used. |
|
| Back to top |
|
|
|
|
