Last updated: Nov 26, 2024
The DVSYS.LISTRDBC view contains connection details for data sources that are currently connected to Data Virtualization.
| Column | Type | Description |
|---|---|---|
| NODE_NAME | VARCHAR(80) | Name of the node or agent to which the data source is connected. |
| CID | VARCHAR(80) | Connection ID of the data source. |
| DRIVER | VARCHAR(80) | Driver class of the data source. |
| URL | VARCHAR(2000) | Connection URI of the data source. |
| USR | VARCHAR(128) | Username used to connect to the data source. |
| SRCTYPE | VARCHAR(20) | Source type of the data source. |
| SRCHOSTNAME | VARCHAR(128) | Host name of the data source. |
| SRCPORT | INTEGER | Port number used to connect to the data source. |
| DBNAME | VARCHAR(128) | Database name used to connect to the data source. |
| IS_DOCKER | CHAR(1) | Flag indicating whether it is a docker. |
| CPOOLSIZE | INTEGER | Current size of the connection pool. |
| CPOOLALL | INTEGER | Total available connection pool size. |
| CSTATUS | VARCHAR(20) | Status of the connection (AVAILABLE, UNAVAILABLE, or INACTIVE). |