Uninstalling Oracle GoldenGate from a Source DB2 for i System

1. (Suggested) Log on to the operating system as the system administrator or as a user with permission to issue Oracle GoldenGate commands and delete files and directories from the operating system.
2. From the Oracle GoldenGate installation directory, run GGSCI.
3. Stop all Oracle GoldenGate processes.

   STOP ER *
   

4. Stop the Manager process.

   STOP MANAGER
   

5. Log into the database with the DBLOGIN command.

   DBLOGIN SOURCEDB database, USERID db_user [, PASSWORD pw [encryption options]]

   Note:

   Only BLOWFISH encryption is supported for DB2 for i systems.

6. Run the DELETE TRANDATA command to end the journaling of tables.

   DELETE TRANDATA { schema.table  [JOURNAL library/journal] |
   library/file [JOURNAL library/journal] }
   

7. From an IBM 5250 terminal emulator, find the Oracle GoldenGate installation library. This library can been seen as the name in the oggprcjrn.srvpgm soft-link after qsys.lib. In the following example, the installation library is OGGLIB:

   oggprcjrn.srvpgm->/qsys.lib/qsys.ogglib/oggprcjrn.srvpgm
   

8. Delete the Oracle GoldenGate installation library. Specify "I" (ignore) for any prompts about unsaved journal receivers.

   clrlib library
   dltlib library
   

9. Remove the Oracle GoldenGate files by removing the installation directory.