replace connection

Syntax

replace connection connection_name 
set type [{to|=}] {ASE | ASE_CLUSTER | RSSD | IQ | MSSQL | Oracle | HANADB | UDB}
and set agent [{to|=}]agent_name 
and set host  [{to|=}] host 
and set port [{to|=}] port
and set database [{to|=}] database_name
and set user [{to|=}] user
[and set password [{to|=}] password]
[and set desc [{to|=}] description]
[with node set host [{to|=}] host and set port [{to|=}] port
[and node set host [{to|=}] host 
and set port [{to|=}] port]…]
[with properties set property_name [{to|=}] property_value
[and set property_name [{to|=}] property_value ]…]

Parameters

• connection_name – the name of the connection to be replaced.

• type – the connection type supported by Replication Server Data Assurance Option.
  Each DA connection configuration object has a type parameter:

  • ASE – for an SAP Adaptive Server database connection.

  • ASE_CLUSTER– for an SAP Adaptive Server Cluster database connection.

  • RSSD – for an SAP Replication Server System Database (RSSD) connection.

  • IQ – for an SAP IQ database connection.

  • ORACLE– for an Oracle database connection.

  • HANADB – for an SAP HANA database connection.

  • MSSQL – for a Microsoft SQL Server database connection.

  • UDB – for an IBM DB2 Universal Database (UDB) connection.

  Note: Configure the JDBC drivers before creating IBM DB2 UDB, Microsoft SQL Server, Oracle or SAP HANA database connections. type is case-insensitive.

  You cannot set the host name and port number for an ASE_CLUSTER connection; you must set these values inside a node definition. agent_name is invalid, if the connection type is Replication Server System Database (RSSD). An RSSD connection cannot define an agent.

• agent_name – the name of the agent that establishes the connection to the database.
• database_name – the name of the target database.
• host – the host name of the machine on which the target database is installed.
• port – the port number of the machine on which the target database is installed.
• user – the database login name. The user must have select permission. To automatically reconcile inconsistent, missing, and orphaned rows in the target database, the user must have the update, insert, and delete permissions.
• password – (optional) the password for the user login name.
  Note: If your Adaptive Server instance has a system administrator (sa) login with a null password, you must also state a null password in DA server, either by setting a blank password or by not setting a password at all.
• description – (optional) description of the agent. Use double quotes if you are using a reserved word or blank spaces.
• property_name – the JDBC driver connection property name.

  See Connection Properties in the SAP jConnect for JDBC 16.0 Programmers Reference.

• property_value – the value of the property to be set.

Examples

• Example 1 – replaces the current prod1 connection with a new connection definition:

  replace connection prod1
   set type = ASE
   set agent = localagent
   and set host = pluto
   and set port = 5050
   and set database = prod1
   and set user = prod_admin
   and set password = openSes4me
   with properties
     set ENCRYPT_PASSWORD = true
     and set PACKETSIZE = 1024
  go