Using Trace Flags, SQL Trace Flags, and Error Flags

You can activate trace flags and error flags to log transactions. This topic covers the following types of flags:

• Error flags. See Error Flags.

• SQL Trace flags. See SQL Trace Flags.

• Trace flags. See Trace Flags.

Note: Activating flags will have a direct effect on performance. Typically, activating flags should only be done when testing EIM processes. Avoid activating flags in a production environment unless absolutely necessary.

Recommended settings for error flags, SQL trace flags, and trace flags include the following:

• To display errors and unused foreign keys. Start with the following setting combination. The setting Trace Flag=1 provides a summary (after each batch) of the elapsed time in EIM steps 10 and 11.

Setting	Value
Error Flag	1
SQL Trace Flag	1
Trace Flag	1

• To determine SQL performance. The following setting combination produces a log file with SQL statements including the elapsed time for each statement.

Setting	Value
Error Flag	1
SQL Trace Flag	8
Trace Flag	3

• To determine optimal batch size and monitor performance in a particular step. The following setting combination produces a log file showing the elapsed time for each EIM step.

Setting	Value
Error Flag	0
SQL Trace Flag	0
Trace Flag	1