IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Problem with building For Stored procedure-DSNTBCM2 RESOURCE


IBM Mainframe Forums -> DB2
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
bipinpeter

Active User


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

PostPosted: Mon May 25, 2009 5:27 pm
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

Superior Member


Joined: 14 Mar 2007
Posts: 10863
Location: italy

PostPosted: Mon May 25, 2009 5:56 pm
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: 213
Location: Cochin/Kerala/India

PostPosted: Tue May 26, 2009 10:17 am
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

Superior Member


Joined: 14 Mar 2007
Posts: 10863
Location: italy

PostPosted: Tue May 26, 2009 10:27 am
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

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: 213
Location: Cochin/Kerala/India

PostPosted: Tue May 26, 2009 10:57 am
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

Moderator Emeritus


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

PostPosted: Tue May 26, 2009 7:28 pm
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
vicky614221

New User


Joined: 30 May 2023
Posts: 1
Location: India

PostPosted: Tue May 30, 2023 10:04 am
Reply with quote

Thanks Dick,

Your answer helped me for similar issue. icon_smile.gif
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3013
Location: NYC,USA

PostPosted: Thu Jun 01, 2023 6:27 pm
Reply with quote

Welcome and appreciate your kindness. However avoid tailgating any old post unless it’s absolutely needed to help others.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts building java class with zip4j.jar on... Java & MQSeries 0
No new posts z/vm installation problem All Other Mainframe Topics 0
No new posts Invoke stored procedure via batch JCL. DB2 2
No new posts Job scheduling problem. JCL & VSAM 9
No new posts Problem with IFTHEN=(WHEN=GROUP,BEGIN... DFSORT/ICETOOL 5
Search our Forums:

Back to Top