The CREATE REMOTE SERVER statement creates back-end login information in the SYS_SERVER system table for SQL passthrough purposes in Universal Cache.
The CREATE OR REPLACE REMOTE SERVER statement modifies login information in the SYS_SERVER system table, overwriting an existing entry.
In most cases, the IBMInfoSphere® CDC technology is used for transferring backend login data to the frontend. When mirroring or a refresh is started on the first subscription from solidDB® server to the backend data server, the IBM InfoSphere CDC for solidDB® instance retrieves the login data from the backend IBM InfoSphere CDC instance and stores it in the solidDB® system table SYS_SERVER with the statement CREATE REMOTE SERVER. The password stored in the SYS_SERVER table is hidden.
The IBM InfoSphere CDC technology does not transfer the backend login data in the cases described below.
▪If the IBM InfoSphere CDC instance for the backend is running under a user ID that automatically has access to the database, the login data does not need to be stored.
▪If the backend data server is DB2® for z/OS® or DB2 for iSeries®, the login data cannot be fetched. To avoid errors, you need to set the IBM InfoSphere CDC for solidDB® system parameter retrieve_credentials to FALSE.
▪If you have upgraded your IBM InfoSphere CDC for solidDB® installation andsubscription from V6.3, the 6.3 version of IBM InfoSphere CDC for solidDB® has not stored the backend login data in the SYS_SERVER table.
In the latter two cases, use the CREATE REMOTE SERVER (or ALTER REMOTE SERVER) statement to define the login data manually.
By default, username and password are stored in uppercase letters. To retain case sensitivity, enter the username and password in single quotation marks.
Examples
CREATE REMOTE SERVER USERNAME dba PASSWORD dba
CREATE REMOTE SERVER USERNAME ’AdMin’ PASSWORD ’PwD123’
CREATE OR REPLACE REMOTE SERVER USERNAME dba PASSWORD ’PwD123’