Enabling an appliance node

When a node was disabled manually for some service work, you must also manually enable the node when the work is finished.

Before you begin

  1. Only healthy nodes can be enabled.
  2. It is not possible to enable a node when the appliance application is starting, stopping, or recovering.

Procedure

  • Use the web console. Click Monitor > System. Select the node in the graphical overview. Details for the node are displayed. Click Enable in the right top corner.
  • Use the ap node enable hadomainX.nodeY command, where X is the HA domain number, and Y is the node number in that HA domain.

What to do next

After the node is enabled, it is not used until Db2 Warehouse is restarted and MLNs are rebalanced. You can also use the ap node rebalance command to rebalance MLNs manually. Note that this results in a few minutes long outage in access to Db2 Warehouse. To view MLN-to-node assignment, you can use the ap ds command:
ap ds
+------------+--------------+--------------+--------+
| Data slice |     Node     | Logical Port | Status |
+------------+--------------+--------------+--------+
|          0 | node0101-fab |            0 |   UP   |
|          1 | node0101-fab |            1 |   UP   |
|          2 | node0101-fab |            2 |   UP   |
|          3 | node0102-fab |            0 |   UP   |
|          4 | node0102-fab |            1 |   UP   |
|          5 | node0102-fab |            2 |   UP   |
|          6 | node0102-fab |            3 |   UP   |
|          7 | node0103-fab |            0 |   UP   |
|          8 | node0103-fab |            1 |   UP   |
|          9 | node0103-fab |            2 |   UP   |
|         10 | node0103-fab |            3 |   UP   |
+------------+--------------+--------------+--------+

Generated: 2018-07-27 08:52:20
.