Re: segv - more info
In article <352BA4DF.34C27654@aethos.co.uk>, Pete Smith
<pete.smith@aethos.co.uk> writes
>many thanks to contributions received on this ( Mats, Harold, Josef),
>they have all allowed me to progress this.
>
>But particularly thanks for the AFDEBUG tip, it has allowed me to trap
>the offending sql statement,
>and here it is:
>
>Current SQL statement :
> SELECT cd.call_data_t,min(handler_id), min(state), min(last_pri),
> min(curr_svc), min(cli_sub), min(tli_sub), min(ld_first.cli),
> min(ld_first.tli), min(ld_first.setup_utc),
>min(ld_first.answer_utc),
> min(ld_first.last_utc), count(ld.call_data_t) FROM call_data cd,
>outer
> (leg_data ld, leg_data ld_first) WHERE cd.call_data_t =>ld.call_data_t
> AND ld.call_data_t = ld_first.call_data_t AND ld_first.index =
> (SELECT min(index) FROM leg_data WHERE call_data_t = ld.call_data_t
>)
> GROUP BY 1 ORDER BY 1 ASC
>
>Last parsed SQL statement :
> SELECT host_name,>
>ipl_proc,pkg_lbl,proc_lbl,ipl_recno,command,args,wait_rep,max_tries,restrt_
>
>
>slp,restrt_cyc,recvry_pln,proc_offset,pid,retry_cnt,state_tm,state,report_i
>
> t FROM act_prcs WHERE command matches '*fsdlexe *' OR command
>matches
> '*callctrl *'
>
>I assume the current statement is the relevant one.
>Can anyone tell me if this would generate a hash table?
>If so, any suggestions on reworking it so that it doesn't?
>
Try running the query in dbaccess with
SET EXPLAIN ON;
first then lok at the sqexplain.out file produced.
Try setting OPTCOMPIND=0 in $ONCONFIG.
>many thanks
>
>Pete
>
>P.S. how should I allow the system to carry on when it says *oninit 2282
>waiting for debugger*?
>
--
David Williams
Maintainer of the Informix FAQ
Primary site (Beta Version) http://www.smooth1.demon.co.uk
Official site http://www.iiug.org/techinfo/faq/faq_top.html
I see you standin', Standin' on your own, It's such a lonely place for you, For
you to be If you need a shoulder, Or if you need a friend, I'll be here
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care