An administrator is creating a datasource for an IBM Cognos PowerCube. On the datasource creation page, the ‘Configure JDBC connection’ check box is…

The option to 'Configure JDBC connection' for an IBM Cognos PowerCube data source is available only when using the Dynamic Query Mode (DQM). DQM is a Java-based query engine that runs exclusively in a 64-bit process. If the dispatcher's execution mode is set to 32-bit, it operates in Compatible Query Mode (CQM), which uses native client libraries to connect to PowerCubes, not JDBC. Therefore, the JDBC configuration option is unavailable (grayed out) when the dispatcher is not configured for 64-bit execution.

A. The IBM Cognos PowerCube is not optimized.

PowerCube optimization is a performance-tuning activity within the Transformer tool and does not affect the available connection types in Cognos Administration.

C. The execution mode for the environment is not set to 64 bit.

This is too general. The critical setting is the execution mode of the specific dispatcher service handling queries, not a global environment setting.

D. JDBC connection is not supported for IBM Cognos PowerCube.

This is incorrect. JDBC connections are supported for PowerCubes, but this functionality is dependent on using the 64-bit Dynamic Query Mode.

1. IBM Cognos Business Intelligence Dynamic Query Guide 10.2.2, Chapter 1: Dynamic query mode, Section: "Overview of the dynamic query mode".

This section states, "The dynamic query mode is a Java-based query execution environment that offers query execution on OLAP data sources... The dynamic query mode runs in a 64-bit process." This establishes the link between DQM, Java (implying JDBC), and the 64-bit requirement.

2. IBM Cognos Business Intelligence Administration and Security Guide 10.2.2, Chapter 15: Servers and Dispatchers, Section: "Set the query mode for a dispatcher".

This section details the procedure for changing the dispatcher setting: "You can run dispatchers in 32-bit or 64-bit mode... The 64-bit mode is required to run the dynamic query mode." This directly confirms that the 64-bit dispatcher mode is a prerequisite for DQM.

3. IBM Cognos Analytics 11.0 Knowledge Center, Section: "Data sources", Subsection: "IBM Cognos PowerCube".

In the documentation for creating a PowerCube data source, it specifies the requirement for a JDBC connection type: "To use a PowerCube as a data source for the dynamic query mode, you must create the data source connection in IBM Cognos Administration... Select the Configure JDBC connection check box." This confirms that JDBC is the connection method for PowerCubes in DQM, and its availability is tied to the mode enabled by the 64-bit dispatcher.