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_CPFS_OPS} -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_INSTANCE}

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.