Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

SQLCODE "-904": Unavailable Resource

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: SQLCODE "-904": Unavailable Resource
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    Post subject: Re: SQLCODE "-904": UNAVAILABLE RESOURCE
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    Post subject:
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    Post subject: Sqlcode -904 Unavailable Resource
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Changeman get multiple "Browse C... elixir1986 Compuware & Other Tools 4 Fri Jul 14, 2017 1:48 am
No new posts Include/omit with "ALL" pa... mgl DFSORT/ICETOOL 6 Wed Jun 14, 2017 2:31 pm
No new posts READ A PACKED "NEGATIVE" FI... jdesouza CA Products 3 Tue May 02, 2017 11:43 pm
No new posts RC 20 for Address ISPEXEC "ISRED... pkmurali CLIST & REXX 3 Sun Apr 16, 2017 11:30 pm
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us