Logging database driver trace information

The database driver provides an option to trace online information about the actions 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 files 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.

To enable tracing, you can use the environment variable DBSLOG. Debugging information is appended to the file dbs.log in the Windows directory %BSE%\tmp or the UNIX directory $BSE/tmp. On a Windows system, if you invoke logging remotely with rexec, the log is stored in the Windows file %BSE%\tmp.

To enable tracing, specify this command:

SET DBSLOG=1570

To enable tracing for only categories of interest, several tracing categories are defined. For more details, see Database Driver Resources and Environment Variable.