How to enable Native Query Logging in Cognos 8.2
For Cognos Version 8.2
If you want to create audit reports that include the queries that are run against your reporting data source, you must enable native query logging. You can use native query logging to learn what kinds of information users want or whether a report is running efficiently.
Native query logging is part of Request level logging. However, if you are using audit reports, you can enable native query logging independently from Request level logging, as described in the following steps.
Steps for Each Service Associated with One Dispatcher
1. In Cognos Connection, in the upper-right corner, click Tools, Server Administration.
2. Click Dispatchers.
3. Click the Configure tab.
4. In the Actions column, click the set properties button for the dispatcher.
5. Click the Settings tab.
6. Find the service in the Name column and, from the Value menu, click the logging level.
7. If native query logging is available for the service and you want to use it, select the Audit Native Query check box.
8. Click OK.
Steps for Services of the Same Type Associated with Multiple Dispatchers
1. In Cognos Connection, in the upper-right corner, click Tools, Server Administration.
2. Click the Monitor tab.
3. Click Services.
4. In the Actions column, click the set properties button for the service.
5. Click the Settings tab.
6. From the Value menu, click the logging level.
7. If native query logging is available for the service and you want to use it, select the Audit Native Query check box.
8. Click OK.
If you want to create audit reports that include the queries that are run against your reporting data source, you must enable native query logging. You can use native query logging to learn what kinds of information users want or whether a report is running efficiently.
Native query logging is part of Request level logging. However, if you are using audit reports, you can enable native query logging independently from Request level logging, as described in the following steps.
Steps for Each Service Associated with One Dispatcher
1. In Cognos Connection, in the upper-right corner, click Tools, Server Administration.
2. Click Dispatchers.
3. Click the Configure tab.
4. In the Actions column, click the set properties button for the dispatcher.
5. Click the Settings tab.
6. Find the service in the Name column and, from the Value menu, click the logging level.
7. If native query logging is available for the service and you want to use it, select the Audit Native Query check box.
8. Click OK.
Steps for Services of the Same Type Associated with Multiple Dispatchers
1. In Cognos Connection, in the upper-right corner, click Tools, Server Administration.
2. Click the Monitor tab.
3. Click Services.
4. In the Actions column, click the set properties button for the service.
5. Click the Settings tab.
6. From the Value menu, click the logging level.
7. If native query logging is available for the service and you want to use it, select the Audit Native Query check box.
8. Click OK.
Hi Arul,
ReplyDeleteThanks for the information.It was really helpful.I have customized the report performance with few information like avg,min and max.Iam currently tracking performance of cognos reports.Is it possible to capture the filters/prompts used by the users in the audit page?If it is single user i can capture.For 100 users how do i capture?Iam using cognos 8.2 with SQL server database.
Thanks in advance,
Regards,
Shyam Krishnamurthi
Shyam,
ReplyDeleteCognos Audit database capture the SQL ran by the report. You can parse the SQL and capture filter values passed in the report.
Looks for COGIPF_NATIVEQUERY Tables in Audit DB.
-Arul