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).
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.
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.