how to set idle time out

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

john_woo@canada.com - 27 Sep 2006 18:58 GMT

Hi,

I installed DB2 in linux, the tool I can use is db2gov.

I'm wondering, how to set the idle time out, so all java app never time
out?

It's very simple in Mysql, in console, just set wait_time_out=0

--
Thanks
John
Toronto

Reply to this Message

Ian - 27 Sep 2006 20:50 GMT

> Hi,
>
[quoted text clipped - 9 lines]
> John
> Toronto

Not sure I follow what you're trying to do. DB2 doesn't force
connections off of the database after some idle time, unless you've
configured the governor to do so.

So, are you asking how to configure the governor to force all
applications *except for Java apps* after some time?

Reply to this Message

john_woo@canada.com - 27 Sep 2006 22:38 GMT

> > Hi,
> >
[quoted text clipped - 16 lines]
> So, are you asking how to configure the governor to force all
> applications *except for Java apps* after some time?

Thanks for your replying.

The problem was that, our java app (a server) keeps connecting with
db2, but after 10 hours, the app showed error :

T4Agent.sendRequest() db2connectioncorrelator AC1E1049.J10...

This shows connection dropped.

so we wonder how to set connection, so that once connected, keepalive
forever.

Thanks
John

Reply to this Message

Knut Stolze - 28 Sep 2006 07:35 GMT

>> > Hi,
>> >
[quoted text clipped - 23 lines]
> so we wonder how to set connection, so that once connected, keepalive
> forever.

As Ian said, DB2 doesn't disconnect. So it has to be something on your/the
application's side.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message