Disabling Query History Monitoring and Management (QHMM)

Query History Monitoring and Management (QHMM) is a service that stores and manages the diagnostic data such as query history and query event-related information of the Presto engine in the MinIO bucket wxd-system.

You can disable the QHMM service in watsonx.data from the watsonx.data console page or by using command line. This topic guides you through the steps to disable QHMM by using command line. For more information about disabling QHMM from watsonx.data console page, see Query monitoring.

watsonx.data on IBM Software Hub

AWS

Procedure

Log in to the Red Hat OpenShift cluster by using one of the following options:
1. Run the following command to log in to the cluster by providing a username and password:
```
ibm-lakehouse-manage login-to-ocp \
--user=${OCP_USERNAME} \
--password=${OCP_PASSWORD} \
--server=${OCP_URL}
```
2. Run the following command to log in to the cluster by providing a token:
```
ibm-lakehouse-manage login-to-ocp \
--server=${OCP_URL} \
--token=${OCP_TOKEN}
```
Set the project by using the following command:
```
oc project <PROJECT_CPD_INST_OPERANDS>
```
Run the following command to list the config maps related to Presto.
```
oc get cm |grep presto-config-cm
```
Run the following command to disable QHMM. Replace the <engine-id> with the ID of the engine in which you want to disable the QHMM.
```
oc edit ibm-lh-lakehouse-<engine-id>-presto-config-cm
```
Ensure that the value of ENABLE_QHMM flag is changed to false and save the configuration map.
Delete the Presto coordinator or worker pod to apply the updated environment configuration.
```
oc delete pod <presto Coordinator/worker pod name>
```