IDS Forum

Re: network errors

Posted By: Art Kagel
Date: Monday, 13 December 2010, at 6:07 p.m.

In Response To: RE: network errors (Kennedy, Randy)

I don't suppose you have extended support for that 9.40 server? It may be
time to call IBM.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.

On Mon, Dec 13, 2010 at 5:46 PM, Kennedy, Randy
<RKennedy@scottsdaleaz.gov>wrote:

> Unfortunately, already did that and it didn't help. Errors started
> occurring again about 6 minutes after DB back online, at which time
> there only about 30 connections.
>
> Thanks,
> Randy
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Art Kagel
> Sent: Monday, December 13, 2010 2:45 PM
> To: ids@iiug.org
> Subject: Re: network errors [22211]
>
> Hmm. Does not sound like there should be a problem. Nasty the way
> reality
> differs from expectation sometimes. I can only suggest bouncing the
> instance and see if that helps.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> IIUG Board of Directors (art@iiug.org)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> other
> organization with which I am associated either explicitly, implicitly,
> or by
> inference. Neither do those opinions reflect those of other individuals
> affiliated with any entity with which I am affiliated nor those of the
> entities themselves.
>
> On Mon, Dec 13, 2010 at 4:24 PM, Kennedy, Randy
> <RKennedy@scottsdaleaz.gov>wrote:
>
> > We only have 1 port and the highest maximum connections count from the
>
> > log is 268 earlier this year and has been consistently between 210-250
>
> > for the past couple of years.
> >
> > Our onconfig is set as:
> > NETTYPE soctcp,4,150,NET
> > NETTYPE ipcshm,1,25,NET
> >
> > Thanks,
> > Randy
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > Art Kagel
> > Sent: Monday, December 13, 2010 2:07 PM
> > To: ids@iiug.org
> > Subject: Re: network errors [22209]
> >
> > On HP/UX errno 232 is "Connection reset by peer" and 233 id "No buffer
>
> > space
> > available". The latter, more common error, sounds like the network
> > drivers
> > are being saturated. How many active concurrent connections do you
> have
> > at
> > the times when this is happening? A single poll threadr can handle up
> to
> >
> > about 1000 connections, however, IBM recommends configuring so that a
> > thread
> > handles no more than about 350 connections. One solution may be to
> > increase
> > the number of poll threads, however, it if is new connections that are
>
> > the
> > problem, then you probably should configure one or two additional
> ports
> > (each with its own DBSERVERALIAS) so that there will be multiple
> > listener
> > threads listening for new connections and set things up so that the
> > users
> > are balanced across the two or three ports. You will have to bounce
> the
> > server to implement this solution.
> >
> > BTW, in IDS 11.70 you can increase the number of listener threads on a
>
> > single port in the ONCONFIG file or dynamically making configuring and
>
> > resolving problems like this easier. IDS 11.70 also has additional
> > features
> > to reduce the overhead of connecting to the server which reduced the
> > load so
> > these problems are less common.
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.com)
> > IIUG Board of Directors (art@iiug.org)
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own
> opinions
> > and
> > do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> > other
> > organization with which I am associated either explicitly, implicitly,
>
> > or by
> > inference. Neither do those opinions reflect those of other
> individuals
> > affiliated with any entity with which I am affiliated nor those of the
>
> > entities themselves.
> >
> > On Mon, Dec 13, 2010 at 3:44 PM, Kennedy, Randy
> > <RKennedy@scottsdaleaz.gov>wrote:
> >
> > > OS: HP/UX 11.11 IDS: 9.4FC3 (we are in the process of upgrading,
> > > but new server/db not ready for production yet)
> > >
> > > We started seeing these errors in our log Friday when users
> complained
> >
> > > of not being able to connect. We checked back over time and there
> have
> >
> > > been a few here and there, but Friday we had 50+ and today we have
> > 100+
> > > and counting and are users are having a difficult time
> > connecting/using
> > > the system.
> > >
> > > The majority are:
> > > listener-thread: err = -25573: oserr = 233: errstr = : Network
> driver
> > > cannot accept a connection on the port.
> > >
> > > but we also see a few:
> > > listener-thread: err = -25580: oserr = 232: errstr = : System error
> > > occurred in network function.
> > >
> > > Nothing has changed on the server recently and network folks are
> > telling
> > > us that nothing has changed with them.
> > > Any ideas on what/where to look for/check/change to stop these
> errors?
> >
> > >
> > > TIA,
> > > Randy
> > >
> > >
> > >
> > >
> >
> ************************************************************************
>
> > *******
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --000e0cd25deeba53080497511690
> >
> >
> ************************************************************************
>
> > *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
> ************************************************************************
> *******
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001636c5b15beb21060497519c7d
>
> ************************************************************************
> *******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--20cf30433f00813d8a049752c488

Messages In This Thread

• network errors
  Kennedy, Randy -- Monday, 13 December 2010, at 3:44 p.m.
  • Re: network errors
    Art Kagel -- Monday, 13 December 2010, at 4:07 p.m.
    • RE: network errors
      Kennedy, Randy -- Monday, 13 December 2010, at 4:24 p.m.
      • Re: network errors
        Art Kagel -- Monday, 13 December 2010, at 4:44 p.m.
        • RE: network errors
          Kennedy, Randy -- Monday, 13 December 2010, at 5:46 p.m.
          • Re: network errors
            Art Kagel -- Monday, 13 December 2010, at 6:07 p.m.
            • RE: network errors
              Kennedy, Randy -- Monday, 13 December 2010, at 6:13 p.m.
              • Re: network errors
                Fernando Nunes -- Monday, 13 December 2010, at 6:41 p.m.
                • RE: network errors
                  Kennedy, Randy -- Monday, 13 December 2010, at 6:44 p.m.
                  • Re: network errors
                    Fernando Nunes -- Tuesday, 14 December 2010, at 4:47 p.m.
                    • RE: network errors
                      Kennedy, Randy -- Tuesday, 14 December 2010, at 5:24 p.m.
                      • Re: network errors
                        Fernando Nunes -- Tuesday, 14 December 2010, at 5:49 p.m.
              • Re: RE: network errors
                KARL OLIVER -- Tuesday, 14 December 2010, at 2:20 p.m.
                • RE: RE: network errors
                  Kennedy, Randy -- Friday, 17 December 2010, at 2:42 p.m.
                  • Re: RE: network errors
                    Fernando Nunes -- Friday, 17 December 2010, at 4:57 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.