Install the change selector process - aws_mainframe_modernization_service - connect_cdc_mimix_share - Latest

The Change Selector is a process, that is, an executable component, used for replication on DB2 servers only. The Change Selector captures SQL row operation changes, specifically INSERT, UPDATE, and DELETE in the context of an SQL transaction.

The Change Selector is installed before the Java components. Install a Change Selector on all IBM i machines in your Enterprise Data Movement Model (EDMM) that host DB2 for IBM i source servers.

You may need the cooperation of a systems programmer, security administrator, DB2 administrator, and a network administrator.

The installation process includes unpacking the compressed installation library. Trace information about the entire installation job is stored in a spool file (QPJOBLOG) in your user output queue.

1. Sign on.

    Use the QSECOFR user profile or a user profile that has security officer authority.

   The end of the installation process automatically generates a job log. By signing on just before starting the installation, you limit the job log to only the installation process.

2. Load the CD or Copy the STM file from the Connect CDC CD.

   • If you are installing from a CD, load the CD into the device and make the device ready. Using the name of the device from which you are installing for device-name, enter the following command:

   LODRUN DEV(device-name)

3. Once completed, go to step 5.
   • If you are copying the STM file, locate the STM file in the IBM i folder on the CD. The file name is:

     <version number>.SYSTEMI.CONNECTCDC

4. Copy this file to the following location:

   /ConnectCDCV58/<version number>.SYSTEMI.CONNECTCDC.STM

5. Install INSPRD, if not already installed.

   Precisely provides the Install (INSPRD) tool in version 8 License and Availability Manager for users that are installing from a streamfile (STMF). The INSPRD tool simplifies the install process.

   If either of the following conditions apply, you must obtain the tool manually during the installation:

   • You are using the STMF format for a new install, where License and Availability Manager is not installed.

   • You are using the STMF format to upgrade to version 8 for the first time and License and Availability Manager is not at version 7.

   The INSPRD STMF and manual are on the CD in:

   IBM i/INSPRD

6. Enter the INSPRD command to start the install.

   Issue the following command on the IBM i:

   LAKEVIEW/INSPRD STMF('/ConnectCDCV58/<version number>.SYSTEMI.CONNECTCDC.STM’) INSTLIB(*SELECT)

7. Install License Manager, if not already installed.

   If you do not have a License Manager installed, you are prompted to install it when you attempt to install the Change Selector. License Manager must be installed before you install the Change Selector. If you have already installed License Manager, go to step 6.

   Note: The License Manager can only be automatically upgraded from the prior version, version 7.
   Note: The License Manager must be installed at version 8.0.15.00 or higher prior to installing the Change Selector.

8. Select 1 Install/Upgrade.

   On the Lakeview Technology Common Install screen, input 1 Install/Upgrade in the Opt column next to Connect CDC and press Enter.

   For online help, press F1 when the cursor is at the top of the display or, for a specific option or item, press F1 when the cursor is on that option or item.
   
   

   The Install Lakeview Product (INSLKVPRD) display appears.

9. Accept or select new installation Library name.

   In the Installation Library field, you see either a default library name (OMNIENT), the name of your existing product library (if you are reinstalling) or the value *NEW. You can accept the library name or change it to a new name.

   If the value *NEW appears, the default library already exists on the system and you must provide the name of a library that does not already contain a copy of the Connect CDC files you are installing.

10. Press Enter to start the installation process. Messages at the bottom of the page describe the active installation task. When the installation of all the products completes, the Lakeview Technology Common Lakeview Technology Install display appears. A completion message appears at the bottom of the display.
    
    
11. If you are installing multiple products, repeat step 1 and step 2 for each product.
12. Press F12 to return to the command line.