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
 

 

SQL CODE -904: UNAVAILABLE RESOURCE

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
Bhagyalakshmi C

New User


Joined: 24 Jul 2007
Posts: 38
Location: Bangalore

PostPosted: Thu Aug 23, 2007 5:58 pm    Post subject: SQL CODE -904: UNAVAILABLE RESOURCE
Reply with quote

Hi all,

I am getting -904 sql code when i try to update a table using a PLI program.
I know that its is
"UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE."

Could any one please tell me what should be done for successful execution.

Help me!!!!

Thanks all!!
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Aug 26, 2007 7:38 am    Post subject:
Reply with quote

Hello,

For someone here to help, you need to post the information you have (or can be made) available - with what you've posted, there is very little to work with.

You at least need to post the reason-code, resource-type, and the resource-name. If any other info is available, post that as well.

There is also Problem Determination help available in the manuals
Back to top
View user's profile Send private message
mf_karthik

New User


Joined: 26 Jul 2005
Posts: 55

PostPosted: Sun Aug 26, 2007 11:56 am    Post subject: Reply to: SQL CODE -904: UNAVAILABLE RESOURCE
Reply with quote

Hi,
I think the database which you are trying to update is not in R/W mode.
check with DBA.

Regards,
Karthik
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Sun Aug 26, 2007 2:52 pm    Post subject:
Reply with quote

The message says that the resource is unavailble.

What resource ? Why is it unavailable ?
Back to top
View user's profile Send private message
keshav_mf

New User


Joined: 25 Jun 2007
Posts: 2
Location: Bangalore

PostPosted: Sun Aug 26, 2007 3:27 pm    Post subject:
Reply with quote

During execution of some other program may using the resource.Just rerun the program from top.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Sun Aug 26, 2007 3:39 pm    Post subject:
Reply with quote

keshav_mf

Just rerunning the job is not really an option until the OP has determined the cause of the error. There are so many different reasons that could cause the error, so maybe finding out why the error occured would be the first step rather than resub and hope.
Back to top
View user's profile Send private message
rjskumar_14

New User


Joined: 13 Jul 2006
Posts: 10

PostPosted: Wed Sep 12, 2007 9:38 pm    Post subject:
Reply with quote

rerunning the program wont be sufficient in this case. you need to run a repair utility i think


thnks

rjsk
Back to top
View user's profile Send private message
amrita.chatterjee

New User


Joined: 27 Apr 2006
Posts: 48
Location: Bangalore, India

PostPosted: Thu Sep 13, 2007 2:40 pm    Post subject: Reply to: SQL CODE -904: UNAVAILABLE RESOURCE
Reply with quote

Just run the DB2 commands to find out which program or job is holding this table?
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 -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm


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