Login to Kyvos Manager and navigate to Properties > queryengine.properties
In the queryengine.properties, search for the DS_CONNECTION_CONF property
The default value will be Blank
Set this value as SET memory_limit='10GB'; SET THREADS to 1; and then save it.
Restart the Query Engine services from the Kyvos Manager dashboard.
For memory configuration, perform the following post-deployment steps.
Open the Kyvos Java options page in Kyvos Manager and Navigate to the Query Engine section.
If Configure Heap memory for Query Engine is set as Auto, no change is required.
If Configure Heap memory for Query Engine is set as Manual, reduce Off-Heap memory by 10 GB. For Example, Suppose the total machine memory is 128 GB, whereas 45 GB is assigned to Heap, and 66 GB is assigned to Off-Heap. In that case, you need to set Heap as 45 GB and Off-Heap as 56 GB so Kyvos can use the remaining 10 GB internally for the new data store-based architecture.
Before enabling Kyvos Analytical Store, ensure that Query Engine cluster is running with the required (Full, high, moderate, or Low) capacity. For more details about cluster scaling, see the Managing system scheduling and capacity section.
Login to Kyvos Manager and navigate to Properties > global.properties
To enable this feature, set the value of the ENABLE_KYVOS_ANALYTICAL_STORE property to 'Yes.' After configuring the Kyvos Data Store value, you must disable cluster scaling. Achieve this by setting the ELASTIC_DEPLOYMENT property to 'Disable.
Restart all Kyvos services (BI Server, Query Engine, and Kyvos Web Portal) from the Kyvos Manager dashboard.