19.4. SQL Logging

Logging of SQL statement can be activated by modifying the log4j configuration, as mentioned in the preceding sections.

For SICS Workstation and SICS System Administration Utility it is also possible to enable SQL logging or tracing by selecting from the menu, Help - About SICS - System Info… - Logging. This will open a window where SQL logging can be directly configured.

The SQL Log Analyzer button will open a file selection window so you can select a log file. It will then attempt to produce an Excel File with useful diagnostic information from the SQL log.

Note that the changes are valid for the current SICS session only.