MVSFORUMS.com

[karavi2000]

Hi,

We have a problem in inserting rows into a table for which we have access to insert values.

First we deleted all the values from the existing table using a standard IBM jcl. This job ended successfully.

Then we unloaded data from production and tried inserting those values into test database. This job got abended putting a lock on the tablespace. We instructed our DB2 admin about this and he released the lock making it to read-write status. Even then we are not able to insert any values into the table. What might be the reason? If you have any standard jcl to solve the problem, please let me know.

Thanks & Regards,
Ravishankar

[karavi2000]

Hi,

Fine. I forget to add that in my last mail. I error I got was -904. Unsuccessful execution caused by unavailable resource. This I got when trying to insert some values into the table. The DB2 system is active and the table is a standalone table with no key relationships and also we have the authority to insert values into that. Can you figure out the problem. Please let us know the possible reasons for the same.

Thanks & Regards,
Ravishankar

[CZerfas]

The error code -904 is issued for a lot of reasons. If you don't have the reason code coming with this SQL code, you merely don't know what's going on.
An unavailable ressource has nothing to do with permissions or the table definitions, but is either a physical problem of the underlying tablespace or a status problem (try "-display db(...) spacenam(...)").

regards
Christian