Re: Informix -208 error

In article <$wNonDAUGOGzEwgD@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> writes >In article <331733be.39980879@gate.idg.no>, Nils Myklebust ><Nils.Myklebust@idg.no> writes >>Tim McCrea <tim@mccltd.demon.co.uk> wrote: >> >>: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. >> > > Try using finderr -208 to get the error message. In this case it is > -208 Memory allocation failed in query proceesing. > > This means you are running out of memory on the machine, either add > more swap or add more memory in the machine. > I know, replying to myself but I'm more awake today... If you are running Online 7.x then check in your ONCONFIG file to see if OPTCOMPIND is set to 2. If so then change to to 0 and try again. The default under 7.x is OPTCOMPIND=2 and it gets reset back to 2 if you upgrade to a later version of 7.x!!. -- David Williams