Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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
This topic is locked: you cannot edit posts or make replies. Extract all "IF" Statements... Adarsh Damodaran CLIST & REXX 1 Wed Sep 06, 2017 9:28 am
No new posts Finding IMS resource blocker after se... Hooman24 IMS DB/DC 1 Wed Aug 16, 2017 9:17 pm
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

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us