Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / deepak
-904 UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE
RESOURCE. REASON reason-code, TYPE OF RESOURCE resource-
type, AND RESOURCE NAME reason-name
Explanation: The SQL statement could not be executed
because resource resource-name of type resource-type was
not available at the time for the reason indicated by
reason-code.
Try to display the stats of the table and check if it is in
RW mode, If not use the required repair utility to get the
table to RW mode.
If the table is in RW mode then may be the underlying
dataset may have got deleted in that case we will need to
do a dummy load to get those created.
If that also doesnt work will need to drop and recreate the
objects from TABLESPACE level.
Ths above is for IBM DB2 for z/os. Correct me if Iam wrong
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How does db2 sample database connect?
Explain what are the various isolation levels possible?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How to test SQL -911 error while developing COB-DB2 program
What is the maximum length of sqlca?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is an instance in db2?
How to check last update on table in db2?
What are the contents of a dclmgen?
How to find the maximum value in a column in the db2 database?
What is buffer pool?
What are the prerogatives?
is it compulsory commitment control in journal?
What is innodb buffer pool?
what is the sqlcode -501
