Re: Error on Informix Online
In article <31FC21E7.57AE@west.co.za>, Mark D Stock <marks@west.co.za> says:
>
>Kino wrote:
>> Hi,
>> I hope you apoligize my english. I have a HP900 with HPUX 9.04 and Infomix
>> Online 7. When i execute this select
>> <Vital stuff snipped due to STUPID news reader not allowing more included text than new
>text!!!>
>> i recive this error
>>
>> PID 10763 received a SIGSEGV for stack growth failure. Possible causes
>> insufficient memory o swap space, or stack size exceeded maxssiz.
>>
>> If i remove the order by statement the select work ok.
>
>Weeell, you could try creating the following:
>
>CREATE INDEX x1 ON bas_doctes ( doctes_azie,
> doctes_dtadoc,
> doctes_numdoc,
> doctes_doctes,
> doctes_enaz,
> doctes_tipdoc,
> doctes_lineac,
> doctes_iart,
> doctes_copa,
> doctes_agba,
> doctes_tiplis,
> doctes_aliq,
> doctes_agente,
> doctes_bolfis)>
>But I don't REALLY recommend this. You should look at splitting up this SELECT into a
>number of smaller SELECT statements. Also check that you actually do need ALL columns
>from each table.
>
>If this SELECT was generated by a front-end tool, then look at reducing the initial
>query. Perhaps read an initial query into a temporary area and then base a subsequent
>SELECT on those results.
>
>Hope that helps,
It appears to me that the order by is being done in memory. This is effieicent but is clearly
not working. There is an environment variable available for this to be done
either in a dbspace or to disk. Check your manuals under PSORT
Regards
Terry