|
View previous topic :: View next topic
|
| Author |
Message |
bipinpeter
Active User
.jpg)
Joined: 18 Jun 2007
Posts: 213
Location: Cochin/Kerala/India
|
|
|
|
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 |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
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 
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 |
|
|
bipinpeter
Active User
Joined: 18 Jun 2007
Posts: 213
Location: Cochin/Kerala/India
|
|
|
|
Hi,
The reason and type which given in the error description as below,
| Code: |
REASON 00E30083
TYPE 00000801 |
|
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
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 |
|
|
bipinpeter
Active User
Joined: 18 Jun 2007
Posts: 213
Location: Cochin/Kerala/India
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
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. . .  |
|
| Back to top |
|
|
vicky614221
New User
Joined: 30 May 2023
Posts: 1
Location: India
|
|
|
|
Thanks Dick,
Your answer helped me for similar issue.  |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA
|
|
|
|
| Welcome and appreciate your kindness. However avoid tailgating any old post unless it’s absolutely needed to help others. |
|
| Back to top |
|
|
|
|
