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
what is the role of the cursor in db2?
How can you find out the # of rows updated after an update statement?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is access path in db2?
What is runstats and reorg in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
What is difference between alias and synonym in db2?
Explain the contention situations caused by locks?
What is db2 bind?
What is iseries database?
Is db2 relational database?
How to view db2 table structure?
List down the data types in the db2 database.
How will you return the number of records in table?
What are db2 tables?