+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 11 to 19 of 19

how to set idle time out

  1. 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


  2. 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


  3. 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


  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2