This section describes how to prepare DataJoiner for AIX for replication.
Restore product files using installp or smitty by following the steps described in the DB2 DataJoiner Planning, Installation, and Configuration Guide. Installation of some components is optional. Later, as described in Installing DJRA and connecting all databases, you will install DJRA on your NT workstation. Make sure that the workstation with DJRA can connect to the workstation with DB2 DataJoiner (if they are not the same).
As described in the DB2 DataJoiner Planning, Installation, and Configuration Guide, you:
This section focuses on setting up the Apply program and creating DataJoiner databases as pertaining to replication.
Identify the Apply user ID as a local client on DataJoiner. See the DB2 DataJoiner Planning, Installation, and Configuration Guide for more information.
In addition to using Apply for AIX (provided with DataJoiner), you can also use other Apply programs on other platforms as discussed in Connecting clients to DataJoiner.
As described in the DB2 DataJoiner Planning, Installation, and Configuration Guide, you create databases that will be configured to access non-IBM databases as part of your replication system. You must create one DataJoiner database for each non-IBM replication source server. You can support many non-IBM replication target servers with one DataJoiner database. The DataJoiner databases that you set up reside on one DataJoiner instance.
For every non-IBM source, use the COLLATE USING parameter within the CREATE DATABASE command. Use IDENTITY.
The Apply program in DataJoiner uses the connections that you configure in
this section to access source, target, and control servers.
Table 34. Configuring Database Connections in DataJoiner: AIX
| If accessing | You need to |
|---|---|
| DB2 for OS/390 | Catalog DB2 in DataJoiner |
| DB2 UDB V6 or DB2 CS V2 | Catalog DB2 in DataJoiner |
| Informix, MS SQL Server, Sybase, Sybase SQL Anywhere, or Oracle | Create a server mapping and user mapping within DataJoiner |
You must define server and user mappings for each DataJoiner database that requires access to a source or target. You must have one DataJoiner database for each non-IBM replication source server. You can support many target servers with one DataJoiner database. The DataJoiner databases that you set up reside on one DataJoiner instance.
For Apply for OS/390, refer to the DB2 DataJoiner Planning, Installation, and Configuration Guide for information on how to enable applications on MVS, such as Apply for OS/390, to access DataJoiner.
For Apply programs on DB2 UDB or DB2 CS, refer to the chapter applicable to your network's communication protocol: TCP/IP, IPX/SPX, or APPC.
The steps that are described in the "Connecting Clients to DB2 DataJoiner" section in the DB2 DataJoiner Planning, Installation, and Configuration Guide must be performed for each DataJoiner database that is created to replicate with a remote Apply program. Later, you will connect DJRA as a client to DataJoiner.
Before proceeding to Installing DJRA and connecting all databases, make sure that you install all Capture and Apply programs on the systems of your choice.