Connections to Database slow - for both shared mem

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

On Thu, Jun 9, 2011 at 08:19, 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. > Look at the networking infrastructure...DNS, NIS (Yellow Pages) or equivalent. Look at the password file and group file - how horrible are they? Also, look at what changed 2-4 days ago. -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --0016e649c74c764dca04a5493953

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

IDS 11.50.FC7IE RHEL 5.6 I have an identical problem. But I know it is caused by no Internet access. My guess is that IDS (or Linux) is looking for my DNS servers, which are provided by my ISP, and can't find them. I stumbled on to this when a customer called with the problem after they lost Internet access. When Internet service was restored, the problem fixed itself. Does anyone know a way to prevent the connection delay when Internet is lost? Or is this a Linux issue? Thanks On 6/9/2011 11:37 AM, Jonathan Leffler wrote: > On Thu, Jun 9, 2011 at 08:19, 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. >> > Look at the networking infrastructure...DNS, NIS (Yellow Pages) or > equivalent. > Look at the password file and group file - how horrible are they? > > Also, look at what changed 2-4 days ago. >

You are correct. On the Linux side, # out all the unpounded lines in /etc/resolv.conf - That will solve the slow connect problem. Remember to un # them or you may not have DNS if and when your Internet problem is fixed! On Fri, Jun 10, 2011 at 3:22 PM, David Zinder <zinder@ztechz.com> wrote: > IDS 11.50.FC7IE > RHEL 5.6 > > I have an identical problem. But I know it is caused by no Internet > access. My guess is that IDS (or Linux) is looking for my DNS servers, > which are provided by my ISP, and can't find them. I stumbled on to this > when a customer called with the problem after they lost Internet access. > When Internet service was restored, the problem fixed itself. Does > anyone know a way to prevent the connection delay when Internet is lost? > Or is this a Linux issue? > > Thanks > > On 6/9/2011 11:37 AM, Jonathan Leffler wrote: > > On Thu, Jun 9, 2011 at 08:19, 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. > >> > > Look at the networking infrastructure...DNS, NIS (Yellow Pages) or > > equivalent. > > Look at the password file and group file - how horrible are they? > > > > Also, look at what changed 2-4 days ago. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec54863b4dc87a404a562edee

Basically loosing DNS resolution is an ISP problem in your case, then a resulting Linux/Client (don´t know what kind of clients you run) problem, and at last a problem of IDS. Best solution: setup two DNS servers (together with a DHCP Server?) inside your clients network and use the ISP DNS only as a forwarder DNS. Worse solution would be the managment of a /etc/hosts file with the IP/name entries on each client/server, but this won´t work out in long time management. DNS is usually a job a IDS machine can handle at the side or just take some cheap linux box to handle it or some Windows Server that happen to stand around your clients side (only guesses, you know their network better to choose the right box) Jörg Volz --------------------------------------------- -----Ursprüngliche Nachricht----- Von: ids-bounces@iiug.org im Auftrag von David Zinder Gesendet: Fr 10.06.2011 21:30 An: ids@iiug.org Betreff: Re: Connections to Database slow - for both sh.... [23979] IDS 11.50.FC7IE RHEL 5.6 I have an identical problem. But I know it is caused by no Internet access. My guess is that IDS (or Linux) is looking for my DNS servers, which are provided by my ISP, and can't find them. I stumbled on to this when a customer called with the problem after they lost Internet access. When Internet service was restored, the problem fixed itself. Does anyone know a way to prevent the connection delay when Internet is lost? Or is this a Linux issue? Thanks On 6/9/2011 11:37 AM, Jonathan Leffler wrote: > On Thu, Jun 9, 2011 at 08:19, 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. >> > Look at the networking infrastructure...DNS, NIS (Yellow Pages) or > equivalent. > Look at the password file and group file - how horrible are they? > > Also, look at what changed 2-4 days ago. > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. IT Handel und Beratung Jörg Volz Bernhard-Früh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de

REPLY 1 - ONCONFIG FILE: cat onconfig.prod #************************************************************************** # # Licensed Material - Property Of IBM # # "Restricted Materials of IBM" # # IBM Informix Dynamic Server # (c) Copyright IBM Corporation 1996, 2006 All rights reserved. # # Title: onconfig.std # Description: IBM Informix Dynamic Server Configuration Parameters # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH ./rootdbs # Path for device containing root dbspace ROOTOFFSET 16 # Offset of root dbspace into device (Kbytes) ROOTSIZE 4096000 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration #PHYSDBS physdbs # Location (dbspace) of physical log PHYSDBS rootdbs # Location (dbspace) of physical log PHYSFILE 100000 # Physical log file size (Kbytes) # Logical Log Configuration #LOGFILES 40 # Number of logical log files #LOGSIZE 50000 # Logical log size (Kbytes) LOGFILES 71 # Number of logical log files LOGSIZE 500 # Logical log size (Kbytes) # Tablespace Tablespace Configuration in Root Dbspace TBLTBLFIRST 0 # First extent size (Kbytes) (0 = default) TBLTBLNEXT 0 # Next extent size (Kbytes) (0 = default) UNSECURE_ONSTAT 1 # Security # DBCREATE_PERMISSION:# By default any user can create a database. Uncomment DBCREATE_PERMISSON to # limit database creation to a specific user. Add a new DBCREATE_PERMISSION # line for each permitted user. #DBCREATE_PERMISSION informix # DB_LIBRARY_PATH: # When loading a (C or C++) shared object (for a UDR or UDT), IDS checks that # the user-specified path starts with one of the directory prefixes listed in # the comma-separated list of prefixes in DB_LIBRARY_PATH. The string # "$INFORMIXDIR/extend" must be included in DB_LIBRARY_PATH in order for # extensibility and IBM supplied blades to work correctly. # DB_LIBRARY_PATH $INFORMIXDIR/extend # IFX_EXTEND_ROLE: # 0 (or off) => Disable use of EXTEND role to control who can register # external routines. # 1 (or on) => Enable use of EXTEND role to control who can register # external routines. This is the default behaviour. # IFX_EXTEND_ROLE 1 # To control the usage of EXTEND role. # EILSEQ_COMPAT_MODE: # When processing characters, IDS checks if the characters are valid # for the locale and returns error -202 if they are not. This causes # problems in some applications. This parameter preserves the old # behavior and permits these characters. # 0 => Disallow illegal characters. This is the default behavior. # 1 => Allow illegal characters. # EILSEQ_COMPAT_MODE 0 # Diagnostics MSGPATH /usr/informix/online.log # System message log file path CONSOLE /usr/informix/console.log # System console message path # To automatically backup logical logs, edit alarmprogram.sh and set #BACKUPLOGS=Y ALARMPROGRAM /usr/informix/etc/alarmprogram.sh # Alarm program path #ALRM_ALL_EVENTS 0 # Triggers ALARMPROGRAM for any event occur ALRM_ALL_EVENTS 1 # Triggers ALARMPROGRAM for any event occur #####KEEP STATS ############# TBLSPACE_STATS 1 # Maintain tblspace statistics #Q stats QSTATS 1#Wait stat enabled WSTATS 1 #SQL statement cache params #STMT_CACHE 2 #STMT_CACHE_SIZE 8192 #STMT_CACHE_HITS 2 #STMT_CACHE_NOLIMIT 0 #STMT_CACHE_NUMPOOL 5 # System Archive Tape Device #TAPEDEV /backup/informix.bck # Tape device path #TAPEDEV DBMIData # Tape device path TAPEDEV /dev/null/ # Tape device path TAPEBLK 32 # Tape block size (Kbytes) TAPESIZE 204800000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /stage/llogs/llog #LTAPEDEV DBMIData #LTAPEDEV /dev/null LTAPEBLK 32 # Log tape block size (Kbytes) LTAPESIZE 20480000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server staging area # System Configuration SERVERNUM 0 # Unique id corresponding to a OnLine instance DBSERVERNAME eppix # Name of default database server DBSERVERALIASES eppix15 # List of alternate dbservernames NETTYPE ipcshm,2,300,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,5,300,NET # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 100 # Max time to wait of lock in distributed env. RESIDENT 1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one # Shared Memory Parameters LOCKS 250000 # Maximum number of locks# NUMAIOVPS 1 # Number of IO vps PHYSBUFF 10000 # Physical log buffer size (Kbytes) LOGBUFF 512 # Logical log buffer size (Kbytes) CLEANERS 128 # Number of buffer cleaner processes SHMBASE 0x700000010000000 # Shared memory base address SHMVIRTSIZE 8388608 # initial virtual shared memory segment size SHMADD 512000 # Size of new shared memory segments (Kbytes) EXTSHMADD 8192 # Size of new extension shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited SHMVIRT_ALLOCSEG 0.000000 # Values between 0 and .99 are %, values > 1 are # KB - when this much virtual memory is used we # try to get a new segment. 0 means "off". 2nd # parameter is alarm level CKPTINTVL 300 # Check point interval (in sec) TXTIMEOUT 300 # Transaction timeout (in sec) STACKSIZE 64 # Stack size (Kbytes) # Dynamic Logging # DYNAMIC_LOGS: # 2 : server automatically add a new logical log when necessary. (ON) # 1 : notify DBA to add new logical logs when necessary. (ON) # 0 : cannot add logical log on the fly. (OFF) # # When dynamic logging is on, we can have higher values for LTXHWM/LTXEHWM, # because the server can add new logical logs during long transaction rollback. # However, to limit the number of new logical logs being added, LTXHWM/LTXEHWM # can be set to smaller values. # # If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values # to avoid long transaction rollback hanging the server due to lack of logical # log space, i.e. 50/60 or lower. # # In case of system configured with CDR, the difference between LTXHWM and # LTXEHWM should be atleast 30% so that we could minimize log overrun issue. DYNAMIC_LOGS 2 LTXHWM 70 LTXEHWM 80 # System Page Size # BUFFSIZE - OnLine no longer supports this configuration parameter. # To determine the page size used by OnLine on your platform # see the last line of output from the command, 'onstat -b'. # Recovery Variables # OFF_RECVRY_THREADS: # Number of parallel worker threads during fast recovery or an offline restore. # ON_RECVRY_THREADS: # Number of parallel worker threads during an online restore. OFF_RECVRY_THREADS 10 # Default number of offline worker threads ON_RECVRY_THREADS 10 # Default number of online worker

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

One thing I am trying now, is to replace the hostnames with IP addresses. Not sure if you can try the same thing (to bypass name resolving / DNS) Dirk > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > David Zinder > Sent: Friday, 10 June 2011 09:23 PM > To: ids@iiug.org > Subject: Re: Connections to Database slow - for both sh.... [23979] > > IDS 11.50.FC7IE > RHEL 5.6 > > I have an identical problem. But I know it is caused by no Internet > access. My guess is that IDS (or Linux) is looking for my DNS servers, > which are provided by my ISP, and can't find them. I stumbled on to > this > when a customer called with the problem after they lost Internet > access. > When Internet service was restored, the problem fixed itself. Does > anyone know a way to prevent the connection delay when Internet is > lost? > Or is this a Linux issue? > > Thanks > > On 6/9/2011 11:37 AM, Jonathan Leffler wrote: > > On Thu, Jun 9, 2011 at 08:19, 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. > >> > > Look at the networking infrastructure...DNS, NIS (Yellow Pages) or > > equivalent. > > Look at the password file and group file - how horrible are they? > > > > Also, look at what changed 2-4 days ago. > > > > > *********************************************************************** > ******** > 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

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