By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,458 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

how to set idle time out

P: n/a
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

Sep 27 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Ian
jo******@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?

Sep 27 '06 #2

P: n/a

Ian wrote:
jo******@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

Sep 27 '06 #3

P: n/a
jo******@canada.com wrote:
>
Ian wrote:
>jo******@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
Sep 28 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.