Prev: Instance Crash
Next: Just Upgraded - Problems...
From: john_woo on 27 Sep 2006 13:58
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

From: Ian on 27 Sep 2006 15:50
john_woo(a)canada.com wrote:
> 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
>

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?



From: john_woo on 27 Sep 2006 17:38

Ian wrote:
> john_woo(a)canada.com wrote:
> > 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
> >
>
> 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?

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

From: Knut Stolze on 28 Sep 2006 02:35
john_woo(a)canada.com wrote:

>
> Ian wrote:
>> john_woo(a)canada.com wrote:
>> > 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
>>
>> 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?
>
> 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.

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

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
 | 
Pages: 1
Prev: Instance Crash
Next: Just Upgraded - Problems...