SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 08:19 AM
| |||
| |||
 Re: how to set idle time out john_woo@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?      |
|
02-27-2008, 08:19 AM
| |||
| |||
| Re: how to set idle time out Ian wrote: > john_woo@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 |
|
02-27-2008, 08:19 AM
| ||||
| ||||
| Re: how to set idle time out john_woo@canada.com wrote: > > Ian wrote: >> john_woo@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 |
Linear Mode
