Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: alex_ on 05 Jun 2019 03:51:43 AM

Title: Which log file contains the generated SQL
Post by: alex_ on 05 Jun 2019 03:51:43 AM
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!

Title: Re: Which log file contains the generated SQL
Post by: MFGF on 05 Jun 2019 07:22:37 AM
Quote from: alex_ on 05 Jun 2019 03:51:43 AM
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.
Text only | Text with Images