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
 

 

Difference between -911 and -904 in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
Narismha

New User


Joined: 22 Nov 2006
Posts: 23
Location: Mumbai

PostPosted: Fri Dec 08, 2006 1:00 pm    Post subject: Difference between -911 and -904 in DB2
Reply with quote

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
View user's profile Send private message

cobolunni

Active User


Joined: 07 Aug 2006
Posts: 128
Location: kerala,india

PostPosted: Fri Dec 08, 2006 2:50 pm    Post subject: Re: Difference between -911 and -904 in DB2
Reply with quote

-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
View user's profile Send private message
cobolunni

Active User


Joined: 07 Aug 2006
Posts: 128
Location: kerala,india

PostPosted: Fri Dec 08, 2006 2:54 pm    Post subject: Re: Difference between -911 and -904 in DB2
Reply with quote

hello see this attachment for more info
Back to top
View user's profile Send private message
Narismha

New User


Joined: 22 Nov 2006
Posts: 23
Location: Mumbai

PostPosted: Mon Dec 11, 2006 2:03 pm    Post subject:
Reply with quote

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
View user's profile Send private message
cobolunni

Active User


Joined: 07 Aug 2006
Posts: 128
Location: kerala,india

PostPosted: Mon Dec 11, 2006 6:19 pm    Post subject:
Reply with quote

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
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Mon Dec 11, 2006 6:37 pm    Post subject:
Reply with quote

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
View user's profile Send private message
cobolunni

Active User


Joined: 07 Aug 2006
Posts: 128
Location: kerala,india

PostPosted: Mon Dec 11, 2006 7:31 pm    Post subject:
Reply with quote

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
View user's profile Send private message
MFRASHEED

Active User


Joined: 14 Jun 2005
Posts: 186
Location: USA

PostPosted: Mon Dec 11, 2006 9:14 pm    Post subject: Re: Difference between -911 and -904 in DB2
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Difference between TWALENG and TWASIZE Arunkumar Chandrasekaran CICS 3 Tue Jan 03, 2017 12:57 pm
No new posts Sticky: difference between ... DUMMY ... and ... enrico-sorichetti JCL & VSAM 0 Mon Oct 17, 2016 4:31 pm
No new posts Difference space showed for TS and it... autobox DB2 1 Thu Apr 14, 2016 1:07 pm
No new posts Difference Between CICS WebSupport an... sachinji84 CICS 1 Mon Mar 07, 2016 7:25 pm
No new posts Difference between -180 and -181 with... deepak_shrivastava DB2 4 Wed Jan 06, 2016 10:00 am


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