admin show_connection

Syntax

admin show_connection_profiles[, “match_string”]

Parameters

match_string – Filters the connection profiles displayed. Only those connection profiles whose names contain the string provided are displayed.

Examples

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

admin show_connection_profiles
go

Profile Name Version Comments
------------ -------- ---------------------------
rs_ase_to_db2 standard Standard ASE to DB2 replication
connection profile.
rs_ase_to_udb standard Standard ASE to UDB replication
connection profile.
rs_ase_to_oracle standard Standard ASE to Oracle replication
connection profile.
rs_ase_to_msss standard Standard ASE to Microsoft SQLServer
replication connection profile.
rs_ase_to_ase standard Standard ASE to ASE replication
connection profile.
rs_ase_to_iq standard Standard ASE to Sybase IQ
replication connection profile.
rs_ase_to_hanadb ech ASE to HanaDB replication connection
using Express Connector for HanaDB.
rs_db2_to_msss standard Standard DB2 to Microsoft SQLServer
replication connection profile.
rs_db2_to_oracle standard Standard DB2 to Oracle replication
connection profile.
rs_db2_to_udb standard Standard DB2 to UDB replication
connection profile.
rs_db2_to_ase standard Standard DB2 to ASE replication
connection profile.
rs_oracle_to_db2 standard Standard Oracle to DB2 replication
connection profile.
rs_oracle_to_udb standard Standard Oracle to UDB replication
connection profile.
rs_oracle_to_msss standard Standard Oracle to Microsoft
SQLServer replication connection
profile.
rs_oracle_to_ase standard Standard Oracle to ASE replication
connection profile.
rs_oracle_to_iq standard Standard Oracle to IQ replication
connection profile.
rs_oracle_to_hanadb ech Oracle to HanaDB replication connection
using Express Connector for HanaDB.
rs_msss_to_db2 standard Standard Microsoft SQLServer to DB2
replication connection profile.
rs_msss_to_oracle standard Standard Microsoft SQLServer to
Oracle replication connection profile.
rs_msss_to_udb standard Standard Microsoft SQL Server to
UDB replication connection profile.
rs_msss_to_ase standard Standard MicrosoftSQL Server to ASE
replication connection profile.
rs_msss_to_hanadb ech Microsoft SQLServer to HanaDB replication
connection using Express Connector for HanaDB.
rs_udb_to_db2 standard Standard udb to db2 replication
connection profile.
rs_udb_to_msss standard Standard UDB to Microsoft SQLServer
replication connection profile.
rs_udb_to_oracle standard Standard UDB to Oracle replication
connection profile.
rs_udb_to_ase standard Standard UDB to ASE replication
connection profile.
rs_udb_to_hanadb ech UDB to HanaDB replication connection
using Express Connector for HanaDB.
rs_db2_to_db2 standard Standard DB2 to DB2 replication
connection profile.
rs_oracle_to_oracle standard Standard Oracle to Oracle
replication connection profile.
rs_udb_to_udb standard Standard UDB to UDB replication
connection profile.
rs_msss_to_msss standard Standard Microsoft SQLServer to
Microsoft SQLServer replication
connection profile.
rs_ase_to_oracle eco ASE to Oracle replication connection
profile using Express Connect for Oracle.
rs_db2_to_oracle eco DB2 to Oracle replication connection
profile using Express Connect for Oracle.
rs_msss_to_oracle eco Microsoft SQLServer to Oracle replication
connection profile using Express Connect for Oracle
rs_oracle_to_oracle eco Oracle to Oracle replication connection
profile using Express Connect for Oracle.
rs_udb_to_oracle eco UDB to Oracle replication connection profile
using Express Connect for Oracle.
rs_rs_to_oracle_ra standard Standard RS to RA direct load
connection profile.
rs_rs_to_udb_ra standard Connection profile for replication from
IBM DB2 LUW (UDB) using Replication Agent
for direct load materialization.
rs_rs_to_msss_ra standard Connection profile for replication from
Microsoft SQL Server using Replication Agent
for direct load materialization.

(39 rows affected)

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

Profile Name Version Comments
---------------- -------- ---------------------------
rs_oracle_to_db2 standard Standard Oracle to DB2 replication
connection profile.
rs_oracle_to_udb standard Standard Oracle to UDB replication
connection profile.
rs_oracle_to_msss standard Standard Oracle to Microsoft SQLServer
replication connection profile.
rs_oracle_to_ase standard Standard Oracle to ASE replication
connection profile.
rs_oracle_to_iq standard Standard Oracle to IQ
replication connection profile.
rs_oracle_to_hanadb ech Oracle to HanaDB replication connection
using Express Connector for HanaDB.
rs_ase_to_oracle eco ASE to Oracle replication connection
profile using Express Connect for Oracle.
rs_db2_to_oracle eco DB2 to Oracle replication connection profile
using Express Connect for Oracle.
rs_msss_to_oracle eco Microsoft SQLServer to Oracle replication
connection profile using Express Connect
for Oracle.
rs_oracle_to_oracle eco Oracle to Oracle replication connection
profile using Express Connect for Oracle.
rs_udb_to_oracle eco UDB to Oracle replication connection profile
using Express Connect for Oracle.
rs_rs_to_oracle_ra standard Standard RS to RA direct load
connection profile.

Usage

When creating connections with the using profile option, use admin show_connection_profiles to determine the name and version of the available profiles.