LISTRDBC view
The DVSYS.LISTRDBC view contains connection details for data sources that are currently connected to Watson Query.
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). |