While trying to perform delete operation on a DB2 table through JCL, I got an SQLCODE of -904 (UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE). On analysing, I found that the dataset( say ABC) mentioned in error explanation was not cataloged. ABC is expected to be found associated with the table space or index space. I've no idea why its not present.
Hence, could somone tell me what can I do to go ahead with the process? Also, if it'll work only if ABC is present, is there any way I can recreate ABC or do anything like that?
I had faced this issue sometime back and the reason was that the table was in Check Pending State. A table will be in Check Pending state due to several reasons, one among which is that it might have orphan rows (An orphan row is one whose primary key does not have an associated key in the parent table). Is this table a child to any table?