Joined: 14 Sep 2005 Posts: 74 Location: Kentucky, USA
Well as it shows that the error has occured due to deadlock condition, there are many ways. One is that you can externally go to db2 bind options and give a bind command and check if it throws the error or else check which tables u are using and then see if anyone of that table is giving you a deadlock condition.
this problem may be due to deadlock or timeout . mostly resource unavailable problem is due to the timeout .actually your job is waiting for long time to get the resource . if it is crosses the time limit which is set in installation of DB2 .
you can tell to db2 admin people to check the any job is hold that resource or not . if it so cancel the thread which is hold that resource and you try to rebind it