Command to List Available Connection Profiles

Use the admin show_connection_profiles command to list the profile name, version, and comments for each profile defined in Replication Server.

There is a connection profile for each primary and replicate database combination, such as Adaptive Server and Oracle, Oracle and Adaptive Server, and IBM DB2 and /Microsoft SQL Server, and so on.

See “admin show_connection_profiles,” in Chapter 3, “Replication Server Commands” in the Replication Server Reference Manual for more information about admin show_connection_profiles and the list of connection profiles.

Syntax

admin show_connection_profiles[, “match_string”]

Parameters

match_string – use the match_string option to display only the connection profiles whose names contain the string you provide in the option.

Examples

Example 1 – lists the names of all connection profiles currently defined in Replication Server:

admin show_connection_profiles
go

Extract of output is:

Profile Name              Version     Comments
------------              -------     --------
rs_ase_to_db2             Standard    Standard ASE to DB2 replication
                                      connection profile.
rs_ase_to_udb             Standard    Standard ASE to DB2 replication
                                      connection profile.
...
rs_db2_to_ase             Standard    Standard DB2 to ASE replication
                                      connection profile.
rs_db2_to_msss            Standard    Standard DB2 to Microsoft SQLServer
                                      connection profile.
...

Example 2 – lists the names of all connection profiles currently defined in Replication Server that have the string “oracle” in the connection profile name:

admin show_connection_profiles, “oracle”
go

Output is:

Profile Name              Version     Comments
------------              -------     --------
rs_ase_to_oracle          Standard    Standard ASE to Oracle replication
                                      connection profile.