1. Microservices Architecture Documentation
  2. Prepare
  3. Prepare Databases
  4. Db2 for i
  5. Preparing the Journals for Data Capture by Extract
  6. Deleting Old Journal Receivers

Deleting Old Journal Receivers

Although the DLTRCV parameter is set to NO in the recommended configuration for Extract (see Setting Journal Parameters), you can delete old journal receivers manually once Extract is finished capturing from them.

If using another application that is using the journals that Oracle GoldenGate will be reading, consideration must be given regarding any automatic journal receiver cleanup that may be in place. Oracle GoldenGate must be able to read the journal receivers before they are detached or removed.

To Delete Journal Receivers

  1. Run the following command to view the journal positions in which Extract has current processing points, along with their journal receivers.
    INFO EXTRACT group
  2. Use the following Db2 for i command to delete any journal receivers that were generated prior to the ones that are shown in the INFO EXTRACT command.
    DLTJRNRCV JRNRCV(library/journal_receiver)

    Where:

    library and journal_receiver are the actual names of the library and journal receiver to be deleted. See the Db2 for i Information Center for more information about this command.