Reintegrating a failed data node into an IBM® Db2 Warehouse MPP cluster

You must perform some manual steps to have a failed data node rejoin its cluster.

About this task

To perform this task, you need to have root authority.

Procedure

  1. Address whatever issue caused the node host failure.
  2. Start the Db2® Warehouse container on the node you want to rejoin to the cluster.
    docker start Db2wh
  3. On the head node, stop the Db2 Warehouse services for the cluster.
    docker exec –it Db2wh stop
  4. On the head node, start the Db2 Warehouse services.
    docker exec –it Db2wh start
    The cluster should come up with the same topology as before the data node failure, with the data partitions distributed across all nodes.