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 do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the purpose of using commit?
What are the two types of logging in the db2 database? Explain them.
What is table space in db2?
How to restart a DB2 program?
What is copy pending status in db2?
How many types of page locks can be held in db2?
What is the advantage in De-normalizing tables in DB2?
What is universal database?
What is the syntax for creating a table in the db2 database?
What is null value in db2?
Is ibm db2 free?
What is the function of logging in the db2 database?
What is dbrm?
Define db2 and its databases?