Zero Downtime Installation Guide for IBM DB2

Zero Downtime Installation Guide for IBM DB2

Install Oracle GoldenGate for IBM DB2

Install Oracle GoldenGate for IBM DB2

Install Oracle GoldenGate on the source system. Repeat the installation on the target system.
For system requirements and alternative installation instructions, see the Oracle GoldenGate documentation on the Oracle website.
  1. Copy the downloaded Oracle GoldenGate .zip file to the system.
  2. Extract the .zip file to a local directory named
    GGS
    .
  3. From a command prompt, navigate to the
    GGS
    directory.
  4. Start the Oracle GoldenGate Command Interperter for DB2.
    C:/GGS > start ggsci.exe
  5. In the
    Oracle GoldenGate Command Interpreter for DB2
    window, edit global parameters.
    1. At the
      GGSCI
      prompt, enter the following command:
      GGSCI > EDIT PARAM ./GLOBALS
      An editor opens.
    2. Click
      Yes
      to create a file named
      GLOBALS
      .
    3. In the file, type one of the following lines of text:
      • For the source system, type:
        MGRSERVNAME SRCGGSMGR
      • For the target system, type:
        MGRSERVNAME TGTGGSMGR
    4. Save and close the file.
  6. Create subdirectories.
    GGSCI> CREATE SUBDIRS
    The command creates the following files and directories under the
    GGS
    directory:
    Files
    Directory Name
    Parameter files
    dirprm
    Report files
    dirrpt
    Checkpoint files
    dirchk
    Process status files
    dirpcs
    SQL script files
    dirsql
    Database definitions files
    dirdef
    Extract data files
    dirdat
    Temporary files
    dirtmp
    Stdout files
    dirout
  7. Create a parameters file.
    1. Enter the following command:
      GGSCI > EDIT PARAM MGR
      An editor opens.
    2. Click
      Yes
      to create a file named
      mgr.prm
      .
    3. In the file, type
      PORT
      and then specify the port number that Oracle GoldenGate uses. You can use a different port number on the source system and on the target system.
      PORT
      7800
    4. Save and close the file.
  8. Start the Oracle GoldenGate Manager.
    GGSCI > start mgr
    The
    Oracle GoldenGate Manager for DB2
    window opens. A message confirms that the Manager is started on the specified port.
  9. Repeat all steps on the other system.

0 COMMENTS

We’d like to hear from you!