SYSCS_UTIL.SYSCS_SET_LOGGER_LEVEL

The SYSCS_UTIL.SYSCS_SET_LOGGER_LEVEL system procedure changes the logging level of the specified logger.

You can read more about Splice  Machine loggers and logging levels in the Logging topic.

Syntax

SYSCS_UTIL.SYSCS_SET_LOGGER_LEVEL(loggerName, logLevel)

loggerName

A string specifying the name of the logger whose log level you want to find.

loggerLevel

A string specifying the new level to assign to the named logger. This must be one of the following level values, which are described in the Logging topic:

  • TRACE
  • DEBUG
  • INFO
  • WARN
  • ERROR
  • FATAL

Results

This procedure does not return a result.

Usage Notes

You can use the TRACE option of the Splice Machine StatementManager log to record the execution time of each statement:

splice> CALL SYSCS_UTIL.SYSCS_SET_LOGGER_LEVEL ( 'com.splicemachine.utils.SpliceUtilities', 'TRACE');
Statement executed

You can find all of the available loggers by using the SYSCS_UTIL.SYSCS_GET_LOGGERS system procedure.

Example

splice> CALL SYSCS_UTIL.SYSCS_SET_LOGGER_LEVEL( 'com.splicemachine.mrio.api', 'DEBUG' );
Statement executed.

See Also