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.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
