View previous topic :: View next topic
|
Author |
Message |
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 |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
|