on 07-28-2008 1:11 PM
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).
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Probably there's a currupt SQL package.
Deleting the SQL packages should do the trick.
greetings
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.