Informix -208 error

For those of us who do not know what the -208 is: -208 Memory allocation failed during query processing. The database server needed to allocate data space memory in order to process the query, and none was available. This may reflect a hardware limit, or an operating system configuration limit, or a temporary shortage of space. Try the query again after a delay. If it still fails, consult your system administrator. If possible, revise your query to join fewer tables or order or group on fewer columns, or to operate in two or more separate statements. --- Sounds to me if this gives you your answer to the problem, Now what to do to fix it: 1.Identify the culprit query! Reduce the join/order by/group by ...... make the query as efficient as possible. 2.You might also trying to increase you Shared Memory Size by modifying the BUFFER parameter in the configuration file and bouncing the engine! 3. After trying 1 and 2 above the OBVIOUS ---- Get some more memory. Hopes this helps! Cheryl L. Kendricks vnibs2@heb.com --------------------------( Forwarded letter 1 follows )--------------------- Date: Friday, 28 February 1997 1:46pm From: tim@mccltd.demon.co.uk Subject: Informix -208 error Date:Fri, 28 Feb 1997 12:27:36 -0600 Reply-To: Tim McCrea <tim@mccltd.demon.co.uk> Organization: MCC Limited Sender: informix-list-owner@rmy.emory.edu To: informix-list@rmy.emory.edu X-Informix-List-Id: <news.34627> Hi, Hopefully there is an Informix magician out there who can help me cos I'm stuck big style!! We consistently get an error (-208) when executing one report and I haven't got a clue what the problem is. The platform is an ICL DRS6000 (sparc) with 128mb ram. Online V5 and 4GL/RDS V4.11. Any help, clues, pointers, anything at all would be gratefully appreciated. Thank you -- Tim McCrea Am drink and eat lots tim@mccltd.demon.co.uk