LISTCONNECTIVITYTESTWARNINGS view

The DVSYS.LISTCONNECTIVITYTESTWARNINGS view lists the connectivity test logs associated with a specific diagnostics identifier (DiagId), which Data Virtualization generates during a connection error.

When Data Virtualization detects a connection error (i.e. when the connection pool status changes to unavailable), connectivity tests run automatically and the resulting logs are stored in the ConnectivityTest.log file on each qpagent. An error message then displays the unique diagnostic identifier (DiagId) that is associated with these logs.

This view allows you to retrieve all the logs generated by the following connectivity tests:
  • Ping: The Ping test verifies basic network reachability between the agent and the target host.
  • OpenSSL: The OpenSSL test validates secure communication by attempting a TLS/SSL handshake with the target host to confirm that certificates are valid, and that a secure channel can be established.
  • Traceroute: The Traceroute test helps pinpoint where packets might be delayed or dropped.
  • Netcat: The Netcat test confirms port-level connectivity by checking if the target host is reachable on the required port, helping detect issues such as closed ports and firewall blocks.
Note: The connectivity test feature is disabled by default. To enable this feature, set the configuration property CONNECTIVITY_TEST_ENABLE to true (the default value is false, which disables the feature):
call dvsys.setconfigproperty('CONNECTIVITY_TEST_ENABLE','true','',?,?)
Table 1. DVSYS.LISTCONNECTIVITYTESTWARNINGS
Column Type Description
NODE_NAME VARCHAR(80) Name of the node or agent where the warning was raised.
TSTAMP TIMESTAMP The timestamp of the last occurrence of the warning or exception.
DIAGID VARCHAR(20) A unique identifier for connectivity test diagnostics
WARNING VARCHAR(32672) The warning text.

Example

For example, a datasource is unavailable and the DiagId displayed is ee112cc5-951f-38:

select * from DVSYS.LISTCONNECTIVITYTESTWARNINGS where DiagId='ee112cc5-951f-38'