Question:
I can’t find the sqexplain.out file. Where is it?
Answer:
In UNIX systems, this file is usually placed in the directory from which you called the dbaccess or other job that ran the SET EXPLAIN.
In Windows, this file is placed in a subdirectory underneath the Informix home (usually c:informix) directory.
On UNIX (or Windows systems running MKS utilities), you can use the “find” command to locate this or any other file:
find / -name "sqexplain.out" -print
In Windows NT, you can do the same thing with the “Find” command on the taskbar. Just enter the name or part of the filename and NT will find it for you.