0 / 0
LISTRDBC view in Data Virtualization

LISTRDBC view

The DVSYS.LISTRDBC view contains connection details for data sources that are currently connected to Data Virtualization.

Table 1. DVSYS.LISTRDBC
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).
Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more