To set up the GoldenGate environment after installing the software, the following actions need to be taken:
1. Run the command shell and change the directories to the new GoldenGate directory.
2. From the GoldenGate directory, run the GGSCI program.
./GGSCI
3. In GGSCI, issue the following command to create the GoldenGate working directories:
CREATE SUBDIRS
4. Issue the following command to exit GGSCI:
EXIT
These commands create all the necessary sub-directories required by GoldenGate under the GoldenGate installation directory such as dirrpt, dirdat, dirprm
, and so on. The configuration parameter files for processes such as Manager, Replicat, and Extract are stored in the dirprm
directory.
To set up changed data replication from an IBM DB2 database (source) to an Oracle database (target), the following actions need to be performed:
1. On the DB2 database server (source) configure DB2 for
logretain
anduserexit:
This step is essentially the first step required to configure...