RE: On the behalf of another hapless soul, v.5.10 issue

Just to make sure, up MAX TRAN and MAX USER to 600. Restart online. I think you need to config the OS to handle more tcp/ip connections. DO not know how to do in SCO 3, but on SCO 5 use scoadmin, unixware search deja for article I wrote 2 year ago. Every OS is deferent. -----Original Message----- From: Impy [mailto:wlinden@stritch.edu.spam@me.not] Sent: Friday, August 18, 2000 5:40 PM To: informix-list@iiug.org Subject: On the behalf of another hapless soul, v.5.10 issue Informix 5.10.UC1 and Sco Unix Unix 3.2. Under the Informix command "tbstat -u", a maximum of 300 active sessions allowed. At month-end, 220+ active sessions at is reached any given time. The problem is that once we reach 220 or more sessions, we start receiving tcp/ip connection errors, example as follows "Unable to connect to Elite TCP server" most likely cause: service (eiselbs) at port address 8007 is not running onhost (elite1) at IP address 204.120.117.23", sometimes followed by the error message "TCP/Sockets error during function connect () Error: WSAECONNREFUSED (10061) Connection refused" Most users receiving these errors cannot reestablish connection to the server until we reboot Informix. The OLTP application (Elite) employs the winsock tcp/ip protocol. We tell users to limit their access, but still run into this problem every other month. Any suggestions/feedback would be greatly appreciated. Version 5.10.UC1 #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: tbconfig.std # Sccsid: %W% %G% %U% # Description: INFORMIX-OnLine Configuration Parameters # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /dev/rootdbs # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 1000000 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing root dbspacemirror MIRROROFFSET 0 # Offset into mirror device (Kbytes) # Physical Log Configuration PHYSDBS rootdbs # Name of dbspace that contains physical log PHYSFILE 20000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 23 # Number of logical log files LOGSIZE 10000 # Size of each logical log file (Kbytes) # Message Files MSGPATH /elite/work/logs/online.log # OnLine message log pathname CONSOLE /dev/tty01 # System console message pathname # Archive Tape Device #TAPEDEV /dev/null # Archive tape device pathname TAPEDEV /dev/rStp1 # Archive tape device pathname TAPEBLK 20 # Archive tape block size (Kbytes) TAPESIZE 11700000 # Max amount of data to put on tape (Kbytes) # Logical Log Backup Tape Device LTAPEDEV /dev/rStp0 # Logical log tape device pathname LTAPEBLK 20 # Logical log tape block size (Kbytes) LTAPESIZE 11700000 # Max amount of data to put on log tape (Kbytes) # Identification Parameters SERVERNUM 1 # Unique id associated with this OnLineinstance DBSERVERNAME ONLINE_LIVE # Unique name of this OnLine instance # Shared Memory Parameters RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)USERS 300 # Maximum number of concurrent user processes TRANSACTIONS 300 # Maximum number of concurrent transactions LOCKS 190000 # Maximum number of locks#BUFFERS 64000 # Maximum number of shared memory buffers BUFFERS 100000 # Maximum number of shared memory buffersTBLSPACES 3000 # Maximum number of active tblspaces CHUNKS 50 # Maximum number of chunks DBSPACES 20 # Maximum number of dbspaces and blobspaces PHYSBUFF 32 # Size of physical log buffers (Kbytes) LOGBUFF 32 # Size of logical log buffers (Kbytes)LOGSMAX 40 # Maximum number of logical log files CLEANERS 8 # Number of page-cleaner processes SHMBASE 0x80000000 # Shared memory base address CKPTINTVL 300 # Checkpoint interval (in seconds) LRUS 8 # Number of LRU queues LRU_MAX_DIRTY 10 # LRU modified begin-cleaning limit (percent) LRU_MIN_DIRTY 5 # LRU modified end-cleaning limit (percent) LTXHWM 50 # Long TX high-water mark (percent) LTXEHWM 60 # Long TX exclusive high-water mark (percent) # Machine- and Product-Specific Parameters DYNSHMSZ 0 # Dynamic shared memory size (Kbytes) GTRID_CMP_SZ 32 # Number of bytes to use in GTRID comparision DEADLOCK_TIMEOUT 60 # Max time to wait for lock in distributed env. TXTIMEOUT 300 # Transaction timeout for I-STAR (in seconds)SPINCNT 0 # No. of times process tries for latch STAGEBLOB # Reserved for INFORMIX-OnLine/Optical # System Page Size BUFFSIZE 2048 # Page size (do not change!)