Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
David Williams — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.