performance tuning : onstat - alike ???

Does there exist some tool or statement to ask a certain session which PROCEDURE (or function) and/or which STATEMENT it is currently processing ? ONSTAT -g ses sesid only gives you which statement-type it is processing. This would greatly help me solving a few performance problems (eg determing which instructions are too time consuming and most of all : WHY ? ) Kind regards, David.

David Van Huffel wrote: > > Does there exist some tool or statement to ask a certain session which > PROCEDURE (or function) and/or which STATEMENT it is currently > processing ? > ONSTAT -g ses sesid only gives you which statement-type it is > processing. Try "onstat -g sql" or "onstat -g sql sessid" and/or if you want more: $ dbaccess sysmaster <<EOF SELECT * -- or what you want to know FROM syssessions; SELECT * -- or what you want to know FROM syssqlcurall; SELECT * -- or what you want to know FROM syssqexplain;EOF $ Note: These tables/views can change in future versions of IDS. regards Markus > This would greatly help me solving a few performance problems (eg > determing which instructions are too time consuming and most of all : > WHY ? ) > > Kind regards, > > David.