Tracing Data Adapter Processing

Topics:

The data 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 data adapter performance analysis. The trace facility is easy to invoke, requires no changes to either the data adapter or FOCUS request, and have no effect on how the data adapter functions.

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

Using a SET command, you must turn on each trace component 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 data adapter.


Information Builders