Informix under Linux - real crap !

> Please take a look to the article below how to install 9.40 on different > Linux distributions. As far as I know KAIO is not available in the official > sources of Linux 2.4.x kernels. But configuring multiprocessor in $ONCONFIG KAIO Patches are available since RedHat 7.1/7.2. > should really work, e.g. > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor > NUMCPUVPS 2 # Number of user (cpu) vps > SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one No, does not really run. Only 1 CPU is really used. TOP does not show this . Hyperthreading is running fine with Linux Redhat 8.0 and Informix. Why then should it be disabled ? According to Informix support one should generally disable multiprocessor support, because it does not run, it crashes. > RedHat 9 > -------- > "Incorrectly built binary which accesses errno, h_errno or _res > directly. Needs to be fixed." messages. Use 9.40.UC2 when available. Problem is, that 4GL/SQL Toolkit does not compile older code. There is a incompatibility between 9.30 and 9.40 addon's (not the IDS itself), which prevents us from going to 9.40. I really appreciate to know one distribution + patches, which is able to run Informix on SMP w or w/o hyperthreading. KAIO should be a duty for all database OS. Linux has it, why then doesn't Informix support it ? regards, Guido Stepken

Hi, KAIO and Intel Hyper-Threading maybe in the RedHat and SuSE kernels, but not in the standard Linux kernel. As long as such functionality is available only as a patch to the kernel its problematic to support it. As far as I know IDS 9.40 support the functionality of the standard Linux kernel only. Intel Hyper-Threading is not SMP. But SMP is definitely supported by IDS 9.40 on Linux. It should work on the distributions listed in the article I sent. This has been proven many times in real life. Andreas Guido Stepken wrote: > > Please take a look to the article below how to install 9.40 on > > different Linux distributions. As far as I know KAIO is not available > > in the > official > > sources of Linux 2.4.x kernels. But configuring multiprocessor in > $ONCONFIG > > KAIO Patches are available since RedHat 7.1/7.2. > > > should really work, e.g. > > > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor > > NUMCPUVPS 2 # Number of user (cpu) vps > > SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one> > No, does not really run. Only 1 CPU is really used. TOP does not show > this . Hyperthreading is running fine with Linux Redhat 8.0 and > Informix. Why then should it be disabled ? > According to Informix support one should generally disable > multiprocessor support, because it does not run, it crashes. > > > RedHat 9 > > -------- > > "Incorrectly built binary which accesses errno, h_errno or _res > > directly. Needs to be fixed." messages. Use 9.40.UC2 when available. > > Problem is, that 4GL/SQL Toolkit does not compile older code. There is a > incompatibility between 9.30 and 9.40 addon's (not the IDS itself), > which prevents us from going to 9.40. > > I really appreciate to know one distribution + patches, which is able to > run Informix on SMP w or w/o hyperthreading. KAIO should be a duty for > all database OS. Linux has it, why then doesn't Informix support it ? > > regards, Guido Stepken

Hi Guido We have been successfully testing on a 2 physical processor SMP box with Hyper Threading turned on! (so cat /proc/cpuinfo shows 4) This can be verified nicely with top command or with onstat -g glo Individual virtual processors: vp pid class usercpu syscpu total 1 18406 cpu 35.77 0.67 36.44 2 18407 adm 0.04 0.06 0.10 3 18408 cpu 38.49 0.59 39.08 The OS was SuSE SLES 8 (2.4.19-64GB-SMP) 2.2.5-165 glibc (patched) and IBM Informix 9.40 There was some bad experience in the past with HT so this is why support was advising not to use it. Sandor Guido Stepken wrote: > > Please take a look to the article below how to install >> 9.40 on different > > Linux distributions. As far as I know KAIO is not available in the > official > > sources of Linux 2.4.x kernels. But configuring multiprocessor in > $ONCONFIG > > KAIO Patches are available since RedHat 7.1/7.2. > > > should really work, e.g. > > > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for>> multi-processor > > NUMCPUVPS 2 # Number of user (cpu) vps > > SINGLE_CPU_VP 0 # If non-zero, limit number of>> cpu vps to one > > No, does not really run. Only 1 CPU is really used. TOP > does not show > this . Hyperthreading is running fine with Linux Redhat 8.0 and > Informix. Why then should it be disabled ? > According to Informix support one should generally disable > multiprocessor support, because it does not run, it crashes. > > > RedHat 9 > > -------- > > "Incorrectly built binary which accesses errno, h_errno or _res > > directly. Needs to be fixed." messages. Use 9.40.UC2 >> when available. > > Problem is, that 4GL/SQL Toolkit does not compile older > code. There is a > incompatibility between 9.30 and 9.40 addon's (not the > IDS itself), > which prevents us from going to 9.40. > > I really appreciate to know one distribution + patches, > which is able to > run Informix on SMP w or w/o hyperthreading. KAIO should > be a duty for > all database OS. Linux has it, why then doesn't Informix support it ? > > regards, Guido Stepken -- Direct access to this group with http://web2news.com http://web2news.com/?comp.databases.informix

Sandor wrote: > > Hi Guido > We have been successfully testing on a 2 physical processor SMP box with > Hyper Threading turned on! (so cat /proc/cpuinfo shows 4) > This can be verified nicely with top command or with > > onstat -g glo> > Individual virtual processors: > vp pid class usercpu syscpu total > 1 18406 cpu 35.77 0.67 36.44 > 2 18407 adm 0.04 0.06 0.10 > 3 18408 cpu 38.49 0.59 39.08 > > The OS was SuSE SLES 8 (2.4.19-64GB-SMP) 2.2.5-165 glibc (patched) and > IBM Informix 9.40 > There was some bad experience in the past with HT so this is why support > was advising not to use it. > Sandor > > Guido Stepken wrote: > > > Please take a look to the article below how to install > >> 9.40 on different > > > Linux distributions. As far as I know KAIO is not available in the > > official > > > sources of Linux 2.4.x kernels. But configuring multiprocessor in > > $ONCONFIG > > > > KAIO Patches are available since RedHat 7.1/7.2. > > > > > should really work, e.g. > > > > > > MULTIPROCESSOR 1 # 0 for single-processor, 1 for> >> multi-processor > > > NUMCPUVPS 2 # Number of user (cpu) vps > > > SINGLE_CPU_VP 0 # If non-zero, limit number of> >> cpu vps to one > > > > No, does not really run. Only 1 CPU is really used. TOP > > does not show > > this . Hyperthreading is running fine with Linux Redhat 8.0 and > > Informix. Why then should it be disabled ? > > According to Informix support one should generally disable > > multiprocessor support, because it does not run, it crashes. > > > > > RedHat 9 > > > -------- > > > "Incorrectly built binary which accesses errno, h_errno or _res > > > directly. Needs to be fixed." messages. Use 9.40.UC2 > >> when available. > > > > Problem is, that 4GL/SQL Toolkit does not compile older > > code. There is a > > incompatibility between 9.30 and 9.40 addon's (not the > > IDS itself), > > which prevents us from going to 9.40. > > > > I really appreciate to know one distribution + patches, > > which is able to > > run Informix on SMP w or w/o hyperthreading. KAIO should > > be a duty for > > all database OS. Linux has it, why then doesn't Informix support it ? > > > > regards, Guido Stepken > > -- > Direct access to this group with http://web2news.com > http://web2news.com/?comp.databases.informix I testing now SuSE 8.2 using glibc 2.3.2-9 and a sudo script to overcome the mapped_base 'feature'. During 6 days of testing I did not have any problem with Hyperthred Mode ON What problems should I expect? Anyone can give a hint? dic-K -------------- Richard Kofler SOLID STATE EDV-Dientleistungen Vienna, Austria