Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 213
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: 10308
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: 213
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: 10308
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: 213
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 LMINIT problem - not finding DDNAME Danielle.Filteau CLIST & REXX 7 Tue Sep 19, 2017 9:57 pm
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts Finding IMS resource blocker after se... Hooman24 IMS DB/DC 1 Wed Aug 16, 2017 9:17 pm
No new posts Problem commiting to DB2 from IMS MPP Ole Soerensen IMS DB/DC 2 Wed Jul 26, 2017 5:19 pm
No new posts Strings with double quotes having pro... raja Arumugam All Other Mainframe Topics 11 Thu Mar 30, 2017 10:34 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us