Timeout in DB2.

[Amit Yadaw]

Hi,

What exactly is a timeout in DB2? Is not it just a deadlock with other name? Or at least it's very closely associated with it!??

[Anuj Dhawan]

Ah lock timeouts in DB2 are perhaps like the pain in *** for a DB2 programmer. You might have read about this already, as it sounds with the tone of your post, so I'll try slowly to talk about this.

When an application (read it as COBOL DB2 Application, let's call it CDA1) requests a lock that’s already held by another process, and the lock can’t be shared, that application,CDA1, is suspended. A suspended process temporarily stops running until the lock can be acquired on the resourece, it needs. When an application has been suspended for a pre-determined period of time (defined at system level), it will be terminated. When a process is terminated because it exceeds this period of time, it’s said to timeout. In other words, a timeout is caused by the unavailability of a given resource. So, as you see, it's not really a dead-lock.

[Amit Yadaw]

Thank you Anuj!

[Anuj Dhawan]

You're welcome!