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
 

 

DB2 Resource Unavailable

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

New User


Joined: 24 Mar 2004
Posts: 29

PostPosted: Tue Aug 03, 2004 1:53 pm    Post subject: DB2 Resource Unavailable
Reply with quote

Hi,

When i did a select * against a table it gave an error


DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C2010D, TYPE OF RESOURCE
00000220, AND RESOURCE NAME TDBL1V.DSNDBC.XWBKDB00.TS0003S.I0
001.A001

can any one help me to fix this

thanks & regards
Muthu
Back to top
View user's profile Send private message

ashwinjeerigi

New User


Joined: 20 Jun 2004
Posts: 12
Location: BANGALORE

PostPosted: Tue Aug 03, 2004 8:47 pm    Post subject:
Reply with quote

Create a new table and try doing select on it. It should give +100 as sql code. If it gives the same error i.e. -904 your database is having some problem. Escalate to your administrator
This is what we did. Hope this is the right answer.

Ashwin
Back to top
View user's profile Send private message
muthukumar

New User


Joined: 24 Mar 2004
Posts: 29

PostPosted: Thu Aug 05, 2004 12:01 pm    Post subject:
Reply with quote

Hi Ashwin,

thanks for the response.

What i did is did a load operation along with image copy, reorg and runstats. Then i find everything set properly.

propable reason for the error could be final updates where not updated in the sysibm catalog tables. once i did a load, reorg and runstats everything was set and the catalog tables also get updatd. This was my understanding.

( can any one confirm this)

thanks
Muthu
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 Limit CICS CPU resource vasanthz CICS 0 Tue Jan 31, 2017 7:09 am
No new posts How to find a CICS resource used in C... Arunkumar Chandrasekaran CICS 8 Thu Sep 29, 2016 1:45 pm
No new posts Check special resource availability w... pinimo JCL & VSAM 8 Fri Apr 15, 2016 8:18 pm
No new posts Issuing DEQ before ENQ with same reso... RahulG31 CICS 18 Thu Nov 26, 2015 1:51 am
No new posts CICS ENQ RESOURCE - Multiple Tasks - ... mak_tcs CICS 2 Fri Jul 17, 2015 2:29 pm


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