Using the OpenShift must-gather utility for Db2 Warehouse

You can gather data about the Red Hat® OpenShift cluster where your Db2 Warehouse service runs, as well as database-specific information, by using the OpenShift must-gather utility.

About this task

When opening a support case, it is helpful to provide debugging information about your cluster. The must-gather utility collects data at the cluster level about pods, custom resources, persistent volumes, and logs, and also runs Db2 Warehouse scripts to gather logs that are specific to a database deployment.

Procedure

  1. Use the following command to retrieve the must-gather image from an OpenShift cluster where Db2 Warehouse is installed: 
    MUST_GATHER_IMAGE=$(oc get cm db2u-release -n ${PROJECT_CPD_INST_OPERATORS} -o=jsonpath='{.data.json}' | jq '.databases.db2u."app_version".images.mustgather')

    where app_version is the installed version of Db2 Warehouse, for example 11.5.6.0-cn5.

  2. Use the following command to create a must-gather deployment: 
    oc adm must-gather --image $MUST_GATHER_IMAGE -- gather -n ${PROJECT_CPD_INST_OPERANDS}

What to do next

For details on using the must-gather utility, see Gathering data about your cluster in the OpenShift documentation.

You can view all of the available options for the utility by running this command:

oc adm must-gather --image $MUST_GATHER_IMAGE -- gather -h

The utility creates a local directory to store the data that it collects.