Replication with Infosphere CDC : IBM InfoSphere CDC for solidDB® reference : Configuring IBM InfoSphere CDC : Configuring IBM InfoSphere CDC instances (Windows)
  
Configuring IBM InfoSphere CDC instances (Windows)
You can add, edit, or delete an instance of IBM InfoSphere CDC. Use the IBM InfoSphere CDC configuration tool to work with instances.
To add a new instance of IBM InfoSphere CDC (Windows) Procedure
1 If you are configuring the first instance of IBM InfoSphere CDC 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:
\<IBM InfoSphere CDC Installation Directory>\bin\dmconfigurets
3 At the welcome message, click OK to continue.
4 On the IBM InfoSphere CDC New Instance dialog box, you can configure the following options in the Instance area:
Option
Description
Name
Type a name for your IBM InfoSphere CDC instance. This name must be unique.
Server Port
Type the port number which IBM InfoSphere CDC uses for communication with client workstations running Management Console and other servers.
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. IBM InfoSphere CDC displays a default TCP/IP port of 11101. For more information, see your Management Console documentation.
If you install several instances on the same node, the port number for each instance must be unique.
Auto-Discovery Port
Select the box and type the UDP port number that is used for auto-discovery broadcasts sent from Access Server. For more information about auto-discovery, see your Management Console documentation.
Maximum Memory Allowed
Type the maximum amount of RAM you want to allocate for IBM InfoSphere CDC. You must allocate a minimum of 64 MB for each instance you configure. By default, there is 512 MB of RAM allocated for a 32 bit instance and 1024 MB of RAM allocated for a 64 bit instance.
Staging Store Disk Quota (GB)
Enter the maximum amount of disk space that will be utilized by the IBM InfoSphere CDC staging store on your source system. The default value is 100 GB and minimum value is 1 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 IBM InfoSphere CDC requires on your target system.
Bit-Version
Select the bit-version of your database by selecting one of the following options:
▪32 bit
▪64 bit
These options are not enabled if you are installing IBM InfoSphere CDC on a 32-bit server.
5 In the Windows Service area, you can specify the account that will be used to start IBM InfoSphere CDC services. Select one of the following options:
Option
Description
Local System account
Start IBM InfoSphere CDC services through the local system administrator account.
This account
Start IBM InfoSphere CDC 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, type the password currently associated with the selected Windows user account. If you change the password for the Windows user account after installing IBM InfoSphere CDC, you will have to use the Windows Services dialog to change the password currently set for each IBM InfoSphere CDC 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
User name
Type the user name for the specified database.
Password
Type the password for the specified database.
Metadata Schema
Select the schema for the database that will be used for the IBM InfoSphere CDC metadata tables.
As a default, the user name entered above is used. You can specify any schema except those in use by other installed instances of IBM InfoSphere CDC for the given database. You must set up or decide on this schema as part of the installation prerequisites.
Make sure to use UPPERCASE letters for the metadata schema. By default, all the schema names (catalog names) in solidDB® are in uppercase.
Advanced
The Advanced button enables you to modify configuration parameters for the solidDB® JDBC driver. For more information about the JDBC driver parameters, see the solidDB® Programmer Guide.
Tip:
▪In HA setup, the parameter solid_tf_level is by default set to CONNECTION.
▪In SMA setup, the parameter solid_shared_memory is by default set to yes.
▪To enable use of operating-system-based external authentication, set this property:
solid_use_strong_encryption=yes
7 In the Server area, you can configure the solidDB® server that you want to replicate data to or from and which contains all of the tables for replication. You can configure either single server or HA configuration (HotStandby).
Option
Description
Single server
Type the host name and port number for the specified solidDB® server.
Enable SMA
Select the check box if you are using solidDB® with shared memory access (SMA).
HA Configuration (HotStandby)
Type the host names and port numbers for the specified Primary and Secondary solidDB® servers.
8 Click OK to save your configuration settings for the IBM InfoSphere CDC instance.
9 If IBM InfoSphere CDC 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.
What to do next
After you complete the configuration, you can start IBM InfoSphere CDC.
To edit an instance of IBM InfoSphere CDC (Windows) Procedure
1 Stop IBM InfoSphere CDC if it is started by using the dmshutdown command (see dmshutdown: Shut down IBM InfoSphere CDC).
2 Launch the configuration tool at the command prompt by issuing the following command in the specified directory: \<IBM InfoSphere CDC Installation Directory>\bin\dmconfigurets
3 In the Instances area, select the instance that you want to modify and click Stop if the instance is started.
4 In the Instances area, select an instance and click Edit. The IBM InfoSphere CDC Edit Instance dialog opens.
5 You can modify any of the values on this dialog box that you specified when adding an instance.
6 Click Apply to save your changes and then click Close. The configuration tool will modify the instance.
7 In the Instances area, select the instance that you modified and click Start to start the instance.
To delete an instance of IBM InfoSphere CDC (Windows) Procedure
1 Stop IBM InfoSphere CDC if it is started by using the dmshutdown command (see dmshutdown: Shut down IBM InfoSphere CDC).
2 At the command prompt, launch the configuration tool by issuing the following command in the specified directory: \<IBM InfoSphere CDC Installation Directory>\bin\dmconfigurets
3 In the Instances area, select the instance that you want to delete and click Stop if the instance is started.
4 In the Instances area, select an instance and click Delete.
5 Click Ye s to permanently delete the instance.
See also
Configuring IBM InfoSphere CDC