Implementing Siebel Business Applications on DB2 UDB for z/OS > Maintenance Considerations for z/OS > Dynamic SQL in the Siebel Application >

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, ddlsynch, dev2prod, or repimexp utilities.

To enable SQL tracing for database utilities

• Set the environment variables as follows:

  set DBUTIL_LOG_EVENTS=SQLParseAndExecute=5,SQLDBUtilityLog=3