Show TOC

Database TraceLocate this document in the navigation structure

Use

The Tools menu contains the database trace tool.

Note

The database trace only adversely affects performance in SAP liveCache databases; in other databases you can use the database trace even in normal operation.

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

Procedure

Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10). Choose Start of the navigation path Tools Next navigation step Database Trace End of the navigation path.

The database trace display is part of the DBA Cockpit and can therefore also be called as follows:

  1. Open DBA Cockpit (transaction DBACOCKPIT).

  2. The display options in DBA Cockpit vary depending on which SAP NetWeaver release you are using:

    • Choose Start of the navigation path Diagnosis Next navigation step Database Trace End of the navigation path.

    • SAP NetWeaver 7.1: Choose Start of the navigation path Tools Next navigation step Database Trace End of the navigation path.

Result

Activating, Deactivating, and Initializing the Trace

  • To activate the trace, select the required trace component and choose Activate Trace. You can activate more trace components while the trace is running by selecting them and choosing Activate Trace again.

  • To activate the trace on a particular level, select the required trace component and choose Activate Trace (Level). You have the option of changing the default value for the trace level. The higher the trace level, the more detailed the information collected by the database trace will be.

  • To deactivate the trace, choose Deactivate Trace. This deactivates any trace components that are selected.

  • To initialize the trace, choose Initialize Trace. After initialization, only the database actions are logged.

Setting Additional Options

You can specify the respective procedures for switching on/off the database trace.

  • Activating the Trace

    If you want to write the database trace for all database sessions, choose For All Sessions. If you only want to write the database trace for a particular database session, select Only for Session with Number and enter the session number.

  • Deactivating the Trace

    If you want to switch off the database trace manually, select Manual Only. If you want the database trace to switch off automatically when a particular error occurs, select Automatically with an Error Code and enter the database error code.

If you have configured the database trace such that it is only written for a particular database session or is deactivated automatically, a warning message appears to bring these options to your attention.

Analyzing and Displaying the Trace

To evaluate the trace, proceed as follows:

  1. Choose Flush Trace Buffer. The information still remaining in the buffer is written in the trace, thereby updating it.

  2. Choose Analyze Trace.

  3. Back up the database trace you have displayed by choosing Save to Local File. This stops it from being overwritten by the next trace analysis.

To view a prepared trace again, choose Display Trace.

More Information