dbs/db2/sql_trace: To switch on/off the DbSl SQL trace

To switch on/off the DbSl SQL trace.

  • 0
    • means the trace is switched off for all work processes.
  • 1
    • means important DbSl messages get traced (used by DbSl per default).
  • 2
    • means all CLI calls get traced plus everything traced with trace level 1
  • 3
    • means all CLI call get traced in detail (with data and data types) plus everything traced with trace level 2

This trace can be conveniently be set by using transaction SM50. There you can select the work processes you want to trace and then click Administration -> Trace -> Active Components, choose the trace level and switch on Database (DBSL).

To display the trace output click Administration -> Trace -> Display File -> Current.

You May Also Like

Leave a Reply?