LISTRDBC view
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). |
| 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. |