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
Define db2.
What is schema in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Explain about rct in db2?
What is meant by dclgen?
What is the maximum No of rows per page?
How do I copy a table in db2?
What are the 2 sqlcodes that are returned?
What is the function of logging in the db2 database?
What are union and union all?
What is commit in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
How to run db2 command in windows?
What is check constraint in db2?
