DB2 Resource Unavailable

muthukumar · New User Joined: 24 Mar 2004 Posts: 29

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

ashwinjeerigi · New User Joined: 20 Jun 2004 Posts: 12 Location: BANGALORE

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

muthukumar · New User Joined: 24 Mar 2004 Posts: 29

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