Re: the opposite of DCD (dead connection detection)??

On Jan 10, 10:59 am, Ben <benal..._at_yahoo.com> wrote:
> On Jan 9, 11:14 am, bdbafh <bdb..._at_gmail.com> wrote:
>
>
>
>
>
> > On Jan 9, 10:52 am, Ben <benal..._at_yahoo.com> wrote:
>
> > > 10.2.0.2 AIX 5.2 64bit.
>
> > > Idle connections are getting terminated in databases on one of our
> > > servers. I've checked profiles and resource plans to see if any have a
> > > limit on idle time and there are none. It was first noticed in an
> > > application and I've since been testing scenarios using sqlplus and it
> > > happens with sqlplus also. I also thought it was limited to
> > > connections that were coming in from another server but that isn't the
> > > case either.
>
> > > Certain things that stand out. It doesn't happen if the connection is
> > > for the sysdba user. It doesn't happen if the connection is a local
> > > connection that doesn't have the @sid in the connection string.
>
> > > Any thoughts?
>
> > Is there a host-based firewall in use (meaning on the localhost)?
>
> > Can you test out this for connection on the same subnet (that would
> > not traverse a router) vs. connections from clients not on the same
> > subnet?
>
> > This sure smells like a network issue where (translated) connections
> > are being timed out.
>
> > Start working with the network techs to see if they have any ideas.
>
> > -bdbafh
>
> Just another little piece of info. I setup a cronjob to see how long
> the connections stay connected when they are idle, looks like
> approximately 12 hours

That sounds like a TCP setting. See http://www.tek-tips.com/viewthread.cfm?qid=1407908&page=12

Found by googling on:
tcp port timeout aix

I think he was looking at the wrong setting in that post, but I'm not on AIX so can't comment further. But I believe there are more settings, including some that timeout the port after a longer time than seconds. Might have time or wait in the name.

This one seems to be saying I'm wrong:
http://unix.derkeiler.com/Newsgroups/comp.unix.aix/2006-12/msg00359.html

Maybe there's some resource limit on the AIX side... like the ulimit cpu seconds?

jg

--
@home.com is bogus.
"A slipping gear could let your M203 grenade launcher fire when
you least expect it. That would make you quite unpopular in
what's left of  your unit." - Army's magazine of preventive
maintenance.