28.3 Examples
These examples display the status of each HADB server in a multi-node configuration.
- Example 1 (HADB servers are running on all nodes)
-
adbls -d node NODE_NO NODE_TYPE SVID IP-ADDRESS STATUS START_TIME 1 MASTER 22602 (XX.XXX.XX.14 ) ACTIVE 2014-12-05 18:03:22 2 SLAVE 16226 (XX.XXX.XX.16 ) ACTIVE 2014-12-05 18:03:13 3 SLAVE 7749 (XX.XXX.XX.6 ) ACTIVE 2014-12-05 18:03:19
- Example 2 (one node has been disconnected from the multi-node configuration)
-
adbls -d node NODE_NO NODE_TYPE SVID IP-ADDRESS STATUS START_TIME 1 MASTER (XX.XXX.XX.14 ) ABORT 2 MASTER 16226 (XX.XXX.XX.16 ) ACTIVE 2014-12-05 18:03:13 3 SLAVE 7749 (XX.XXX.XX.6 ) ACTIVE 2014-12-05 18:03:19
In this example, the HADB server on node number 1 terminated abnormally and has been disconnected from the multi-node configuration.
- Note
-
If the adbls -d node command is executed on a node that has been disconnected from the multi-node configuration, different information is output on the disconnected node (the status of each node immediately before the node was disconnected).
Explanation of the output items
- NODE_NO
-
Displays the node number of the HADB server.
- NODE_TYPE
-
Displays the HADB server's node type:
-
MASTER: Master node
-
SLAVE: Slave node
If the STATUS column displays ABORT, the NODE_TYPE column displays the node type immediately before the HADB server terminated abnormally. Therefore, MASTER might be output more than once to the NODE_TYPE column.
-
- SVID
-
Displays the process ID of the HADB server.
If the HADB server is stopped, nothing is displayed.
- IP-ADDRESS
-
Displays the IP address of the HADB server.
This is the IP address for the host name specified in the adb_sys_multi_node_info operand in the server definition.
- STATUS
-
Displays the status of the HADB server:
-
ACTIVE: Running
-
STOP: Stopped
-
ABORT: Terminated abnormally
-
- START_TIME
-
Displays the time the HADB server started.
If the HADB server is stopped, nothing is displayed.