segv - more info
Posted in 1998
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?
many thanks
Pete
P.S. how should I allow the system to carry on when it says *oninit 2282
waiting for debugger*?