LISTRBDCDETAILS view
The DVSYS.LISTRBDCDETAILS view contains the status of all connection pools including internal nodes connected to Data Virtualization.
| Column | Type | Description |
|---|---|---|
| NODE_NAME | VARCHAR(80) | Name of the node or agent which hosts the data source connection. |
| CID | VARCHAR(80) | Connection identifier of the data source. |
| CNODEID | VARCHAR(80) | The node name for inter-agent connections, which might be truncated, or NULL for data source connections. |
| CPOOLSIZE | INTEGER | The pool size number of connections in pool. |
| CPOOLALL | INTEGER | The pool size including connections in use. |
| CSTATUS | VARCHAR(20) | The status including AVAILABLE, UNAVAILABLE, or INACTIVE. |
| CDRIVER | VARCHAR(80) | The driver class. |
| CURL | VARCHAR(2000) | The connection URL. |
| CUSR | VARCHAR(128) | The connection user. |
| DIAGID | VARCHAR(20) | A unique identifier for connectivity test diagnostics. If a connection issue occurs, connectivity tests are run and logs are stored in the ConnectivityTest.log file on each qpagent. An error message displays the unique DiagId associated with these logs. To retrieve log details, enable DVSYS.LISTCONNECTIVITYTESTWARNINGS. |