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
 

 

Problem with building For Stored procedure-DSNTBCM2 RESOURCE

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

Active User


Joined: 18 Jun 2007
Posts: 208
Location: Cochin/Kerala/India

PostPosted: Mon May 25, 2009 5:27 pm    Post subject: Problem with building For Stored procedure-DSNTBCM2 RESOURCE
Reply with quote

Hi All,
When i am building a stored procedure i am getting an error
Code:
  DSNTBCM2 RESOURCE NOT AVAILABLE

The tables which is using in t hat program is existing and i can able to browse those tables thru DB2 file aid and image copy is not pending.
Do any one know the solution for this problem.For binding it is taking so much time and finally it is saying the above error.

Regards,
Bipin Peter
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Mon May 25, 2009 5:56 pm    Post subject: Reply to: Problem with building For Stored procedure-DSNTBCM
Reply with quote

if You had posted what resource was not available, You could have got some useful answers

You should have got something along the line
Code:
DSNT500I  % DSNTBCM2 RESOURCE UNAVAILABLE                                       
           REASON 00E30083   ( some reason code )                                                   
           TYPE 00000801   ( some resource type ) ... more info ...

IIRC there are 93 resource types in DB2 so guessing which one is a problem for You is a bit awkward icon_biggrin.gif

the fastest thing to get a quick solution is to speak to your support, most probably it will their job to fix the issue
Back to top
View user's profile Send private message
bipinpeter

Active User


Joined: 18 Jun 2007
Posts: 208
Location: Cochin/Kerala/India

PostPosted: Tue May 26, 2009 10:17 am    Post subject:
Reply with quote

Hi,
The reason and type which given in the error description as below,

Code:
REASON 00E30083   
TYPE 00000801   
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Tue May 26, 2009 10:27 am    Post subject: Reply to: Problem with building For Stored procedure-DSNTBCM
Reply with quote

did You try something Yourself ( reading the manual, I mean )
or are You waiting for somebody to do it for You ??

use the lookat facility of the IBM website and cut an paste into the message ID/search area the reason code,
it will quickly give You the solution of Your problem

http://www-03.ibm.com/systems/z/os/zos/bkserv/lookat/

and paste 00E30083

also searching the forums with 00E30083 will return useful hits
Back to top
View user's profile Send private message
bipinpeter

Active User


Joined: 18 Jun 2007
Posts: 208
Location: Cochin/Kerala/India

PostPosted: Tue May 26, 2009 10:57 am    Post subject:
Reply with quote

Hi enrico,
I already serached for this return code in the manuals...Its saying that its due to some dead lock or timed out.. But i'm not not able to find out the real problem.. Dead lock or timed giving me while accessing any tables???
or else?


Regards,
Bipin Peter
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue May 26, 2009 7:28 pm    Post subject:
Reply with quote

Hello,

You have posted what the problem is. . .

You want to use something that is already in use - the plan you are trying to bind. Thus: DSNTBCM2 RESOURCE NOT AVAILABLE

FWIW - i believe this is one of the worst "features" in DB2. . . icon_confused.gif
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 Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am


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