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. |