The Tools menu contains the database trace tool.
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.
Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10). Choose .
The database trace display is part of the DBA Cockpit and can therefore also be called as follows:
Open DBA Cockpit (transaction DBACOCKPIT).
The display options in DBA Cockpit vary depending on which SAP NetWeaver release you are using:
SAP NetWeaver 7.1: Choose .
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:
Choose Flush Trace Buffer. The information still remaining in the buffer is written in the trace, thereby updating it.
Choose Analyze Trace.
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.
DBA Cockpit:SAP MaxDB, Database Trace
Database/liveCache Alert Monitor, Monitor
Database Administration, Traces