MTQ

Sets the maximum number of threads per TM1® query.

Parameter type: optional, dynamic

To specify a maximum number of threads to use when processing queries, add the following line to Tm1s.cfg:

MTQ=n

where n represents the number of threads to be used for a single query.

Alternatively, use MTQ=All (case insensitive), which sets the value to the maximum number of cores available on a server. The result is a dynamic system setting that consumes all cores.

If you set MTQ equal to a negative number, that is, MTQ=-N, the number of threads that will be used is defined by the following equation: T=M-N+1, where T= the number of threads to be used by the system and M= the number of threads on the server.

For example, if your server has 64 cores and you set MTQ=-10, the system will use 55 cores.

T=64-(10)+1

If you set MTQ=1 or MTQ=0, multi-threaded query execution is turned off.

For more information, see "Multi-Threaded Queries" in the IBM® Cognos® TM1 Operation Guide.

MTQ is turned off by default.

Note: Multi-threaded queries can improve performance on numeric cubes, where consolidation is optimized. As TM1 does not consolidate string values, the MTQ parameter has no impact on the performance of string cubes.