Background documentation Database Trace Locate the document in its SAP Library structure

You can activate a database trace. When you do this, the trace writer task logs all reactions of the database kernel to database statements in the log knltrace. This also means that the database trace can be used not only to trace errors that occur when statements are processed but also to provide a more exact classification of inconsistencies caused, for example, by hardware errors.

Caution

Only activate a database trace if you are asked to do so by the SAP DB Support team. We do not recommend that you activate the database trace function unless it is really necessary, because it seriously affects the performance of the database instance.

While the database trace is activated, run the database instance with the smallest load possible, and only perform those actions needed to reproduce the error.

Deactivate the database trace as soon as the actions needed for the analysis have been logged.

Procedure

Database Manager GUI: SAP DB 7.4, section Structure linkActivating the Database Trace Function
Database Manager CLI: SAP DB 7.4, section Structure linkDatabase Trace Functions