RE: Slow Connection - HP 11 9.30

Brian, Did something get garbled in your post? Your ONCONFIG shows: NETTYPE # Configure poll thread(s) for nettype If you don't have NETTYPE set, maybe that's the problem. I don't know what the default is for NETTYPE, you could probably find that in the online docs or someone out here would know. I do know in general this is related to how many connections the DB can take. My NETTYPE settings are : NETTYPE ipcshm,8,89,NET NETTYPE tlitcp,9,100,CPUWhich, if my rusty knowledge is accurate means I have 8 poll threads for shared memory connections, each of the 8 poll threads can handle 89 connections. My network connection (tlitcp) has 9 dedicated poll threads, each capable of handling 100 connections. If your NETTYPE is not set, maybe you are hitting a default NETTYPE limit. Like I said, my info might be a bit rusty, but NETTYPE looks guilty. Norma Jean Sebastian ERP Support Administration GIS- Enterprise Technical Services -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of brian.fink@xerium.com Sent: Wednesday, November 22, 2006 3:05 PM To: informix-list@iiug.org Subject: Slow Connection - HP 11 9.30 Hey everyone. We're having a problem with slow connections to a 9.3 database I recently inherited. The system is basically an OLTP but they have quite a few reports that are run during the day. I think that this may be a system problem but I wanted to run the numbers by some experts to make sure I haven't missed anything. All suggestions appreciated and have a great holiday! This is the main error we get in the log: 15:39:38 listener-thread: err = -25573: oserr = 233: errstr = :Network driver cannot accept a connection on the port. System error = 233. I know that this has been discussed before. We're looking at network and server resources also. I changed the LRU's and cleaners and restarted recently: Here are the gory details. HPUX 11 2 CPUs 2 gs memory is what I was told. #*********************************************************************** *** # # INFORMIX SOFTWARE, INC. # # Title: onconfig.std # Description: Informix Dynamic Server Configuration Parameters # #*********************************************************************** *** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTNAME rootdbs # Root dbspace name ROOTPATH /opt/informix/dbspaces/root_dbs # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 204800 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirroredroot MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS rootdbs # Location (dbspace) of physical log PHYSFILE 5000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 22 # Number of logical log files LOGSIZE 5000 # Logical log size (Kbytes) # Diagnostics MSGPATH /opt/informix/online.log # System message log file path MSGPATH /opt/informix/online.log # System message log file path CONSOLE /dev/console # System console message path ALARMPROGRAM /opt/informix/9.30.FC3/etc/log_full.sh # Alarm programpath TBLSPACE_STATS 1 # Maintain tblspace statistics # System Archive Tape Device TAPEDEV /dev/rmt/0m # Tape device path#TAPEDEV /dev/null # Tape device path TAPEBLK 128 # Tape block size (Kbytes) TAPESIZE 20480000 #Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device #LTAPEDEV /dev/null # Log tape device path LTAPEDEV /dev/rmt/0m # Log tape device path LTAPEBLK 128 # 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 # System Configuration SERVERNUM 0 # Unique id corresponding to a OnLineinstance DBSERVERNAME hponline # Name of default database server DBSERVERALIASES # List of alternate dbservernames NETTYPE # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock indistributed env. RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor NUMCPUVPS 1 # Number of user (cpu) vps SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vpsto one NOAGE 0 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters LOCKS 50000 # Maximum number of locks BUFFERS 46000 # Maximum number of shared buffers NUMAIOVPS # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes)# CLEANERS 8 # Number of buffer cleaner processes 11/20/06 CLEANERS 128 # Number of buffer cleaner processes# CLEANERS 8 # Number of buffer cleaner processes 11/20/06 CLEANERS 128 # Number of buffer cleaner processes SHMBASE 0x0 #Shared memory base address SHMVIRTSIZE 200000 # initial virtual shared memory segmentsize SHMADD 50000 # Size of new shared memory segments (Kbytes) SHMTOTAL 600000 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 300 # Check point interval (in sec)#LRUS 8 # Number of LRU queues 11/20/06 LRUS 128 # Number of LRU queues LRU_MAX_DIRTY 10 # LRU percent dirty begin cleaninglimit LRU_MIN_DIRTY 5 # LRU percent dirty end cleaning limit TXTIMEOUT 300 # Transaction timeout (in sec) STACKSIZE 64 Informix Dynamic Server Version 9.30.FC3 -- On-Line -- Up 1 days 20:16:50 -- 308592 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 1294140 6836433 152399487 99.15 22392 94158 1395872 98.40 isamtot open start read write rewrite delete commit rollbk 83961342 2227124 8915191 48431212 138805 11244 355 2243 0 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs@@NL@