Entering content frame

Function documentation Traces Locate the document in the library structure

Use

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

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 instance with the lowest possible load and execute only those actions that are necessary to reproduce the error.

Traces

File Name
(Default Value)

Directory
(Default value)

Description

Activate trace

knltrace

Run directory of the database instance:

<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

Switching on the database trace only has a negative effect on performance with liveCache database instances. This is not the case with MaxDB database instances.

Use the Database Manager database tool, or the CCMS in SAP systems.

See

- Database Manager GUI, Structure linkUsing the Database Trace

- Database Manager CLI, Structure linktrace_on

- Database Administration in CCMS, Structure linkDatabase Trace

sqltrace.pct

Your choice

ODBC trace

The MaxDB ODBC driver logs all SQL statements that the application transmits to the database system.

This ODBC trace is not identical to the SQL.LOG trace that you can switch on and off in the ODBC Data Source Administrator (Microsoft Windows) in register tracing.

Specify the corresponding option for the data source.

See ODBC Manual, Structure linkProperties of Database Parameters

Your choice

Your choice

JDBC trace

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

See Java Manual, Structure linkMethod java.sql.DriverManager.getConnection and Structure linkClass com.sap.dbtech.jdbcext.DataSourceSapDB

sqldbctrace-<pid>.prt

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

<user_home>/.sdb
(UNIX/Linux)

SQLDBC Traces

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.

See

- SQLDBC Manual, Structure linkSQLDBC Traces

- Database Administration in CCMS, Structure linkSQLDBC Trace

See also:

Troubleshooting

Installation Manual, Structure linkDirectories

 

Leaving content frame