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

DB2 Resource Unavailable


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts IEF085I REGION UNAVAILABLE,ERROR CODE... Java & MQSeries 0
No new posts UNIX System Services Resource Busy All Other Mainframe Topics 7
This topic is locked: you cannot edit posts or make replies. Unavailable RECON datasets while exec... JCL & VSAM 10
No new posts Finding IMS resource blocker after se... IMS DB/DC 1
No new posts Limit CICS CPU resource CICS 0
Search our Forums:

Back to Top