Before you upgrade

Before you upgrade to a new release or to the latest Fix Pack of CDC Replication, make sure you end all replication activities, online activities, and save the metadata of your existing installation of CDC Replication.

Procedure

  1. End all CDC Replication Replication
    1. Add the CDC Replication product library to the library list by issuing the following command:
      CHGCURLIB LIB(<library>)

      where <library> is the CDC Replication product library.

    2. End mirroring in a controlled manner by issuing the following command:
      ENDDTAMIR TARGET(*ALL) ENDTYP(*CNTRLD)
    3. Verify that all CDC Replication replication jobs have stopped by issuing the System i® WRKACTJOB command.
    4. Stop the CDC Replication TCPLISTEN listener job by issuing the following command:
      ENDDMTCP ENDTYP(*IMMED)
    5. Remove the CDC Replication product library from the library list by issuing the following command:
      CHGCURLIB CURLIB(*CRTDFT))
    6. End the CDC Replication subsystem by issuing the following command:
      ENDSBS SBS(<version>) OPTION(*CNTRLD) DELAY(*NOLIMIT)

      where <version> is the CDC Replication current version subsystem.

  2. End all online CDC Replication activities

    Use the System i WRKACTJOB command to determine if there are any CDC Replication jobs running under the current version subsystem. All CDC Replication jobs have to be stopped before starting the upgrade.

  3. Save the CDC Replication metadata.

    Saving your CDC Replication metadata is a precautionary operation that allows you to recover data if an unforeseen situation occurs during the upgrade process.

    1. Create the save file where CDC Replication metadata is stored by issuing the following command:
      CRTSAVF <library>/<file>

      where the placeholders are the following values:

      <library>
      The save file library name
      <file>
      The save file name

      Place the save file in a library other than the CDC Replication product library.

    2. Save the metadata objects into the save file that was created by the CRTSAVF command by issuing the following command:
      SAVOBJ OBJ(DMFS* DMFT* JRN_STATUS) LIB(<prod library>) DEV(*SAVF) 
      OBJTYPE(*FILE *USRSPC) SAVF(<library>/<file>)

      where the placeholders are the following values:

      <prod library>
      The CDC Replication product library.
      <library>
      The save file library name
      <file>
      The save file name

What to do next

Note: The default encodings of the conflict audit table have changed from CCSID 37 to CCSID 1208 in version 6.1 Fix Pack 2 and later of the CDC Replication Engine for Db2® for i, in order to support multibyte character names in identifiers. You may need to adjust your encoding set in order to view the table after upgrading.