Re: onstat -g iof
Vaclav.Boura@cpp.cz wrote:
> 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
It looks like you have code running that is using the SET EXPLAIN ON
command. This command opens a file called sqexplain.out and dumps optimiser
plans to it. This is a debugging feature and shouldn't be left on in
production.
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+
sending to informix-list