Default name and location of the output file on Windows

On Windows™, SET EXPLAIN ON writes the plan that the optimizer chooses for each subsequent query to a file in %ONEDB_HOME%\sqexpln.

For explain output files generated by the SET EXPLAIN statement, the default file name is user_name.out, where user_name is the user login.

For explain output files generated by onmode -Y, the default file name is sqexplain.out.session_id.