Procedure documentationDatabase Trace Locate this document in the navigation structure

 

The Tools user menu contains, among other things, the database trace tool.

Note 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.

End of the note.

Procedure

Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10). Choose   Tools   Database Trace  .

or

Open the DBA Cockpit (transaction DBACOCKPIT) and select   Tools   Database Trace  .

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

Database/liveCache Alert Monitor, Monitor

Database Administration, Traces