IDS Forum

Re: Connections to Database slow - for both sh....

Posted By: Art Kagel
Date: Saturday, 11 June 2011, at 9:40 p.m.

In Response To: RE: Connections to Database slow - for both sh.... (Dirk Cornelis Moolman [ MTN - Innovation Centre ])

An onstat -g glo from a server that's only been online for 34minutes isn't
particularly useful. Your ONCONFIG looks OK, I would increase the shm poll
threads from 2 to 5, but as you say, TCP connections are slower than shm
connections, so that's not a major thing. Perhaps it is a DNS problem.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
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 Sat, Jun 11, 2011 at 6:55 AM, Dirk Cornel.... <moolma_dc@mtn.co.za>wrote:

> REPLY 2 - ONSTAT -G GLO:
>
> onstat -g glo
>
> IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up 00:34:07 --
> 11581120 Kbytes
>
> MT global info:
> sessions threads vps lngspins
> 0 153 16 0
>
> sched calls thread switches yield 0 yield n yield forever
> total: 5702000 382647 5366115 270938 761
> per sec: 373 349 24 331 0
>
> Virtual processor summary:
> class vps usercpu syscpu total
> cpu 5 4.22 4.42 8.64
> aio 2 0.00 0.01 0.01
> lio 1 0.00 0.00 0.00
> pio 1 0.00 0.00 0.00
> adm 1 0.18 0.06 0.24
> soc 5 0.09 0.17 0.26
> msc 1 0.01 0.00 0.01
> total 16 4.50 4.66 9.16
>
> Individual virtual processors:
> vp pid class usercpu syscpu total
> 1 3092632 cpu 1.06 4.37 5.43
> 2 307222 adm 0.18 0.06 0.24
> 3 3309688 cpu 0.40 0.02 0.42
> 4 1163344 cpu 0.31 0.01 0.32
> 5 2842696 cpu 0.21 0.01 0.22
> 6 921800 cpu 2.24 0.01 2.25
> 7 3645608 lio 0.00 0.00 0.00
> 8 790618 pio 0.00 0.00 0.00
> 9 1011786 aio 0.00 0.01 0.01
> 10 1323262 msc 0.01 0.00 0.01
> 11 1286394 aio 0.00 0.00 0.00
> 12 2941172 soc 0.05 0.09 0.14
> 13 3747924 soc 0.04 0.07 0.11
> 14 2719910 soc 0.00 0.00 0.00
> 15 3342466 soc 0.00 0.01 0.01
> 16 2994362 soc 0.00 0.00 0.00
>
> tot 4.50 4.66 9.16
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> > Art Kagel
> > Sent: Friday, 10 June 2011 04:48 PM
> > To: ids@iiug.org
> > Subject: Re: Connections to Database slow - for both sh.... [23975]
> >
> > Post your ONCONFIG file and the output from:
> >
> > onstat -g glo
> >
> > and we'll take a look and tell you if we spot something.
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.com)
> > 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 Thu, Jun 9, 2011 at 11:19 AM, Dirk Cornel....
> > <moolma_dc@mtn.co.za>wrote:
> >
> > > AIX version 5
> > > IDS version 10
> > >
> > > We suddenly have a problem on one of our servers, where the
> > connections
> > > suddenly slowed down in the last 2 days. Once we start up our
> > application
> > > (written in 4GL), locally on the server, the connections start
> > slowing
> > > down.
> > > It takes about 30 seconds to connect to the database using dbaccess.
> > And
> > > this
> > > happens for both tcp and shm, although the tcp connections seem to be
> > > worse.
> > >
> > > Any tips on what I can look for ?
> > >
> > > The server has 86% idle time, the memory is not fully used, I/O is
> > fine.
> > >
> > > Also, we are not running close to the number of connections allowed
> > to the
> > > database. We allow 1500 tcp connections, and only run about 100 tcp
> > > connections.
> > >
> > > Dirk
> > >
> > > ________________________________
> > > NOTE: This e-mail message is subject to the MTN Group disclaimer see
> > > http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
> > >
> > >
> > >
> > >
> > ***********************************************************************
> > ********
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --bcaec5014b95087ca404a55ca9bd
> >
> >
> > ***********************************************************************
> > ********
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
> NOTE: This e-mail message is subject to the MTN Group disclaimer see
> http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisclaimer.aspx
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--20cf3071d0886d977604a579e343

Messages In This Thread

• Connections to Database slow - for both shared mem
  Dirk Cornelis Moolman [ MTN - Innovation Centre ] -- Thursday, 9 June 2011, at 11:19 a.m.
  • Re: Connections to Database slow - for both shared
    Jonathan Leffler -- Thursday, 9 June 2011, at 11:37 a.m.
    • Re: Connections to Database slow - for both sh....
      David Zinder -- Friday, 10 June 2011, at 3:22 p.m.
      • Re: Connections to Database slow - for both sh....
        John Fahey -- Friday, 10 June 2011, at 6:24 p.m.
      • AW: Connections to Database slow - for both sh....
        Joerg Volz -- Friday, 10 June 2011, at 6:29 p.m.
      • RE: Connections to Database slow - for both sh....
        Dirk Cornelis Moolman [ MTN - Innovation Centre ] -- Saturday, 11 June 2011, at 6:55 a.m.
        • Re: Connections to Database slow - for both sh....
          David Zinder -- Monday, 13 June 2011, at 12:08 p.m.
      • Re: Connections to Database slow - for both sh....
        Fernando Nunes -- Monday, 13 June 2011, at 11:57 a.m.
        • RE: Connections to Database slow - for both sh....
          Dirk Cornelis Moolman [ MTN - Innovation Centre ] -- Monday, 13 June 2011, at 12:45 p.m.
  • Re: Connections to Database slow - for both shared
    Art Kagel -- Friday, 10 June 2011, at 10:48 a.m.
    • RE: Connections to Database slow - for both sh....
      Dirk Cornelis Moolman [ MTN - Innovation Centre ] -- Saturday, 11 June 2011, at 6:53 a.m.
    • RE: Connections to Database slow - for both sh....
      Dirk Cornelis Moolman [ MTN - Innovation Centre ] -- Saturday, 11 June 2011, at 6:55 a.m.
      • Re: Connections to Database slow - for both sh....
        Art Kagel -- Saturday, 11 June 2011, at 9:40 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.