-911 and -904

mailsaurabh.tripathi · New User Joined: 22 May 2008 Posts: 56 Location: hyderabad

What are the steps to be followed to get rid off from -911 and -904

guptae · Posted: Tue Oct 07, 2008 12:40 pm

Hello Saurabh,

-904 :UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE.
The sql stmt can not be executed since resource not available .Message will show you resource name just check the resource avaiablity.
1)It can be because tablespace/ IX dataset are migrated ..in that case recall them & then try again
2) May be tablespace are not in RW mode check with ur DBA's

-911:THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO DEADLOCK OR TIMEOUT. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name
o 00C90088 - deadlock

o 00C9008E - timeout

Check whether you have any indoubt thread running just abort them & try again

dick scherrer · Posted: Tue Oct 07, 2008 9:43 pm

Hello,

Cristopher · New User Joined: 31 Jul 2008 Posts: 53 Location: NY

Saurabh,
You can go through the attached document.
Hopefully, it will help you in clearing some of your doubts.

Cris

dineshpost · Posted: Mon Dec 22, 2008 3:14 pm

For -904.....

Check with DBA if the id has the more RLF limits. There are chances for timeouts if the id does have enough RLF limits. It is good to check with DBA to increase the RLF limits to avoid resource unavailable status.

Shriram Jogdand · New User Joined: 14 Oct 2008 Posts: 65 Location: Pune

I also faced the same problem some time back. You can resolve this issue by changing the ISOLATION LEVEL. While binding the plan/package, keep the Isolation level as CS i.e. cursor stability.

Terry Heinze · Posted: Tue Dec 23, 2008 12:23 am

Sometimes a -904 can be caused by not committing often enough. Of course, it depends on the resource type. Several things cause a -904.