Re: Error 208: Shared memory problem

In article <3419599D.1145@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >Foster Bass wrote: >> >> I am using a newly configured Informix install on a RISC running >> AIX4.1.2 and every time I try to join mor than three tables in an SQL >> statment, I get an error 208. >> -208 Memory allocation failed during query processing. > >> I have spent close to 20 hours on the phone with five different tech >> support folks at Informix and none of them were able to help me or >> reproduce the problem. I have the same code running on another machine >> without the error. >> >> I have even gone as far as to uninstall the entire Informix database and >> reinstall it from CD. (this was Informix's latest suggestion). >> >> Does anyone know how to resolve this problem or how to allocate >> additional shared memory? > 1. Run swap -l (or equivalent to check swap space available) sar -r 1 1 also helps. 2. Check SHMTOTAL = 0 in ONCONFIG, if not set to 0 and restart online 3. Check UNIX kernel parameters HDATLIM/SDATLIM Set these to unlimited usally (0x7FFFF...) HSTKLIM/SSTKLIM HVMMLIM/SVMMLIM MAXMEM Set to unlimited again (0 ??) MAXUMUM 4. Run onstat -g seg and check to see how much Online has already allocated, is this reasonable? >Make sure that all of the shared memory parameters in the ONCONFIG file >are at least as large as those on the machine that works. Do you have >as much RAM/swap on the new machine as on the old one? What about the >AIX kernel configuration parameters? Are these at least as large as >the test configuration outlined in the release notes? Are they as large >as those on the machine that works? Have you actually booted the latest >kernel which contains these parameters? > >What exactly is the same between the two machines, what is different? > >Art S. Kagel -- David Williams