Server Crash - Application

[deshaipet]

Hi,

We had a situation recently. An application connected via DB2 data server client ( Application server) to the database hung for around 9 minutes and then timed out with SQL30081N. This situation occured when the database server crashed all of a sudden ( sort fo power off situation).


Ques:

1) Can some one explain why did the application did not get back a SQL return code immediately after the server crash?

Thanks,
Panditt

[Amarnath Reddy N]

Hi,

check whether ConnectionTimeo ut IBM Data Server Driver configuration keyword is enabled in your environment. This keyword is used Specifies the time in seconds to wait for a reply when trying to establish a connection to a server before terminating the attempt and generating a communication timeout.

Refer below link for more info:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.swg.im.dbclient.config.doc/doc/r0054613.html

Thanks.
Amar

[deshaipet]

Thanks a lot Amar