test connection config

Syntax

test connection config  
set type [{to|=}] {ASE | ASE_CLUSTER | RSSD | MSSQL | ORACLE | IQ | 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

• 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 – tests the connection details to an Adaptive Server:

  test connection config
  set type=ASE 
  and set agent=localagent
  and set host=pluto 
  and set port=5000
  and set database=custdb 
  and set user=sa
  go

  The returned result is:

  RESULT
  ----------
  Succeeded