Query service advanced settings

This section describes advanced settings for the query service. This service supports the dynamic query mode.

qsMaxCrossjoinInteractiveOrderOfMagnitude

Specifies the order of magnitude of the maximum number of cells for an interactive query, for example, a dashboard or an exploration.

The default value is 5, which allows visualizations with 100000 cell values. This setting prevents the query service from attempting to load an excessive number of cells that could cause the query execution to time out. It also prevents the query service from running out of recurses and crashing.

Note: If a visualization exceeds the maximum allowable number of cells, the following error message appears:

Error XQE-MDX-0020 - The query: query_name requires more resources than allowed. The estimated number of cells nnnnnn exceeds the allowable value of 100000. Apply filtering to projected sets to reduce the number of cells.

In this case, the user should filter the sets before projecting them.

Data type:
Integer
Default:
5

qs.queryExecution.flintServer.loadingPolicy

Specifies the loading policy for the Compute service. This service can be started when the query service starts, or be deferred until a query that requires the Compute service is needed.

If a Cognos Application tier server uses a large percentage of available RAM and there is no workload that uses uploaded files or data sets, delaying the process until the server starts provides a small memory saving.

The following values can be used:
  • eager - the Compute service starts when the query service starts.
  • lazy - the Compute service is deferred until a query that requires this co-process is needed.
Data type:
String
Default:
eager

qs.queryExecution.flintServer.maxHeap

Specifies the maximum amount of memory that the Compute service is allowed to use.

The value can be 4096 (default), or a positive integer greater than 4096. Using a higher value might be required when workloads need more memory to complete.

Data type:
Positive integer
Default:
4096

qs.queryExecution.flintServer.minHeap

The minimum amount of memory that the Compute service is allowed to use.

The value can be 1024 (default), or a positive integer greater than 1024.

Data type:
Positive integer
Default:
1024

qs.queryExecution.flintServer.sparkThreads

Specifies the maximum number of threads that the Compute service can use to service queries.

The specified value must be a positive integer greater than 1.

Data type:
Positive integer

qs.queryExecution.flintServer.extraJavaOptions

Specifies additional parameters that can be passed to the Compute service.

Data type:
String