DBIF_RSQL_SQL_ERROR

[Former Member]

Hi all,

getting above dump ,ca any one suggest what would be the reason,.

Database error text........: " DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL

EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C90083, TYPE OF RESOURCE

00000200, AND RESOURCE NAME S955 .S955X DSNT418I SQLST

Internal call code.........: "[RSQL/UPDT/S955 ]"

Please check the entries in the system log (Transaction SM21).

[thomas_vogt · Accepted solution]

Hello,

see [IBM docs|http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnc1k12/3.7?ACTION=MATCHES&REQUEST=00C90083&TYPE=FUZZY&SHELF=dsnshka2.bks&DT=20080208042014&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT] . There's a utility active.

Regards,

Thomas

[brian_walker]

We have seen the -904 reason 00C90083 on a resource during a reorg of a table. Of course the reorg is done by a DB2 utility. Normally this clears up on its own, and it is also best to use the SHRLEVEL(CHG) option to minimize the time a table is unavailable. This does require more disk space for the shadow copy and image copy. It is also possible that the utility had a problem and left an object in some sort of pending state.

Brian

[brian_walker]

BTW, resource type 200 is a tablespace. So if the resource name you copied in is the full one, it is in database S955 and tablespace S955X.

Happy hunting!

Brian

[Former Member]

Hi,

Probably there's a currupt SQL package.

Deleting the SQL packages should do the trick.

greetings