Table of Contents

Search

  1. Preface
  2. PowerExchange Installation and Upgrade Overview
  3. Installation Planning
  4. Upgrade Planning
  5. Installing and Upgrading PowerExchange on IBM i
  6. Installing and Upgrading PowerExchange on Linux and UNIX
  7. Installing and Upgrading PowerExchange on Windows
  8. Installing and Upgrading PowerExchange on z/OS
  9. Appendix A: Upgrade Considerations
  10. Appendix B: PowerExchange Environment
  11. Appendix C: Manual Installation on IBM i

Installation and Upgrade Guide

Installation and Upgrade Guide

Step 2. Run the IBM i Installer

Step 2. Run the IBM i Installer

You can run the IBM i Installer to transfer the software to the IBM i system and configure PowerExchange for IBM i. The IBM i Installer runs on the Windows computer where PowerExchange has been installed.
Make sure that the computer meets the following requirements:
  • The computer uses a 64-bit Windows operating system. If you attempt to run the installer on a 32-bit system, the installation fails.
  • The display is set to a minimum resolution of 1280 x 960.
  • The Java Runtime Environment (JRE) version 8 or later is installed.
  1. Use one of the following methods to launch the PowerExchange IBM i Installer:
    • In File Explorer, navigate to the PowerExchange installation directory and locate the
      pwxins.exe
      file. Double-click
      pwxins.exe
      to launch the installer.
    • In a Windows command window, navigate to the PowerExchange installation directory. Type
      pwxins.exe
      and press Enter to launch the installer.
  2. In the
    Local File Name
    field, enter the name of the IBM i save file you extracted.
  3. Under
    IBM i Connection
    , enter the following connection information:
    Server
    The name of the IBM i server on which PowerExchange will be installed.
    User
    The user ID for the owner or administrator of the PowerExchange installation. Make sure that the user ID has rights and privileges that allow access to source and target data from different locations on the IBM i system. To install the product, you must log in with a user profile that has the required authorities. Use one of the following user profiles:
    • The IBM-supplied user profile of QSECOFR
    • A user profile defined with the USRCLS parameter set to *SECOFR and the SPCAUT parameter set to *USRCLS
    • If the USRCLS parameter is not set to *SECOFR, a user profile with at least the following SPCAUT values: *SECADM, *ALLOBJ, and *JOBCTL
    Password
    The password associated with the user ID specified in the
    User
    field.
    View password
    Select this check box to see the password as you type it. Clear this check box to mask the password.
  4. Under
    IBM i Save File
    , enter the following information for the save file to be created on the IBM i system:
    Name
    The name of the save file to be created on the IBM i system.
    Library
    The IBM i library where the save file will be created.
    Replace existing
    Select this check box if a save file already exists on the IBM i system and you want the installer to replace it.
  5. Under
    PowerExchange Environment
    , enter the following information for configuring the PowerExchange environment on the IBM i system:
    Object Library
    The name of the PowerExchange software library on the IBM i system.
    ASP Device
    If you plan to run PowerExchange within an independent auxiliary storage pool (IASP), specify the auxiliary storage pool (ASP) group that will contain the PowerExchange libraries.
    All PowerExchange libraries must reside in either the system auxiliary storage pool, ASP 1, or in an IASP identified by a device name.
    The fields under
    PowerExchange Environment
    are not available until you enter the IBM i save file in
    Local File Name
    .
  6. Select the
    Create environment
    check box to configure the data library, system objects, PowerExchange license key, and DBMOVER file.
    The following fields become available:
    Data Library
    The name of of the PowerExchange data library that contains objects such as the configuration source file, data files for capture registrations and condense files, message log file, message queues, and PowerExchange job description.
    Description
    A brief description that PowerExchange uses when creating the data library, condense library, and extraction map library.
    Create system objects
    Select this check box if you want to create the environment with a predefined list of system objects to control the runtime environment for PowerExchange. The installer creates the following object types:
    • Class
      . The class that defines the runtime attributes for PowerExchange jobs.
    • Output Queue
      . The output queue that stores the spooled file output from PowerExchange jobs.
    • Subsystem Description
      . A description of the subsystem associated with the job queue.
    • Job Queue
      . The name of the job queue for the subsystem.
    • Job Description
      . A description of the job used to define the system objects and libraries created for the PowerExchange environment.
    If
    Create system objects
    is not selected, you must create a suitable runtime environment for PowerExchange before running the IBM i Installer.
    Configure PowerExchange license key
    Select this check box to enter a PowerExchange license key for a new installation or to update an existing license key. This key will be transferred to the IBM i system. If you select this option and click
    OK
    , the
    IBM i - Configure PowerExchange License Key
    dialog box appears.
    Configure PowerExchange DBMOVER file
    Select this check box to configure the DBMOVER configuration file on the IBM i system. If you select this option and click
    OK
    , the
    Configure PowerExchange DBMOVER File
    dialog box appears.
  7. Select the Configure CDC check box to enter change data capture library names.
    The following fields become available:
    Condense Library
    The name of of the library that contains the PowerExchange Condense files, including condense files, lock files, the CFGCOND(CAPTPARM) configuration member, and the CHECKPOINT, CMDHANDLER, COLLECTOR, CONDENSE, CONTROLLER, and DUMP message queues. PowerExchange deletes the files in this library during normal operation. Do not place other files in this library without first contacting Informatica Global Customer Support.
    Extract Library
    The name of of the PowerExchange capture library that contains the extraction map files.
    Journal Exit Sequence
    A unique four-digit number that is used to register the PowerExchange Delete Journal Receiver exit program for the exit point QIBM_QJO_DLT_JRNRCV. Specify a value that is not used on your system. To determine the numbers that are currently registered against the exit point, use the WRKREGINF command and then choose option 8. Default is 1000.
    Exit Library
    The name of of the PowerExchange Journal Exit Program library that is required if your environment is installed in to an IASP. The IBM i system requires that the Journal Exit Program provided by PowerExchange resides in a library that is not in the IASP.
  8. If you select the
    Configure remote database
    check box, enter appropriate values to allow PowerExchange to connect to the remote system:
    Configure remote database
    Select this check box if you plan to access an Db2 for i database on a system that is remote from where the PowerExchange software is installed.
    • System Name
      . The name of the remote IBM i system.
    • Database Name
      . The name of of the remote Db2 for i database.
    • ASP Device
      . If the PowerExchange environment needs to access tables and table metadata from a remote database in an Independent ASP, specify the name of the Independent ASP on the remote server. Otherwise, leave this field blank.
    • OS Level
      . The version of the IBM i operating system on the remote system.
  9. Click
    OK
    to run the installation process.
    The next steps depend on the configuration options you selected:
    • If you selected the
      Configure PowerExchange license key
      check box, the
      Configure PowerExchange License Key
      dialog box appears. For more information, see Step 3. Enter the License Key.
    • If you selected the
      Configure PowerExchange DBMOVER file
      check box, the
      Configure PowerExchange DBMOVER File
      dialog box appears. For more information, see Step 4. Configure the DBMOVER Configuration File Options.
    • If you did not select either option, the installation process begins, and progress bar tracks the installation progress. When the installation process completes, the IBM i installer issues a success message.
  10. After the installation completes, click the
    Close
    button (X) at the top right corner of the IBM i Installer to close the window.
    Use the
    Reset
    button at the bottom of the window to clear all of the information in the window.

0 COMMENTS

We’d like to hear from you!