SetTraceLevel is a procedure that allows you to modify the trace level for the running s-Server. For testing, development and problem diagnosis this is often easier and more immediate than modifying the file.


  • To generate FINEST tracing of both the Kafka plugins:
    CALL SETTRACELEVEL('com.sqlstream.aspen.namespace.kafka', 'FINEST');
  • To increase the trace level to CONFIG for all ECDA plugins:
    CALL SetTraceLevel('com.sqlstream.aspen.namespace', 'CONFIG');
  • To set every logger to FINE:
    call settracelevel('','FINE');

NOTE: trace levels are changed for the entire server - the effect is not limited to the current session.

For more information about s-Server tracing see Using Trace Files.