IBM Support

How to enable native database trace with Cognos CQM connections in Cognos Analytics 11

Troubleshooting


Problem

How to trace Compatible Query Mode connection to analyze SQL sent to database.

Resolving The Problem

Trace can be enabled in the <install_path>/bin/cogdm*.ini files. Open these files and refer to the header information to information on what type of database they are used for.

The trace should only be enabled for troubleshooting a single query issue and not appropriate for use in a scenario with multiple reports or queries are being executed or for an extended period of time.

Example of setting up a trace for a native Oracle connection.

Steps:
1. In the <install_path>/bin directory, create a backup of the cogdmor.ini file.
2. In the <install_path>/bin directory, open the cogdmor.ini file in a text editor

NOTE: Ensure that your chosen editor does not alter the encoding of the file, or the product may not operate correctly.

3. Add the following lines to the bottom of the file:

[Trace]
Output=c:\temp\oracle_trace.txt
Flags=1111111111

For performance issues you can also add the timer=yes option.

4. Save the file.
5. Perform the test and review the file.
6. Disable the trace by removing the entries or commenting the lines with a semi-colon, and saving the file.

NOTE: This trace does not capture queries for Dynamic Query Mode (DQM) data sources.

Related Information

Cognos BI Equivalent

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Administration and Configuration v11x","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 October 2022

UID

swg22001201

Page Feedback