Connection break - DB2 on Unix.

Saravana Kumar Ganesan

Connection break - DB2 on Unix.

Dear Gurus,
I have a perculiar problem at hand. Application team reports that
in UAT environment the connection is getting broken if it is kept idle for
some time whereas in dev env the connection is alive even after few days of
no activity.
The dbm and db cfg parameters are same across both environments. I
believe there is no connection timeout in DB2. One of the situation when
Db2 will terminate a connection is deadlock. But in our case the
connection broken when it is idle.
Can you please throws some light on other scenarios when Db2 will
terminate a connection ? Where can I check why the connection is terminated
?

With Regards
Saravana.
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Dieter Schwarz

Re: Connection break - DB2 on Unix.
(in response to Saravana Kumar Ganesan)
Saravana,

are both environments on the same site/machine (i.e. same network)? or is there some timeout due to vpn, rooter....?
try to give it a permanent ping ...
----- Original Message -----
From: Saravana Kumar Ganesan
Newsgroups: bit.listserv.db2-l
To: [login to unmask email]
Sent: Monday, December 17, 2007 3:29 AM
Subject: [DB2-L] Connection break - DB2 on Unix.


Dear Gurus,
I have a perculiar problem at hand. Application team reports that in UAT environment the connection is getting broken if it is kept idle for some time whereas in dev env the connection is alive even after few days of no activity.
The dbm and db cfg parameters are same across both environments. I believe there is no connection timeout in DB2. One of the situation when Db2 will terminate a connection is deadlock. But in our case the connection broken when it is idle.
Can you please throws some light on other scenarios when Db2 will terminate a connection ? Where can I check why the connection is terminated ?

With Regards
Saravana.
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at www.idug.org under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services


The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Tim Brumfield

Re: Connection break - DB2 on Unix.
(in response to Dieter Schwarz)
I'm no guru (grin) but I would check your UAT environment to be sure the DB2 Governor is not running... it can be setup to time out idle connections.

HTH,
--Tim

>>> Saravana Kumar Ganesan <[login to unmask email]> 12/16/2007 8:29 PM >>>

Dear Gurus,
I have a perculiar problem at hand. Application team reports that
in UAT environment the connection is getting broken if it is kept idle for
some time whereas in dev env the connection is alive even after few days of
no activity.
The dbm and db cfg parameters are same across both environments. I
believe there is no connection timeout in DB2. One of the situation when
Db2 will terminate a connection is deadlock. But in our case the
connection broken when it is idle.
Can you please throws some light on other scenarios when Db2 will
terminate a connection ? Where can I check why the connection is terminated
?

With Regards
Saravana.
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Erick Wodarz

Re: Connection break - DB2 on Unix.
(in response to Tim Brumfield)
You may want to check this ...

http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q1=DB2TCP_CLIE
NT_CONTIMEOUT&uid=swg21231084&loc=en_US&cs=utf-8&lang=en

There were some problems with tcpip in fixpacks before db2 v8 12 I beleive
as well. Can't seem to find the relevant APAR's though?


> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
> Behalf Of Tim Brumfield
> Sent: Tuesday, December 18, 2007 15:25
> To: [login to unmask email]
> Subject: Re: [DB2-L] Connection break - DB2 on Unix.
>
>
> I'm no guru (grin) but I would check your UAT environment to
> be sure the DB2 Governor is not running... it can be setup
> to time out idle connections.
>
> HTH,
> --Tim
>
> >>> Saravana Kumar Ganesan <[login to unmask email]> 12/16/2007 8:29 PM >>>
>
> Dear Gurus,
> I have a perculiar problem at hand. Application team
> reports that
> in UAT environment the connection is getting broken if it is
> kept idle for
> some time whereas in dev env the connection is alive even
> after few days of
> no activity.
> The dbm and db cfg parameters are same across both
> environments. I
> believe there is no connection timeout in DB2. One of the
> situation when
> Db2 will terminate a connection is deadlock. But in our case the
> connection broken when it is idle.
> Can you please throws some light on other scenarios
> when Db2 will
> terminate a connection ? Where can I check why the connection
> is terminated
> ?
>
> With Regards
> Saravana.
> The IDUG DB2-L Listserv is only part of your membership in
> IDUG. DB2-L list archives, the FAQ, and delivery preferences
> are at http://www.idug.org/lsidug under the Listserv tab.
> While at the site, you can also access the IDUG Online
> Learning Center, Tech Library and Code Place, see the latest
> IDUG conference information, and much more. If you have not
> yet signed up for Basic Membership in IDUG, available at no
> cost, click on Member Services at http://www.idug.org/lsms
>
> The IDUG DB2-L Listserv is only part of your membership in
> IDUG. DB2-L list archives, the FAQ, and delivery preferences
> are at http://www.idug.org/lsidug under the Listserv tab.
> While at the site, you can also access the IDUG Online
> Learning Center, Tech Library and Code Place, see the latest
> IDUG conference information, and much more. If you have not
> yet signed up for Basic Membership in IDUG, available at no
> cost, click on Member Services at http://www.idug.org/lsms
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms