-911 and -904

mailsaurabh.tripathi · New User Joined: 22 May 2008 Posts: 22 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 Post subject:

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 Post subject:

Hello,

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

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

Cris