View previous topic :: View next topic
|
Author |
Message |
sreejith2612
New User
Joined: 25 Jun 2007 Posts: 8 Location: India
|
|
|
|
Hi,
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? |
|
Back to top |
|
|
SharathG
New User
Joined: 23 Jan 2007 Posts: 12 Location: India
|
|
|
|
Hi Sreejith,
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? |
|
Back to top |
|
|
Suryanarayana.tadala
New User
Joined: 03 Nov 2005 Posts: 43 Location: St.Louis
|
|
|
|
Please explain the problem and the scenario under which you came accross this issue.. |
|
Back to top |
|
|
letmeknow
New User
Joined: 10 Dec 2005 Posts: 5 Location: chennai
|
|
|
|
Hi Sreejith,
Restart the database where the table resides(which you wanted to delete) and try deleting the table. It would work. |
|
Back to top |
|
|
|