Stopping IBM® Db2 Warehouse

In a Db2 Warehouse deployment, you stop two things from the command line: the Db2 Warehouse container and the Db2 Warehouse services.

About this task

To perform this task, you require root authority.

Procedure

Use one of the following approaches:
  • If you did not use Db2 Warehouse Orchestrator for the deployment, perform the following steps:
    1. Stop the Db2 Warehouse services by issuing the following Docker or Podman command. In an MPP deployment, issue the command on the head node.
      docker exec –it Db2wh stop
      podmn exec –it Db2wh stop
    2. Stop the Db2 Warehouse container by issuing the following Docker or Podman command:
      docker stop Db2wh
      podman stop Db2wh
  • If you used Db2 Warehouse Orchestrator for the deployment, stop both the Db2 Warehouse services and the Db2 Warehouse containers on all nodes in the cluster by running the db2wh_orchestrator.sh script on the head node:
    path_to_scripts/db2wh_orchestrator.sh --file /mnt/clusterfs/nodes --stop