Re: Error 208: Shared memory problem

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. > > 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? 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