Procedure documentationTraces Locate this document in the navigation structure

 

You can use various traces to obtain detailed information on the actions of the database system.

Note Note

Performance can decline while a trace is being written. You should therefore switch off the trace as soon as the actions necessary for the analysis have been logged.

As long as a trace is being written, operate the database with the lowest possible load and execute only those actions that are necessary to reproduce the error.

End of the note.

Procedure

Traces

Default File Name

Default Directory

Description

How to Activate the Trace

knltrace

Run directory of the database:

<independent_data_path>\wrk\<database_name>

Database trace

The system logs all messages from the kernel.

You can use the log file to identify errors, such as those that occur while processing SQL statements.

Note that activating the database trace has a negative effect on performance only with SAP liveCache databases. This is not the case with SAP MaxDB databases.

odbctrace-<pid>.prt

<user_home>\Application Data\sdb (Microsoft Windows)

<user_home>/.sdb (Unix/Linux)

ODBC trace

The system can log SQL statements, communication packages, method calls and call parameters.

<pid>= Process ID

Use the odbc_cons database tool.

More information:

ODBC Manual, Troubleshooting Using the SAP MaxDB ODBC Trace

Your choice

Your choice

JDBC trace

The SAP MaxDB JDBC driver logs all JDBC API calls and their input parameters, return values and the corresponding thread.

Specify the corresponding option for establishing the connection.

More information: Java Manual, JDBC Trace

sqldbctrace-<pid>.prt

<user_home>\Application Data\sdb (Microsoft Windows)

<user_home>/.sdb (Unix/Linux)

SQLDBC Trace

The system can log SQL statements, communication packages, method calls and call parameters.

<pid>= Process ID

Use the sqldbc_cons database tool, or the CCMS in SAP systems.

More information:

More Information

Log Files

Glossary, Directory