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

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

Procedure

  1. If you are configuring the first instance of the CDC Replication Engine for Sybase databases 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® InfoSphere® 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 10301. For more information, see your Management Console documentation.
    Staging Store Disk Quota (GB) Enter the maximum amount of disk space that will be utilized by the CDC Replication staging store on your source system. The default value is 100 GB.

    Specify 1 GB if you are creating an instance that will be used as a target of replication. This reduces the disk resources that CDC Replication requires on your target system.
    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.
  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 Database 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
    Sybase Directory

    Enter the fully qualified path to the Sybase installation directory.

    The configuration tool reads the SYBASE environment variable to provide a default value. For more information, see your Sybase documentation.

    Click Browse... to specify the path to the Sybase directory.
    SYBASE_OCS

    Select the SYBASE_OCS environment variable.

    The configuration tool provides default values once you specify a valid Sybase installation directory. For more information on the SYBASE_OCS environment variable, see your Sybase documentation.
    Sybase server Select the name of the Sybase Adaptive Server from the list provided by the configuration tool.
    Database Select the name of the database that you want to replicate data to or from and contains all of the tables for replication. You can set up or decide on this database before you install the CDC Replication Engine for Sybase databases.
    Note: Do not click the Advanced button and enter values unless directed by an IBM representative.
    Port Enter the port number for Sybase Adaptive Server. If the CDC Replication Engine for Sybase databases can detect the port from sql.ini, this text box will be read-only.
    Username Enter the user name for Sybase Adaptive Server.
    Password Enter the password for Sybase Adaptive Server.
    Metadata Schema 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.
  7. Also in the Database area, if your database is configured to require encrypted passwords, click Advanced.

    The Database Advanced Options window opens for adding extra JDBC connection parameters. Follow these steps:

    1. Click Add.
    2. Under Parameter, enter AuthenticationMethod.
    3. Under Value, enter encryptPassword.

      This setting prompts the DataDirect Sybase JDBC Driver to negotiate password encryption and send only the password as encrypted by using the Sybase encryption algorithm.

  8. In the Archive Log Directory area, enter the specific path to the Sybase archive logs in the Archive Path: field, or you click Browse... to specify the path instead. The CDC Replication Engine for Sybase databases uses the archive logs to replicate your database changes.
    Note the following:
    • All archive logs must be located in one directory and the CDC Replication Engine for Sybase databases must have read permissions for this directory.
    • You should not specify the directory that is being used for your online logs.
  9. 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.