Release Notes

15.7 Chapter 3. Data Replication Scenario

15.7.1 Replication Scenarios

See the Library page of the DataPropagator Web site (http://www.ibm.com/software/data/dpropr/) for a new heterogeneous data replication scenario. Follow the steps in that scenario to copy changes from a replication-source table in an Oracle database on AIX to a target table in a database on DB2 for Windows NT. That scenario uses the DB2 DataJoiner Replication Administration (DJRA) tool, Capture triggers, the Apply program, and DB2 DataJoiner.

On page 44 of the book, the instructions in Step 6 for creating a password file should read as follows:

Step 6: Create a password file

Because the Apply program needs to connect to the source server, you must create a password file for user authentication. Make sure that the user ID that will run the Apply program can read the password file.

To create a password file:

1. From a Windows NT command prompt window, change to the C:\scripts directory.
2. Create a new file in this directory called DEPTQUAL.PWD. You can create this file using any text editor, such as Notepad. The naming convention for the password file is applyqual.pwd; where applyqual is a case-sensitive string that must match the case and value of the Apply qualifier used when you created the subscription set. For this scenario, the Apply qualifier is DEPTQUAL.

   Note:

   The filenaming convention from Version 5 of DB2 DataPropagator is also supported.

3. The contents of the password file has the following format:

   SERVER=server USER=userid PWD=password  
   

   Where:

   server

   The name of the source, target, or control server, exactly as it appears in the subscription set table. For this scenario, these names are SAMPLE and COPYDB.

   userid

   The user ID that you plan to use to administer that particular database. This value is case-sensitive for Windows NT and UNIX operating systems.

   password

   The password that is associated with that user ID. This value is case-sensitive for Windows NT and UNIX operating systems.

   Do not put blank lines or comment lines in this file. Add only the server-name, user ID, and password information.
4. The contents of the password file should look similar to:

   SERVER=SAMPLE USER=subina PWD=subpw
   SERVER=COPYDB USER=subina PWD=subpw
   

For more information about DB2 authentication and security, refer to the IBM DB2 Administration Guide.