Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Unsuccessful bind problem has been encountered

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
ksivalakshmi

New User


Joined: 15 Nov 2005
Posts: 2
Location: Hyderabad

PostPosted: Wed Dec 14, 2005 7:05 pm    Post subject: Unsuccessful bind problem has been encountered
Reply with quote

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                                                                             


Thanks in advance
Back to top
View user's profile Send private message

muffirulz

New User


Joined: 14 Sep 2005
Posts: 74
Location: Kentucky, USA

PostPosted: Thu Dec 15, 2005 2:52 am    Post subject: Re: Unsuccessful bind problem has been encountered
Reply with quote

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.
Back to top
View user's profile Send private message
senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

PostPosted: Thu Dec 15, 2005 11:03 am    Post subject:
Reply with quote

Hi,

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


Regards
senthil

''correct me if i am wrong''
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts DB2 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm
No new posts Problem with GETMAIN command amitc23 CICS 6 Thu Sep 01, 2016 1:01 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us