Identifying the head node host in IBM® Db2 Warehouse

Because you must run certain commands and perform certain task steps on the head node host, you might need to identify the head node host first.

Procedure

  1. Issue the following Docker or Podman command:
    docker exec -it Db2wh status
    podman exec -it Db2wh status
  2. In the IBM Db2 Warehouse Cluster Status section of the output, look for the head node.
    Sample output follows:
    root@node0101-fab - dashDB /]# status
    Getting IBM Db2 Warehouse status...
    -- IBM Db2 Warehouse Services Status --
    Redirecting to /bin/systemctl status  slapd.service
    SUMMARY
    LDAPrunning                   : SUCCESS
    dashDBtablesOnline            : SUCCESS
    WebConsole                    : SUCCESS
    DB2connectivity               : SUCCESS
    DB2running                    : SUCCESS
    Getting IBM Db2 Warehouse High Availability Status...
    -- IBM Db2 Warehouse System Manager Status --
    Overall status : RUNNING
    -- IBM Db2 Warehouse Cluster Status --
    +--------------+---------------+------+--------+
    |  Node name   |   IP Address  | Type | Status |
    +--------------+---------------+------+--------+
    | node0101-fab | 192.168.10.80 | Head | ACTIVE |
    | node0102-fab | 192.168.10.81 | Data | ACTIVE |
    | node0103-fab | 192.168.10.82 | Data | ACTIVE |
    | node0104-fab | 192.168.10.83 | Data | ACTIVE |
    | node0105-fab | 192.168.10.84 | Data | ACTIVE |
    | node0106-fab | 192.168.10.85 | Data | ACTIVE |
    +--------------+---------------+------+--------+
    [root@node0101-fab - dashDB /]#