RE: onstat -g iof
It also puts a big performance overhead on your system - slows it down. Don't use it unless totally necessary.
-----Original Message-----
From: Art S. Kagel [mailto:kagel@bloomberg.net]
Sent: Tuesday, September 30, 2003 3:04 PM
To: informix-list@iiug.org
Subject: Re: onstat -g iof
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
sending to informix-list