IBM Support

Memory Guidelines for Dynamic Query Mode

Technote (troubleshooting)


This document provides general recommendations for the amount of memory that should be allocated for the Java Virtual Machine (JVM) heap associated with dynamic query mode (DQM).

Resolving the problem

Although the dynamic query mode (DQM) is supported in 32 bit installations of IBM Cognos BI servers, 64 bit servers are recommended for DQM.
The initial size and size limit of the JVM heap for DQM can be set in Cognos Administration on the Settings tab of the QueryService (steps). By default each of these are set to 1 GB.

In production environments where Cognos dynamic cubes are not employed, it is recommended to set the initial heap size to 4 GB and the limit to 8 GB (a 64 bit server is required for memory settings above 2GB), and then monitor system resource usage during peak hours and adjust the settings accordingly.

For a server that is operating one or more Cognos dynamic cubes, the size limit of the query service should be set in accordance to the Dynamic Cubes hardware sizing recommendations.

For Cognos Analytics please use the following technote:

Related information

Query Service Properties - IBM Knowledge Center
IBM Cognos Dynamic Query Redbook
Cognos Dynamic Cubes Redbook

Document information

More support for: Cognos Business Intelligence

Software version: 10.1.1, 10.2, 10.2.1, 10.2.2

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Software edition: All Editions

Reference #: 1587457

Modified date: 09 March 2017