Using the db2support tool in Db2 Warehouse

You can run a command to gather information about your Db2 Warehouse environment to be used by IBM® Support.

About this task

Output from the db2support tool is now shared with the IBM Software Hub diagnostics tool, so that you can more easily gather Db2 Warehouse-specific diagnostics to resolve issues. You can still manually generate and share data from the db2support tool, if needed.

Procedure

  1. Exec into the Db2 Warehouse pod with catalog partition.
  2. Become the Db2 Warehouse instance owner:
    su - ${DB2INSTANCE}
  3. Run the db2support tool:
    db2support

    The resulting db2support.zip file is saved in the current directory, /mnt/blumeta0/home/db2inst1.

  4. Create a db2support directory and store the db2support.zip file in the directory:
    mkdir /mnt/blumeta0/home/db2inst1/db2support
    mv db2support.zip /mnt/blumeta0/home/db2inst1/db2support
  5. Exit the pod and copy the db2support.zip file from the Db2 Warehouse pod directory to the current directory:
    oc cp c-db2wh-1611278932361-db2u-0:/mnt/blumeta0/home/db2inst1/db2support .