MTQ

Sets the maximum number of threads per single-user connection, when multi-threaded optimization is applied. Used when processing queries, and in batch feeder and cube load operations.

Parameter type: optional, dynamic

Default value: -1

To specify a maximum number of threads for the multi-threaded optimization, add the following line to the Planning Analytics database configuration:

MTQ=n

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

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 database has 64 cores and you set MTQ=-10, the system will use 55 threads.

T=64-(10)+1

By default, MTQ=-1, which sets the value to the maximum number of threads available to a database. The result is a dynamic system setting that consumes all threads.

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

For more information, see Improving processing performance with Multi-threaded Queries in TM1® Operations.

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