IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SQLCODE "-904": Unavailable Resource


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sreejith2612

New User


Joined: 25 Jun 2007
Posts: 8
Location: India

PostPosted: Tue Jul 31, 2007 5:38 pm
Reply with quote

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
View user's profile Send private message
SharathG

New User


Joined: 23 Jan 2007
Posts: 12
Location: India

PostPosted: Thu Aug 02, 2007 7:13 pm
Reply with quote

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
View user's profile Send private message
Suryanarayana.tadala

New User


Joined: 03 Nov 2005
Posts: 43
Location: St.Louis

PostPosted: Fri Aug 03, 2007 12:32 am
Reply with quote

Please explain the problem and the scenario under which you came accross this issue..
Back to top
View user's profile Send private message
letmeknow

New User


Joined: 10 Dec 2005
Posts: 5
Location: chennai

PostPosted: Sat Aug 04, 2007 3:13 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts PuTTY - "User is not a surrogate... IBM Tools 5
No new posts Newbie Stuck on "Duplicate Datas... TSO/ISPF 5
No new posts RABBIT HOLE NEEDED - "Live"... All Other Mainframe Topics 0
No new posts Using PARM=('JPn"&SYMBOL&quo... DFSORT/ICETOOL 2
No new posts SQLCODE = -122 while using the scalar... DB2 4
Search our Forums:

Back to Top