|
|
|
Daffodil Replicator simplifies the data replication and synchronization between
DB2 database servers with other heterogeneous database environments (Including Oracle, SQL Server,
Daffodil DB, PostgreSQL and Derby). This guide introduces the steps and describes how to configure
Daffodil Replicator for transferring the DB2 data on Derby client database.
Mention below is the simple steps to configure Replicator with DB2 database (Publisher) and
Derby (Subscriber).
- Download the appropriate zip file
-
- Extract the corresponding zip file to an appropriate folder
-
- Make the following changes by editing setpath.bat (windows) or startup.sh (Linux) (both for DB2
and Derby)
-
- Remove Rem from SET JAVA_HOME= and SET JDBC_CLASSPATH ="Replicator.jar"
-
- Set JAVA_HOME. JAVA_HOME is the directory path where you have installed JRE/J2SDK
Example: SET JAVA_HOME=C:\j2sdk1.4.2
-
- Set JDBC_CLASSPATH for Oracle, PostgreSQL and Replicator SET JDBC_CLASSPATH= C:\ classes12.jar
; pg80b1.308.jdbc3.jar ;Replicator.jar
Note: Directory path should not contain any blank spaces
-
- Run PubServer.bat/PubServer.sh to start publication server (DB2):
-
- To start Publication Server on your system, run the file PubServer.bat or PubServer.sh for
linux) available under the installation directory of Daffodil Replicator and a dialog box
appears
-
- Fill up the DataSource Information (bd2) in the dialog box appeared
-
- Driver - com.ibm.db2.jcc.DB2Driver
-
- URL - jdbc:db2://::50000/(database name)
-
- Username - Enter a valid username
-
- Password - Enter the password of the above specified user
-
- System Name - Specify the name or network IP of the local machine
-
- Server Port No. - Specify the port no. on which you wish to run Publication Server
-
- Similarly, run SubServer.bat/SubServer.sh to start subscription server (Derby).
|
