Topics:

• Available Traces
• Activating Trace Components
• Activating the Trace Destination
• Deactivating Trace Components
• Trace Activation and Deactivation Examples
• Querying Traces
• Allocating FSTRACE

The adapter communicates with the RDBMS through SQL statements it generates on your behalf. You can view these SQL statements with the trace facility. Traces are helpful for debugging procedures or for adapter performance analysis. The trace facility is easy to invoke, requires no changes to either the adapter or FOCUS request, and have no effect on how the adapter functions.

The trace facility can provide several types of information, organized into trace components and levels.

Using a SET command, you must turn on each trace component and level you want to generate prior to issuing the request to be traced.

Note: The trace facility is intended for use in query optimization and problem debugging. Application programs should not be written to depend on the format or content of any trace, as they may change in later releases of the adapter.