LISTNODES view

The DVSYS.LISTNODES view contains details about the nodes or agents that are currently connected to Data Virtualization.

Table 1. DVSYS.LISTNODES
Column Type Description
NODE_NAME VARCHAR(80) Name of the node or agent.
NODE_DESCRIPTION VARCHAR(128) Description of the node or agent.
AGENT_CLASS VARCHAR(20) Indicates whether the agent is internal or a remote connector. Possible values are F, H (both identifying internal agents), and R (remote connectors).
HOSTNAME VARCHAR(2000) Host name of the node or agent.
PORT INTEGER Port number of the node or agent.
OS_USER VARCHAR(128) Username that is associated with this node or agent.
IS_DOCKER CHAR(1) Flag indicating whether it is a docker.
DS_COUNT INTEGER Indicates the number of data sources that are present on this node or agent.