The SQL Server, DB2, Oracle, and ODBC switch modules have been coded to use the Consolidated Trace Facility to aid in debugging any errors returned during
operation. We have provided a configuration file,
ctf.cfg, by default located in the
%ProgramFiles(x86)%\Micro Focus\Enterprise Developer\src\enterpriseserver\xa
directory, to serve as a starting point. To enable this facility:
- Edit the
ctf.cfg file using any text editor and change the location parameter on line 6 to the directory where you want to store your trace
files.
- Create a new system environment variable named MFTRACE_CONFIG, and set its value to the full path where
ctf.cfg is located.
- Reboot your system to register MFTRACE_CONFIG.
- Start Enterprise Server.
Once enabled, the Consolidated Trace Facility writes SQLCODE, SQLSTATE and any associated SQL error messages to a trace file
named
cassi.textfile.processid.log, located in the directory you specified.
Processid is the process ID under which the Enterprise Server SEP was running when the logfile was created.