Adding an instance of the CDC Replication Engine for Teradata (Windows)

Before you can start replication, you must add and configure an instance.

1. If you are configuring the first instance of the CDC Replication Engine for Teradata after installation, you can proceed to Step 3 of this procedure.
2. At the command prompt, launch the configuration tool by issuing the following command in the specified directory:

   \<CDC Replication installation directory>\bin\dmconfigurets.exe

3. At the welcome message, click OK to continue.
4. On the IBM® Data Replication New Instance dialog box, you can configure the following options in the Instance area:

   Option	Description
   Name	Enter a name for your CDC Replication instance. This name must be unique.
   Server Port	Enter the port number which CDC Replication uses for communication with client workstations running Management Console and other servers. Note: This port number cannot be used by other applications installed on the same server. You will use this port number when specifying access parameters for your datastore in the Access Manager perspective in Management Console. CDC Replication displays a default TCP/IP port of 10901. For more information, see your Management Console documentation.
   Maximum Memory Allowed (MB)	Enter the amount of physically available RAM that you want to allocate for this instance of CDC Replication. By default, the configuration tool allocates 1024 MB of RAM for each instance. Note: Using values other than the defaults or allocating more RAM than is physically available on your server should only be undertaken after considering the impacts on product performance.
   Encryption profile	Select the encryption profile from the list. If you would like to enable TLS for communication between source and target, you must select an encryption profile with encryption enabled. Click Manage to view and manage the available encryption profiles. Encryption profiles can be shared between multiple instances of CDC Replication.

5. In the Windows Service area, you can specify the account that will be used to start CDC Replication services. Select one of the following options:

   Option	Description
   Local System account	Start the CDC Replication services through the local system administrator account.
   This account	Start CDC Replication services through the specified user account. The account must be specified in the format <domain>\<user name>, where <domain> is the name of a domain in your environment, and <user name> is a valid login user name in the specified domain. If your computer is not part of a domain, you can specify <computer name>\<user name>. In the Password and Confirm Password boxes, enter the password currently associated with the selected Windows user account. If you change the password for the Windows user account after installing CDC Replication, you will have to use the Windows Services dialog to change the password currently set for each CDC Replication service.

6. In the Teradata InstanceDatabase area, you can configure access to the database that contains the tables for replication. To complete this step, you will require system administrator privileges. You can then add a datastore in the Access Manager perspective in Management Console and provide users access to this database. For more information, see your Management Console documentation.

   Option	Description
   Name	Enter the name or IP address of the Teradata server that you want to replicate data to and that contains all of the tables for replication. The server should contain the database that you configured as part of the preinstallation tasks. Note: You cannot select a system database. Note: Do not click the Advanced button and enter values unless directed by an IBM representative.
   User name	Enter the user name for the specified database.
   Password	Enter the password for the specified database.
   Database/User	Select the database schema used by CDC Replication for metadata tables. You can specify any schema except those in use by other installed instances of CDC Replication for the given database. Note: CDC Replication metadata tables contain important configuration information and should be backed up as part of your database backup strategy.
   Advanced	If you are using Teradata JDBC driver version 17.10.00.07 or higher and the Teradata database supports SSL/TLS but these security features are not enabled, add the following parameter to avoid TLS connection errors: SSLMODE=DISABLE. See this technote for more information: https://www.ibm.com/support/pages/node/6485893. Note: Do not click Advanced and enter values unless you are directed to do so by an IBM representative.

7. In the Refresh Loader Path area, click Browse to specify the directory for bulk inserts into the database. Both your Teradata database and CDC Replication must have read and write permissions for this directory.
   Notes:

   • You should use a different directory for each instance of CDC Replication.
   • This directory may contain database tables for replication. You should take this into consideration when determining user access to this directory.
8. In the Teradata Driver area, click Add to specify the Teradata drivers. Ensure that you have also added the .jar files necessary for the drivers.
9. Optional: If you want to use a JMS provider as the method of communication between datastores, perform the following steps. Otherwise TCP/IP will be used exclusively as the communications protocol.

   A JMS provider should be used when characteristics of your network prevent the existence of a long term, stable TCP/IP connection.

   1. Ensure that a queue has been created by your system administrator and is named correctly. Each CDC Replication instance that is to use a JMS message provider must have a queue named in the format CDC_<port>, where <port> is the five digit TCP listening port number of the instance (you can left pad the number with zeroes if necessary, to ensure five digits).
   2. Click the Communications Protocol tab.
   3. Select JMS or TCP/IP.
   4. Click Add.
   5. Select the required JMS Provider .jar files.
   6. Click Add Connection.
   7. Enter a remote factory name. A connection factory encapsulates a set of connection configuration parameters that has been defined by an administrator.
   8. Enter a user name and password for JMS server authentication.

      This user name is defined by your JMS provider. Contact your system administrator for more information.

   9. Click the JNDI Server tab.
   10. Enter the constant that holds the local or remote connection factory name in the JNDI Initial Context box. Java™ Naming and Directory Interface (JNDI) is a programming interface from Oracle for connecting Java programs to naming and directory services.
   11. Enter the URL that is relative to the JNDI initial context in the JNDI URL box. In JNDI, all naming and directory operations are performed relative to a context. Therefore the JNDI defines an initial context that serves as a starting point for naming and directory operations. This value should be the fully-qualified class name of the factory class that will create the initial context.
   12. If the JNDI server to which you want to connect requires authentication, then you need to provide the user name and password to connect to that system. Contact your system administrator for information about the user name that you should specify.
   13. Click OK to save the connection.
   14. Click Test if you want to verify the connection.

       If the JMS Provider is not configured correctly, CDC Replication will use TCP/IP as the communication protocol between datastores.

   15. Click OK.
10. Click OK to save your configuration settings for the CDC Replication instance.
11. If CDC Replication has detected an unsupported encoding, a dialog will open asking you to select an alternate encoding from a list.

    You can filter the list of alternate encodings by clicking one of the following buttons:

    • Closest match—Displays the alternated encodings that are the closest match to the data.
    • Comparable encodings byte length—Displays the alternate encodings in order of byte length.
    • All–Displays all alternate encodings.

    Select an encoding from the list and click OK.

    If you click Cancel, an error message will be displayed and the instance will not be created.