Oninit cdi / Archive
Talk to an expert →

ALR Quad6 4 CPU and Informix RSAM Version 5.03.UC1 on SCO 3.2v4.2 hangs

Posted in 1997

Topics: High Availability & Replication, Performance & Tuning, Installation, Setup & Upgrades, Error Codes & Troubleshooting, Logging & Checkpoints, Networking & sqlhosts Configuration

Michael Huehne — — source:  3.2.4l installed@@NL@@@@NL@@# /etc/conf/cf.d/stune@@NL@@@@NL@@MAXACPUS 3@@NL@@NODE "noname"@@NL@@SECLUID 0@@NL@@SECSTOPIO 1@@NL@@SECCLEARID 1@@NL@@MSGMAP 800@@NL@@MSGMAX 4096@@NL@@MSGMNB 8192@@NL@@NINODE 3000@@NL@@NS5INODE 450@@NL@@NFILE 3000@@NL@@NOFILES 200@@NL@@NQUEUE 1600@@NL@@NSTREAM 160@@NL@@NBLK4096 128@@NL@@NBLK2048 96@@NL@@NBLK1024 256@@NL@@NBLK512 512@@NL@@NBLK256 512@@NL@@NBLK128 512@@NL@@NBLK64 768@@NL@@NBLK16 768@@NL@@NBLK4 768@@NL@@NUMTIM 96@@NL@@NUMTRW 96@@NL@@NSPTTYS 32@@NL@@EVQUEUES 128@@NL@@EVDEVS 128@@NL@@NPROC 500@@NL@@NREGION 2048@@NL@@MAXUP 500@@NL@@SEMMAP 100@@NL@@SEMMNI 500@@NL@@SEMMNS 500@@NL@@SEMMNU 100@@NL@@SEMMSL 60@@NL@@SHMMAX 32000000@@NL@@SHMALL 15360@@NL@@SHMMNI 1024@@NL@@SHMMIN 1@@NL@@SHMSEG 15@@NL@@NDISK 6@@NL@@NHINODE 2048@@NL@@MAXSLICE 50@@NL@@MAXUMEM 16384@@NL@@NMPHEADBUF 200@@NL@@S5CACHEENTS 512@@NL@@S5HASHQS 233@@NL@@NCALL 350@@NL@@MAX_CFGSIZE 2048@@NL@@NBUF 8192@@NL@@MAXBUF 8192@@NL@@NMOUNT 16@@NL@@@@NL@@Here is the Informix database log file showing a typical situation:@@NL@@@@NL@@# tbstat -@@NL@@@@NL@@...@@NL@@@@NL@@07:30:01: RSAM Version 5.03.UC1 -- On-Line -- Up 13 days 14:20:49 -- 54208 Kbytes@@NL@@07:30:02: RSAM Version 5.03.UC1 -- On-Line -- Up 13 days 14:20:50 -- 54208 Kbytes@@NL@@@@NL@@... continuing until@@NL@@@@NL@@10:00:38: RSAM Version 5.03.UC1 -- On-Line -- Up 13 days 16:51:25 -- 54208 Kbytes@@NL@@10:00:39: RSAM Version 5.03.UC1 -- On-Line -- Up 13 days 16:51:26 -- 54208 Kbytes@@NL@@10:00:40: RSAM Version 5.03.UC1 -- On-Line -- Up 13 days 16:51:27 -- 54208 Kbytes@@NL@@10:00:41: RSAM Version 5.03.UC1 -- On-Line -- Up 13 days 16:51:28 -- 54208 Kbytes@@NL@@10:00:42: RSAM Version 5.03.UC1 -- Shutting Down -- Up 13 days 16:51:30 -- 54208 Kbytes@@NL@@10:00:43: RSAM Version 5.03.UC1 -- Quiescent -- Up 13 days 16:51:31 -- 54208 Kb

Hello Stefan and David, I have seen former answers from you in comp.databases.informix. Would you please be so friendly and spend few minutes of your time for my current problem ? Maybe you are able to help me a lot with your knowledge about SCO on MP machines and Informix databases :-) Hi folks, any help would be appreciated. A new customer of mine needs some support from me. He is the owner of several ALR Quad6/QSMP4 machines. The main configuration is shown below. I have never seen the machines before. But I want ask you for some useful hints. Maybe I do not need to reinvent the wheel again ? If you need more details I am willing to deliver the missing informations. The main application is a relational Informix Turbo RSAM Version 5.03.UC1 SQL data base (I am not shure about the database version at all). The problems which my customer told me about : ============================================== ' Sometimes the machine hangs in moments without any system activity, at the weekend for example. ' Sometimes the performance breaks down for several seconds and the machine might hang or come back with full power. Nobody knows why. ' This bad situation happens often while the Informix database wrote their checkpoints. But not in every case. ' Often the time to write a database checkpoint is greater than 10 seconds. ' While backing up the machine with the dedicated Adaptec 2940U adaptor and the Sony DAT tape; again, sometimes the machine hangs. ' Unfortunately the stopped machine does not generate a system trap entry in the common log file nor can the customer see any panic message on the system console. ' The load of that MP-machine is never higher than 2.5. Most of the time the load average is around 0.7. This is not a very good base to serve a mission critical Informix turbo database. Now my questions: ================= ' Have you ever heard about such a strange behaviour ? My first idea would point me to a problem with the main RAM or the main ADAC disk RAID controller includes 32 MB Cache. ' Have you every seen such an ALR computer in a similar configuration working fast and solid like a rock as an Informix database server ? ' Have you any hints which parameters in the /etc/conf/cf.d/stune file need to be modified for great performance with all 4 CPUs. ' Have any thumb rules which other kernel parameters normally needs to be modified for large Databases ? ' Are there are any good performance monitor programs available for the old SCO-Unix 3.2v4.x ? Whats the price in $ or DEM and what is the name of the brand and which company is actually selling the tool ? The hardware: ============= ALR Quad6 w. 4 CPUs 4 Intel Pentium CPUs 128 MB RAM 1 ADAC-Controller incl. 32 MB Cache 7 HD SCSI 2GB SCA Seagate Baracuda organized as RAID 5 level with 6 disks active plus 1 Hot-Spare 1 Adaptec 2940U to drive the streamer 1 SCSI-streamer Sony SDT7000 1 network card 3COM 3C900 # hwconfig output name=fpu vec=13 dma=- type=80387 name=serial base=0x3F8 offset=0x7 vec=4 dma=- unit=0 type=Standard nports=1 name=floppy base=0x3F2 offset=0x5 vec=6 dma=2 unit=0 type=135ds18 name=console vec=- dma=- unit=vga type=0 12 screens=68k name=parallel base=0x378 offset=0x2 vec=7 dma=- unit=0 name=eisarom vec=- dma=- eisa (1.3.0) name=adapter vec=10 dma=- type=adacrd ha=0 id=7 name=adapter base=0xF800 offset=0x0 vec=11 dma=- type=alad ha=0 id=7 fts=st name=e3H base=0xFCC0 offset=0x1F vec=5 dma=- 3Com 3C90x, unit=0 name=tape vec=- dma=- type=S ha=0 id=2 lun=0 ht=alad name=disk vec=- dma=- type=S ha=0 id=0 lun=0 ht=adacrd0 fts=sdnb name=Sdsk vec=- dma=- cyls=189 hds=255 secs=63 name=CPU2 vec=255 dma=- type=Pentium(tm) cpu with fpu name=CPU3 vec=255 dma=- type=Pentium(tm) cpu with fpu name=CPU4 vec=255 dma=- type=Pentium(tm) cpu with fpu name=disk vec=- dma=- type=S ha=0 id=0 lun=1 ht=adacrd0 fts=sdnb name=Sdsk vec=- dma=- cyls=332 hds=255 secs=63 name=disk vec=- dma=- type=S ha=0 id=0 lun=2 ht=adacrd0 fts=sdnb name=Sdsk vec=- dma=- cyls=791 hds=255 secs=63 # swconfig output Set Release Notes --- ------- ----- 3Com 3C90x Driver Release 2.0.0a 2.0.0a installed 3Com 3C59x Driver Release 1.1e 1.1e installed SCO Multiprocessing Drivers EFS 1.0.0a installed SCO APIC MP Driver EFS Release 1 1.0a removed SCO System V O.S. International 2.2.0e installed SCO MPX Multiprocessing 3.0.0j installed 3Com EtherLink III Driver Releas 1.4 installed SCO Open Server Network System 3.0.0c partially installed SCO IPX/SPX Runtime System 1.0.3e installed SCO NFS Runtime System 1.2.1j installed SCO TCP/IP Runtime System 1.2.1o installed SCO LLI Driver Disk 3.1.1h installed SCO UNIX System V Extended Utili 3.2.4l installed L\

Glossary