Release Notes
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:
- From a Windows NT command prompt window, change to the
C:\scripts directory.
- 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.
- 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.
- 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.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]