Transforms the Replication Server into a gateway to its RSSD, ID server, to a remote Replication Server, or to a remote data server.
connect [to] [rssd | idserver | <srv_name> | <ds_name>.<db_name>]
Turns Replication Server into a gateway to its RSSD. Allows the gateway to use <RSSD_primary_user> and <RSSD_primary_pw> entries in its configuration file. rssd is the default connect to option.
Turns Replication Server into a gateway to its ID server, providing that the Replication Server itself is not the ID server. Allows the gateway to use <ID_user> and <ID_pw> entries in the configuration file.
The name of the remote Replication Server you want the gateway to connect to. Gateway uses RSI to log into the remote server, and requires a direct route to the remote server.
The name of the remote data server and database that you want the gateway to connect to. The Replication Server gateway uses the maintenance user to log into the remote data server. This allows you to perform tasks that maintenance users of the designated database are permitted to do. However, you cannot access the other databases defined in the data server you connected to.
Replication Server gateway can directly connect to Adaptive Server, and to SAP IQ as well as replicate servers that are supported by Enterprise Connect Data Access (ECDA). You cannot use Replication Server gateway to connect to replicate servers when using one of the ExpressConnect products to communicate with those servers.
isql -Usa -P -S ost_replinuxvm_02 connect to go
Gateway connection to 'ost_replinuxvm_01.emb' is created.
show server go
isql -Usa -P -S ost_replinuxvm_02 connect to ost_replinuxvm_03 go
show server go
isql -Usa -P -S ost_replinuxvm_02 connect to ost_replinuxvm_01.pdb1 go
Gateway connection to 'ost_replinuxvm_01.pdb1' is created.
select db_name() go
------------------------------ pdb1 (1 row affected)
Issuing the connect command requires an sa role for the first log in to Replication Server.
Issuing the connect command without specifying an option creates a gateway connection to the RSSD.
When acting as a gateway, Replication Server uses your RSSD primary user name and password to log in to RSSD, your ID server user name and password to log in to ID Server, and your Remote Server Identification (RSI) to log in to a remote Replication Server. You do not need to supply this information more than once, when you access Replication Server itself.
Cascaded connections created in the gateway are kept in a connection stack, with the Replication Server that issued the first connect command placed at the bottom of the stack.
Replication Server cannot directly connect to itself. However, you can work around this by using a cascading connection.
When using Replication Server Gateway, the client and the server must use the same locale set because Replication Server cannot perform character set conversion.
Transforming the Replication Server into a gateway requires “sa” permission.