IBM Support

How to configure the JVM heap size within Cognos Administration for the Query Service to run Dynamic Cubes in Cognos Analytics 11.

Question & Answer


Question

What is the method for adjusting the JVM heap size in Cognos Administration within the Query Service settings of Cognos Analytics 11 so that Dynamic Cubes can be run correctly? If the JVM heap size is not correctly configured then the Dynamic Cube will not run.

Answer

Steps to adjust the JVM heap size are as follows:

1. From the Welcome page, select the Manage tab and click Administration Console.

2. Click on the System tab and select the arrow to the right of All servers. Hover over the Services option and click Query.

3. Against your running ‘QueryService’, click Set properties.

4. Under the Settings tab, identify the tuning options and adjust the following values:

Initial JVM heap size for the query service (MB) (Requires QueryService restart): an ideal value to enable the initial size is 4 GB.

JVM heap size limit for the query service (MB) (Requires QueryService restart): an ideal value to enable the maximum or size limit is 16 GB.

5. Ensure that you restart the QueryService which you just adjusted the JVM heap size for so the changes can be implemented.

[{"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":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21994642

Page Feedback