An administrator must troubleshoot query execution related issues in a DQM executed report. How is this achieved?

To troubleshoot Dynamic Query Mode (DQM) execution, an administrator must enable tracing for the QueryService. This is a dynamic, run-time task performed through the IBM Cognos Administration portal. By navigating to the properties of the QueryService for a specific dispatcher, an administrator can enable the "Query execution trace" setting. This action captures detailed diagnostic information about query planning and execution without requiring a service restart, which is ideal for troubleshooting live environments. The resulting trace logs are generated in the [installlocation]/logs/XQE directory.

A. Tracing imposes significant performance overhead and is therefore disabled by default in production systems to ensure optimal performance.

B. IBM Cognos Configuration is used for initial setup and static, service-level startup parameters (e.g., memory allocation), not for dynamic, run-time diagnostic tracing.

D. While qfsconfig.xml can be used for advanced DQM configuration, this method is for persistent settings and requires a service restart, making it less suitable for temporary, on-the-fly troubleshooting.

1. IBM Cognos Analytics 11.0.x Documentation, Administration and Security Guide, Chapter: "Logging", Section: "Query service logging": This section details the procedure for configuring logging for the query service. It states, "You can configure logging for the query service... Use IBM Cognos Administration to configure logging." This confirms that the administration portal is the correct tool.

2. IBM Cognos Analytics Dynamic Query Cookbook, Version 10.2.2, Page 10, Section: "DQM Server Logging and Tracing": This document explicitly describes the two methods for enabling tracing. It states, "The settings can be changed dynamically using Cognos Administration... Changes made in Cognos Administration are lost when the service is restarted." This highlights the use of the Administration portal (Option C) for temporary, dynamic troubleshooting, contrasting it with the persistent XML method (Option D).

3. IBM Cognos Analytics 11.0.x Documentation, Managing Guide, Chapter: "Manage servers and services", Section: "Set properties for a dispatcher or service": This guide provides the step-by-step instructions for navigating the Administration portal to modify service properties, which is the process described in the correct answer. The path involves selecting the Configuration tab, then Dispatchers and Services, locating the specific dispatcher, and then accessing the properties for the QueryService.