onstat -g iof

Hello all, when I perform onstat -g iof I see 82 sqexplain.out at the end. What does it mean ? 84 sqexplain.out 86 sqexplain.out 87 sqexplain.out 89 sqexplain.out 90 sqexplain.out 91 sqexplain.out 93 sqexplain.out 94 sqexplain.out Best regards, Vaclav Boura sending to informix-list

On Tue, 30 Sep 2003 06:52:18 -0400, Vaclav.Boura wrote: It means you have a mess of open sessions running with SET EXPLAIN ON; set or depending whether the feature is available in your version, for which onmode -Y <sesid> 1 was run. These are open file handles to the output file for SET EXPLAIN, ie sqexplain.out. Art S. Kagel > Hello all, > when I perform onstat -g iof I see 82 sqexplain.out at the end. What does it > mean ? > 84 > sqexplain.out > 86 > sqexplain.out > 87 > sqexplain.out > 89 > sqexplain.out > 90 > sqexplain.out > 91 > sqexplain.out > 93 > sqexplain.out > 94 > sqexplain.out > > > Best regards, > Vaclav Boura > > sending to informix-list

Art S. Kagel wrote: > On Tue, 30 Sep 2003 06:52:18 -0400, Vaclav.Boura wrote: > > It means you have a mess of open sessions running with SET EXPLAIN ON; set or > depending whether the feature is available in your version, for which onmode -Y > <sesid> 1 was run. These are open file handles to the output file for SET > EXPLAIN, ie sqexplain.out. > > Art S. Kagel > > >>Hello all, >>when I perform onstat -g iof I see 82 sqexplain.out at the end. What does it >>mean ? Another possibility to check (I think) is a stored procedure created with a SET EXPLAIN ON inside. Regards