Timeout and resource unavailable.(-911 with timeout vs -904)


This is quite tricky one to know. Well i thought so.
-904 SQLCODE: Unavailable resource.
-911 SQLCODE: Deadlock or timeout.But i am talking about timeout here.So we will get timeout since the resource is not available so the application will go in suspention mode and wait for some time( equal to IRLMRWT DSNZPARM paramater)and then timeout.


SO WHAT EXACTLY THE DIFFRANCE BETWEEN -911 WITH TIMEOUT AND -904.


A -911 is a lock timeout and occurs only when trying to access data that is locked by another process.

A -904 is a resource unavailable, and can be caused by any number of resources that are not available. The -904 will have an associated reason code and type code. The reason tells you the "why" and the type code will tell you the "what." Reason codes and type codes are documented in the DB2 for z/OS Codes manual which is GC19-2971 for Version 10.

5 comments:

Anonymous said...

This is the question i asked in almost all the big formus and website available on internet on mainframe but no one was able to give me the satisfying answer but i must say here that i think i got the answer after coming here.

oh did i told you this blog is damn cool.keep it up

thanks,
mark

Anonymous said...

I must really thank u Nitin for this useful bolg!

Thanks,
Sandhya.

Nitin Gandhi said...

Thank you Sandhya for those nice words.

Anonymous said...

Hey Nitin,

Your explanations are like a mentor standing before me and explaining. Thanks for the nicely documented scenarios and examples. Just one read we are able to grasp the topic.

Thanks
Ganesh

Suriya said...

Well explained Nitin. Thanks for explaining the technical in man's words.

Post a Comment