Enabling SQL Tracing for Siebel Database Utilities

You can enable SQL tracing by setting the DBUTIL_LOG_EVENTS environment variable before you run any of the Siebel database utilities, for example, the ddlimp, dataimp, ddlsync, or repimexp utilities. These utilities are invoked by the Siebel Migration application, therefore the environment must be set up before running the migration plan. Depending on the operating system you are using, DBUTIL_LOG_EVENTS should be set as the System Environment variable (on Windows) or exported to the siebenv.sh shell script (on UNIX).

To enable SQL tracing for Siebel database utilities

On Windows operating systems, define a System Environment variable as shown in the following table.

Variable Name	Value
`DBUTIL_LOG_EVENTS`	`SQLParseAndExecute=5,SQLDBUtilityLog=3`

On UNIX operating systems, export the environment variable in the siebenv.sh shell script as follows:
```
export DBUTIL_LOG_EVENTS="SQLParseAndExecute=5,SQLDBUtilityLog=3"
```
You must restart the Siebel Server for the change to take effect.