View previous topic :: View next topic
|
Author |
Message |
Bhagyalakshmi C
New User
Joined: 24 Jul 2007 Posts: 38 Location: Bangalore
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
mf_karthik
New User
Joined: 26 Jul 2005 Posts: 55
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
The message says that the resource is unavailble.
What resource ? Why is it unavailable ? |
|
Back to top |
|
|
keshav_mf
New User
Joined: 25 Jun 2007 Posts: 2 Location: Bangalore
|
|
|
|
During execution of some other program may using the resource.Just rerun the program from top. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
rjskumar_14
New User
Joined: 13 Jul 2006 Posts: 10
|
|
|
|
rerunning the program wont be sufficient in this case. you need to run a repair utility i think
thnks
rjsk |
|
Back to top |
|
|
amrita.chatterjee
New User
Joined: 27 Apr 2006 Posts: 48 Location: Bangalore, India
|
|
|
|
Just run the DB2 commands to find out which program or job is holding this table? |
|
Back to top |
|
|
|