Where do you find the trace file?

In versions 8.0 or higher, the trace file is created on the application server in the {PS_HOME}\appser\{DBNAME}\LOGS directory. The name is a combination of the operator ID, the machine name or IPAddress, and “.tracesql” (for example, aafaque_CPU1.tracesql). These files can get really big really quickly. So it is advisable if you are trying to track a specific problem that you delete the file first and then navigate to the problem, repeat, and immediately save off the file before it grows to an unmanageable size.