Which log file contains the generated SQL

[alex_]

Hi,

as remember correctly, when you run some report the Cognos write in log file the executed SQL.
Where is located this log file?

In cognosserver.log missing the generated SQL.

Thanks and regards!

[MFGF]

Hi,

as remember correctly, when you run some report the Cognos write in log file the executed SQL.
Where is located this log file?

In cognosserver.log missing the generated SQL.

Thanks and regards!

Hi,

You would normally use an audit database to collect this kind of information. Have you enabled audit logging in your instance? Are you using Dynamic Query Mode or Compatible Query Mode? The logging level needs to be set appropriately for either the Query Service (DQM) or the Report Service / Batch Report Service (CQE).

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cra.doc/c_logginglevels.html

Cheers!

MF.