Logging database driver trace information

The database driver provides an option to trace online information about the actions that are being performed by the driver. The resulting log file contains debugging information that can help solve problems.

When tracing is enabled, the information stored in the log file includes:

  • Table and index information (data dictionary).
  • The SQL statements being executed.
  • Values of the input and output bind variables.
  • Other function-level debug statements.

Tracing can be enabled using the environment variable DBSLOG. Debugging information is appended to the file dbs.log in the directory %BSE%\tmp. Tracing can be enabled by running this command: 

SET DBSLOG=0560

Several tracing categories are defined so that tracing can be enabled for only categories of interest. For more information, see "Driver resources and environment variables" .