while compiling a module, unsuccessful bind problem has been encountered as described below.
Can anyone please tell me how to find which user has locked a table. First of all can all the users get that information or do only the administrators have the privilege?
Code:
READY
DSN SYSTEM(C30T)
DSN
BIND PACKAGE(ISSR3C) MEMBER(G00P220) OWNER(GENCUS?I) QUAL
RELEASE(COMMIT) CURRENTDATA(NO) ACTION(REP) VALIDATE(BIND) ISOLATIO
DSNT500I % DSNTBCM2 RESOURCE UNAVAILABLE
REASON 00E30083
TYPE 00000801
NAME ISSR3C .G00P220 .17C1B8FA0D216418
DSNT233I % UNSUCCESSFUL BIND FOR
PACKAGE = IPSC30T.ISSR3C.G00P220.()
DSN
END
READY
END
Joined: 14 Sep 2005 Posts: 50 Location: Kentucky, USA
hi
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
