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 to execute stored procedure in db2 command editor?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is the maximum No of rows per page?
Is the primary key a clustered index?
What does db2 blu stand for?
When do you specify the isolation level?
How to fetch the last row from the table in SQL (db2)?
What is the maximum length of sqlca?
Why do we need reorg in db2?
What is a db2 schema?
What are the uses of db2 optimizer?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What are the two types of logging in the db2 database? Explain them.
Define predicate?
