IDS 7.3UC2 on SCO Unixware Version 7.01 Hangs everyday

Anybody had this experience pls comment. We encountered system hangs one day 3 times. According to Informix SUpport it was :- 1) Port 801 should not he the port must be greated than 1024. ( I agree but have checked the /etc/services file and find no processes using port 801 ) 2) SCO SFNOLIMIT should be 128 not 65. ( I Changed it now it only hangs one per day ). I am thinking to moving to 7.3UC10. Anybody can offer any inputs. Thanks and Regards Francis francis@jnesw.com.sg

I personnally use IDS 7.30.UC2 on Unixware 7.01 and have no problems. It's up since weeks or months I don't remember. I use port number1789 Regards Francis Teo Ee Cheok a écrit: > Anybody had this experience pls comment. > We encountered system hangs one day 3 times. > According to Informix SUpport it was :- > 1) Port 801 should not he the port must be greated than 1024. > ( I agree but have checked the /etc/services file and find > no processes using port 801 ) > 2) SCO SFNOLIMIT should be 128 not 65. > ( I Changed it now it only hangs one per day ). > > I am thinking to moving to 7.3UC10. > > Anybody can offer any inputs. > > Thanks and Regards > Francis > francis@jnesw.com.sg

We have several sites on UXW 7.0.1 and IDS 7.30.UC2. I would be very interested in knowing more information on both of your ONCONFIG settings and Unixware 7.0.1 patch levels. Specifically, NETTYPE, NUMCPUVPS and typical number of users connected to the database. We had 2 sites running with no problems (150 and 200 users), a third site went live in September and gets an Assert Failure every 5 to 21 days. It has more users and volume, but runs the same application. No luck from Informix Tech Support. We have tuned a lot of parameters, but with no success. Most suggestions have come from us and not Informix. We have just experience the same assert failure at one of the first sites (once in 9 months), so this helps rule out some of the OS and Hardware questions we had in the back of our minds. A fourth site went live late November and is experiencing sporatic system hangs. UXW is up and running, but performance on existing IDS connections degrades and no new connections are allowed. Onstat commands are available, but cannot execute onmode, etc. My next course of action is to apply 7.30.UC10 (recently available on UXW 7.0.1), keep pushing Informix Tech Support and continue to try to isolate the cause myself. Any other suggestions??? Thanks, Allan Wilson allan.wilson@versaterm.com online.log 10:45:00 Who: Session(32804, someone@whatever, 11205, 0) Thread(36117, sqlexec, 0, 3) File: mtex.c Line: 314 10:45:00 Results: Exception Caught. Type: MT_EX_OS, Context: mem stack #Stack Trace for p1, Program rpt_view.er #*[0] _syscall(0x2, 0x636, 0xbff4170c, 0x1, 0xbff42e08) [0xbffc92df] # [1] _semop(0x636, 0xbff4170c, 0x1) [0xbffe2c21] # [2] buf_wait(0x81b4be8, 0, 0) [0xbff34483] # [3] recvshm(0x81bb718, 0x81bb568, 0x81b59ec) [0xbff33a63] # [4] tlRecv(0x81b59ec, 0x81bb568) [0xbff2d649] # [5] slSQIrecv(presumed: 0x81b59ec, 0x8036f38, 0x8036fa4) [0xbff2b38c] # [6] pfRecv(0x81b59ec, 0x8036fc4) [0xbff25e26] # [7] asfRecv(0x81b59ec, 0x81b581c, 0x8036fc0) [0xbff1533d] # [8] ASF_Call(0x81b5660, 0x8036fc0) [0xbff17368] # [9] asf_recv(0x81b5640) [0xbfeb683d] # [10] _iread(presumed: 0x803706e, 0x2, 0x81b5640) [0xbfeb6904] # [11] _igetint(presumed: 0x81b5640, 0x819a658, 0xbff84054) [0xbfeb54cb] # [12] _sqr_messages(0x81d749c, 0, 0x819a658) [0xbff64ac3] # [13] _sqexecute(presumed: 0x81d749c, 0x81b9490, 0) [0xbff58c1b] # [14] sqli_exec(presumed: 0x1, 0x81d749c, 0x81b9490) [0xbff587e7] # [15] ?(0x80c9436, 0x81b9490, 0) [0x80a5c50] # [16] ?() [0x80a33c3] Note: Looking at the stack, we have focused our search primarily on Informix BUFFERS (and other related settings) and Unixware semaphore/ shared memory settings (and UXW patches). #************************************************************************** # # Informix Dynamic Server Configuration Parameters # # # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace nameROOTPATH /IFX_DEVICES/raw01 ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 50000 # 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 logspace # Location (dbspace) of physical log PHYSFILE 10000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 56 # Number of logical log files LOGSIZE 4000 # Logical log size (Kbytes) # Diagnostics MSGPATH /usr2/informix/online.log # System message log file path CONSOLE /dev/null # System console message path ALARMPROGRAM /usr2/informix/etc/log_full.sh # Alarm program pathSYSALARMPROGRAM /usr2/informix/etc/evidence.sh # System Alarm program path TBLSPACE_STATS 1 # System Archive Tape Device TAPEDEV /dev/rmt/ntape3 TAPEBLK 16 # Tape block size (Kbytes) TAPESIZE 15000000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/rmt/ntape2 LTAPEBLK 16 # Log tape block size (Kbytes) LTAPESIZE 15000000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server/Optical staging area # System Configuration SERVERNUM 3 # Unique id corresponding to a DynamicServer in stance DBSERVERNAME ifx # Name of default database server DBSERVERALIASES ifxtcp # List of alternate dbservernames DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) NETTYPE ipcshm,1,500,CPU NETTYPE tlitcp,1,200,NET MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor NUMCPUVPS 3 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps toone NOAGE 1 # 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 150000 # Maximum number of shared buffers NUMAIOVPS 14 # Number of IO vps PHYSBUFF 256 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 100 # Maximum number of logical log files CLEANERS 16 # Number of buffer cleaner processes SHMBASE 0xa000000L # Shared memory base address SHMVIRTSIZE 262144 SHMADD 65536 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 600 # Check point interval (in sec) LRUS 64 # Number of LRU queues LRU_MAX_DIRTY 2 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 1 # LRU percent dirty end cleaning limit LTXHWM 40 # Long transaction high water markpercentage LTXEHWM 50 # Long transaction high water mark (exclusive) TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 32 # Stack size (Kbytes) # System Page Size # BUFFSIZE - Dynamic Server no longer supports this configuration parameter. # To determine the page size used by Dynamic Server 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

You're not alone in this case, Allan !:-) I had also experience of Assert Failure with IDS 7.30.UC2 on UW7.0.1/Compaq Raid5 platform. And I had to fix myself when the vendors gave up but that is the Assert Failure with 'bad page' in writting to raw devices. I had to do something tuning and remove VLM to get out this problem but I'm not sure that is the case. I'm curious to know if you have the Assert Failure on which hardware setup? How much physical memory on the server? Recently, I got one Assert Failure that you got below File: mtex.c Line: 314 10:45:00 Results: Exception Caught. Type: MT_EX_OS, Context: mem And can not fix ! And another relay to bad memory allocation....I don't remember exactly the error message. I still waiting the answer from Informix Support. I hoped I won't have to find the problem myself another time :-) H.V "Al Wilson" <allan.wilson@versaterm.com> wrote in message news:86nbr5$9id1@www.informix.com... > We have several sites on UXW 7.0.1 and IDS 7.30.UC2. I would be very > interested in knowing more information on both of your ONCONFIG settings and > Unixware 7.0.1 patch levels. > > Specifically, NETTYPE, NUMCPUVPS and typical number of users connected to > the database. > > We had 2 sites running with no problems (150 and 200 users), a third site > went live in September and gets an Assert Failure every 5 to 21 days. It > has more users and volume, but runs the same application. No luck from > Informix Tech Support. We have tuned a lot of parameters, but with no > success. Most suggestions have come from us and not Informix. > > We have just experience the same assert failure at one of the first sites > (once in 9 months), so this helps rule out some of the OS and Hardware > questions we had in the back of our minds. > > A fourth site went live late November and is experiencing sporatic system > hangs. UXW is up and running, but performance on existing IDS connections > degrades and no new connections are allowed. Onstat commands are available, > but cannot execute onmode, etc. > > My next course of action is to apply 7.30.UC10 (recently available on UXW > 7.0.1), keep pushing Informix Tech Support and continue to try to isolate > the cause myself. > > Any other suggestions??? > Thanks, > > Allan Wilson > allan.wilson@versaterm.com > > online.log > 10:45:00 Who: Session(32804, someone@whatever, 11205, 0) > Thread(36117, sqlexec, 0, 3) > File: mtex.c Line: 314 > 10:45:00 Results: Exception Caught. Type: MT_EX_OS, Context: mem> > stack > #Stack Trace for p1, Program rpt_view.er > #*[0] _syscall(0x2, 0x636, 0xbff4170c, 0x1, 0xbff42e08) [0xbffc92df] > # [1] _semop(0x636, 0xbff4170c, 0x1) [0xbffe2c21] > # [2] buf_wait(0x81b4be8, 0, 0) [0xbff34483] > # [3] recvshm(0x81bb718, 0x81bb568, 0x81b59ec) [0xbff33a63] > # [4] tlRecv(0x81b59ec, 0x81bb568) [0xbff2d649] > # [5] slSQIrecv(presumed: 0x81b59ec, 0x8036f38, 0x8036fa4) [0xbff2b38c] > # [6] pfRecv(0x81b59ec, 0x8036fc4) [0xbff25e26] > # [7] asfRecv(0x81b59ec, 0x81b581c, 0x8036fc0) [0xbff1533d] > # [8] ASF_Call(0x81b5660, 0x8036fc0) [0xbff17368] > # [9] asf_recv(0x81b5640) [0xbfeb683d] > # [10] _iread(presumed: 0x803706e, 0x2, 0x81b5640) [0xbfeb6904] > # [11] _igetint(presumed: 0x81b5640, 0x819a658, 0xbff84054) [0xbfeb54cb] > # [12] _sqr_messages(0x81d749c, 0, 0x819a658) [0xbff64ac3] > # [13] _sqexecute(presumed: 0x81d749c, 0x81b9490, 0) [0xbff58c1b] > # [14] sqli_exec(presumed: 0x1, 0x81d749c, 0x81b9490) [0xbff587e7] > # [15] ?(0x80c9436, 0x81b9490, 0) [0x80a5c50] > # [16] ?() [0x80a33c3] > > > Note: Looking at the stack, we have focused our search primarily on Informix > BUFFERS (and other related settings) and Unixware semaphore/ shared memory > settings (and UXW patches). > > > #************************************************************************** > # > # Informix Dynamic Server Configuration Parameters > # > # > > # Root Dbspace Configuration > > ROOTNAME rootdbs # Root dbspace name> ROOTPATH /IFX_DEVICES/raw01 > ROOTOFFSET 0 # Offset of root dbspace into device > (Kbytes) > ROOTSIZE 50000 # 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 logspace # Location (dbspace) of physical log > PHYSFILE 10000 # Physical log file size (Kbytes)> > # Logical Log Configuration > > LOGFILES 56 # Number of logical log files > LOGSIZE 4000 # Logical log size (Kbytes)> > # Diagnostics > > MSGPATH /usr2/informix/online.log # System message log file path > CONSOLE /dev/null # System console message path > ALARMPROGRAM /usr2/informix/etc/log_full.sh # Alarm program path> SYSALARMPROGRAM /usr2/informix/etc/evidence.sh # System Alarm program path > TBLSPACE_STATS 1> > # System Archive Tape Device > > TAPEDEV /dev/rmt/ntape3 > > TAPEBLK 16 # Tape block size (Kbytes) > TAPESIZE 15000000 # Maximum amount of data to put on tape > (Kbytes)> > # Log Archive Tape Device > > LTAPEDEV /dev/rmt/ntape2 > LTAPEBLK 16 # Log tape block size (Kbytes) > LTAPESIZE 15000000 # Max amount of data to put on log tape > (Kbytes)> > # Optical > > STAGEBLOB # Informix Dynamic Server/Optical staging > area > > # System Configuration > > SERVERNUM 3 # Unique id corresponding to a Dynamic> Server in > stance > DBSERVERNAME ifx # Name of default database server > DBSERVERALIASES ifxtcp # List of alternate dbservernames > DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed > env. > RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) > NETTYPE ipcshm,1,500,CPU > NETTYPE tlitcp,1,200,NET > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for> multi-processor > NUMCPUVPS 3 # Number of user (cpu) vps > SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to> one > > NOAGE 1 # 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 150000 # Maximum number of shared buffers > NUMAIOVPS 14 # Number of IO vps > PHYSBUFF 256 # Physical log buffer size (Kbytes) > LOGBUFF 32 # Logical log buffer size (Kbytes)> LOGSMAX