Enable Logging

To enable query service logging, within cognos

Logging is enabled through the xqe.diagnosticlogging.xml configuration file, located in the /configuration directory

To enable tracing of the SQL executed through Cognos please add the following trace level within the file and save. No requirement or need to restart Cognos service to activate logging.

Locate the following eventGroup:

<eventGroup name="JDBC"/>

extend the definition to

<eventGroup name="JDBC" level="trace" />

If the eventGroup is not present is should be added.

Logging will appear in the /logs/XQE folder named: xqelog--.xml