CODEWITHSUNDEEP
sqldb2jcl
KHL
KHL

Reputation: 475

DB2 SQLCODE -904 when unloading table using JCL

While i was unloading table using JCL , i Got this error :

UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE

But the table exist in Database and even available, at the beginning it works but when i repeated the process of unloading several times it does not work.

Thanks in advance.

Upvotes: 0

Views: 1389

Answers (1)

bhamby
bhamby

Reputation: 15450

I'm guessing that if you look at the output of your unload job, you will see that the table is in either Check Pending or Copy Pending status. It's impossible to tell without more information, though.

To fix this you (or your DBA) will need to run a Repair Utility to get it out of that status.

You can see this thread on IBMMainframe.com for some more information about both statuses.

Upvotes: 1

Related Questions