View previous topic :: View next topic
|
Author |
Message |
Narismha
New User
Joined: 22 Nov 2006 Posts: 23 Location: Mumbai
|
|
|
|
Hi,
-911 is for deadlock or timedout. -904 is for resource not available.
As per my understanding when we get -911 , we have to wait for some time and after that we restart that job with proper restart instructions. Even for -904 also we do the same thing. So for both cases our conclusion is RESOURCE NOT AVAILABLE.
Deadlock example is PGM1 holding Resource R1 and waiting for resource R2 and PGM2 holding R2 and waiting for R1.
Please explain me why do we get -911 ? (If its also for resource not available problem then why don't we get -904?). From the above example Is it possible to abend the both PGM1 and PGM2 ?? |
|
Back to top |
|
|
cobolunni
Active User
Joined: 07 Aug 2006 Posts: 127 Location: kerala,india
|
|
|
|
-904 is unsuccessful execution caused by unavailable resource
and -911 is current unit of work has been roll backed by dead lock or time out |
|
Back to top |
|
|
cobolunni
Active User
Joined: 07 Aug 2006 Posts: 127 Location: kerala,india
|
|
|
|
hello see this attachment for more info |
|
Back to top |
|
|
Narismha
New User
Joined: 22 Nov 2006 Posts: 23 Location: Mumbai
|
|
|
|
Hi Cobolunni,
Thanks for your document.
"As per my understanding when we get -911 , we have to wait for some time and after that we restart that job with proper restart instructions. Even for -904 also we do the same thing. So for both cases our conclusion is RESOURCE NOT AVAILABLE.
If both are for resource not available problems then why don't we get -904 instead of -911?. "
Please let me know if my question is not clear.
Regards,
Narisimha |
|
Back to top |
|
|
cobolunni
Active User
Joined: 07 Aug 2006 Posts: 127 Location: kerala,india
|
|
|
|
hello narismha,
Actually -904 atands for unavailable resource and we will not be able to do any data base function such as insert update etc in that case. And -911 stands for current unit of work has been roll backed because
of timeout or dead lock .In case of -911 we had done several functions on data base such as insert update etc and while doing these seres of function one function caused dead lock or timeout occurred ( Remember we had several data base functions to be committed) then all the seres of updations done on data base will be rollback and thus we will lose all the data that we updated. Actually -911 is not the case of resource unavailable its the case rollback done, also dead lock is not actually the case of resource unavailable |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
Narismha wrote: |
If both are for resource not available problems then why don't we get -904 instead of -911? |
Different types of resources. |
|
Back to top |
|
|
cobolunni
Active User
Joined: 07 Aug 2006 Posts: 127 Location: kerala,india
|
|
|
|
There are many resource types such as data base,table space,index space,compression dictionary,page,security server,table space page,storage group etc.These different types of resources creates both -904 and -911
but the effect of these are different |
|
Back to top |
|
|
MFRASHEED
Active User
Joined: 14 Jun 2005 Posts: 186 Location: USA
|
|
|
|
With -911 DB2 will issue a rollback and application has no control what so ever, so application will loose all data until last commit. Deadlock or resource un-available is of a serious nature.
With -904 , application could be in a deadlock (contention) and application has control, application can have a re-try logic and try again. |
|
Back to top |
|
|
|