How To
Summary
As a post-installation or post-upgrade task for Watson Knowledge Catalog, you must update the indexes in the XMETA database to ensure good performance of SQL queries.
Objective
Update the indexes in the XMETA database to ensure good performance of SQL queries after you install Watson Knowledge Catalog.
Environment
Watson Knowledge Catalog version 4.0.1: complete this procedure when you install 4.0.1 version.
Watson Knowledge Catalog version 4.0.2, and later: complete this procedure when you upgrade to 4.0.2 and later versions from an earlier release.
Steps
- Copy the scripts from the attached ZIP file to the c-db2oltp-iis-db2u-0 pod:
oc cp dq_manage_indices.sh c-db2oltp-iis-db2u-0:/tmp/dq_manage_indices.sh oc cp dq_create_indices.sql c-db2oltp-iis-db2u-0:/tmp/dq_create_indices.sql oc cp dq_drop_indices.sql c-db2oltp-iis-db2u-0:/tmp/dq_drop_indices.sql
- Log on to the Db2U pod:
oc rsh c-db2oltp-iis-db2u-0 bash
- Change to the /tmp directory:
cd /tmp/
- Change the permissions of the script files:
chmod 755 dq*.*
- Run the script to the update the indexes in the XMETA database:
./dq_manage_indices.sh
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHGYS","label":"IBM Cloud Pak for Data"},"ARM Category":[{"code":"a8m50000000ClUuAAK","label":"Installation"}],"ARM Case Number":"","Platform":[{"code":"PF040","label":"Red Hat OpenShift"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
18 January 2022
UID
ibm16481667