SQL Guide : Database system tables and system views : System tables : SYS_SERVER
  
SYS_SERVER
The SYS_SERVER table contains the back-end server login data for SQL passthrough use with the Universal Cache capability.
When the first subscription between solidDB® and the back-end is created, the IBM InfoSphere CDC for solidDB® instance retrieves the backend data server login data from the backend IBM InfoSphere CDC instance, and then stores it in a solidDB® system table SYS_SERVER with a CREATE REMOTE SERVER statement.
Column name
Data type
Description
NAME
VARCHAR
Name of the back-end server
DRIVER
VARCHAR
Not used
CONNECT
VARCHAR
Not used
UID
VARCHAR
Username to use when connecting to the back-end server
PWD
VARCHAR
Password to use when connecting to the back-end server.
Note The password data is hidden.
See also
System tables