IMS DataPropagator Implementation Guide

IMS DataPropagator Implementation Guide

by Jouko Jantti, Debra Kerry, Armin Kompalka, Rick Long, Greg Mitchell
Released November 2002
Publisher(s): IBM Redbooks
ISBN: None

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

IMS DataPropagator (IMS DPROP) is a licensed program that maintains consistency between two copies of the same data, where one copy of the data is stored in an IMS Database Manager (IMS DB) database and the other copy is stored in a DB2 database. IMS DPROP is a key component of IBM's Data Replication Solution and IBM's Business Intelligence Solution.
IMS DPROP can perform asynchronous change propagation, meaning that the change is applied independently of the updating application. You can apply changes at predetermined intervals, managing replication according to your business needs. Changes are captured from IMS environment with minimal impact to transaction response time. For asynchronous propagation, the IMS DB and DB2 systems may reside on the same or different OS/390 or z/OS systems and run under either the IMS Transaction Manager or CICS.
This IBM Redbooks publication was written to enhance the installation manual and provide customer assistance in the installation and migration processes.

Please note that the additional material referenced in the text is not available from IBM.

Table of contents

  1. Figures
  2. Notices
    1. Trademarks
  3. Preface
    1. The team that wrote this redbook
    2. Become a published author
    3. Comments welcome
  4. Part 1: Introduction
    1. Chapter 1: Overview
      1. What are the components of data propagation
      2. Types of propagation
        1. Asynchronous, near real time, MQSeries based propagation
        2. Asynchronous log-based propagation
        3. Synchronous propagation
      3. IMS DPROP systems types (1/3)
      4. IMS DPROP systems types (2/3)
      5. IMS DPROP systems types (3/3)
        1. MQ Capture setup
        2. MQ Apply setup
        3. LOG-ASYNC Selector setup
        4. LOG-ASYNC Receiver setup
        5. Synchronous setup
      6. Data mapping types
        1. Mapping Case 1
        2. Mapping Case 2
        3. Mapping Case 3
        4. Special mapping cases layouts
    2. Chapter 2: Subsystem installation setup
      1. OS/390 setup
        1. SVC information
        2. VLF information
        3. OS/390 subsystem name
      2. IMS subsystem setup (1/2)
      3. IMS subsystem setup (2/2)
        1. IMS log archive changes
        2. Updates to IMS DLIBATCH procedures
        3. DB2 Apply as BMP
      4. MQSeries setup (1/2)
      5. MQSeries setup (2/2)
        1. MQSeries subsystem setup
        2. MQSeries IMS adapter setup
  5. Part 2: Installation of DPROP systems
    1. Chapter 3: Installing a DPROP environment
      1. Starting the installation panels
      2. Defining the DPROP environment name
      3. Defining the DPROP environment parameters (1/4)
      4. Defining the DPROP environment parameters (2/4)
      5. Defining the DPROP environment parameters (3/4)
      6. Defining the DPROP environment parameters (4/4)
        1. Defining the DPROP environment elements
        2. Defining DPROP systems data set names
        3. Defining the system data sets Panel 2
        4. Defining the OS/390 copy program
        5. Defining environment JOB parameters
        6. Defining installation library
        7. Defining EKYGSYS parameters
        8. Defining the JOB card information
        9. Defining the audit trail table
        10. Defining the audit trail table information
        11. Defining the audit trail table DB2 objects
        12. Defining the Language Interface environment
        13. Defining the dynamic allocation exit routine
    2. Chapter 4: Install and customize MQ-ASYNC Capture system
      1. Introduction (1/3)
      2. Introduction (2/3)
      3. Introduction (3/3)
        1. System parameters and job generation
        2. Submit installation and verification jobs
        3. Installation verification for MQ Capture
      4. Creating an additional Capture system
      5. Prepare your own MQ-ASYNC capture
    3. Chapter 5: Installing an MQ Apply system
      1. IMS DPROP MQ Apply system installation panel flow
      2. Specifying MQ Apply system parameters (1/2)
      3. Specifying MQ Apply system parameters (2/2)
        1. Defining the DB2 subsystem parameters
        2. Defining the JOB and JOBLIB statements
      4. Define system installation and IVP parameters (1/2)
      5. Define system installation and IVP parameters (2/2)
        1. Define the IMS DPROP generation macro
        2. Defining the IMS DPROP directory tables
        3. Defining the IMS DPROP MVG input tables
      6. Binding the DB2 application plans (1/2)
      7. Binding the DB2 application plans (2/2)
        1. Prepare binds for the IMS DPROP and SQL update modules
        2. Creating the privileges for the DB2 collection IDs
        3. Prepare the binds for the SCU plan
        4. Defining the binding plan for the MVG application
        5. Defining the binding plan for the CCU
        6. Defining the binding plan for MQ Apply
      8. Specifying the IMS DPROP and SMF data sets
      9. Define the IVP parameters
        1. Define the IVP JOB parameters
        2. Defining the MQSeries parameters for the IVPs
      10. Generating and submitting installation jobs (1/2)
      11. Generating and submitting installation jobs (2/2)
        1. DPROP environment installation job submission
        2. Generating the IMS DPROP Stage I Job
        3. Edit and submit IMS DPROP Stage I job
        4. Submitting IMS DPROP system installation jobs
        5. Submitting IVP jobs
        6. Verifying IMS DPROP installation for the MQ Apply system
    4. Chapter 6: Installing a Selector and Receiver system
      1. Selector and Receiver system installation panel flow
      2. Working with the Specification Primary Menu panel
        1. Defining the DB2 environment, JOB, and JOBLIB statements
        2. Defining the DB2 subsystem parameters
        3. Defining the JOB and JOBLIB statements
      3. Defining installation and IVP parameters (1/5)
      4. Defining installation and IVP parameters (2/5)
      5. Defining installation and IVP parameters (3/5)
      6. Defining installation and IVP parameters (4/5)
      7. Defining installation and IVP parameters (5/5)
        1. Defining the IMS DPROP generation macro
        2. Defining the IMS DPROP directory tables
        3. Defining the mapping verification and generation input tables
        4. Binding the DB2 application plans
        5. Prepare the binds for the IMS DPROP and SQL update modules
        6. Creating the privileges for the DB2 collection IDs
        7. Defining the binding plan for the status change utility
        8. Bind plan for mapping verification and generation application
        9. Defining the binding plan for the consistency check utility
        10. Defining the binding plan for the PRDS registration utility
        11. Defining the binding plan for the group unload utility
        12. Defining the binding plan for the LOG-ASYNC Receiver
        13. Specifying the IMS DPROP and SMF data sets
        14. Defining the IVP parameters
        15. Modifying the IMS DPROP system title
      8. Generating and submitting installation and IVP jobs (1/2)
      9. Generating and submitting installation and IVP jobs (2/2)
        1. Submitting the installation JOBs
        2. IMS DPROP environment installation job submission
        3. Generating the Stage I job
        4. Submitting the system installation jobs
        5. Submitting the IVP jobs
        6. Verifying the installation for the LOG ASYNC Selector
        7. Verifying the installation of the LOG ASYNC Receiver
  6. Part 3: Migrating from Version 2.2
    1. Chapter 7: Migrating a Selector and Receiver system
      1. Migration of a Selector and Receiver system
        1. Migration process prerequisites
        2. General migration considerations
      2. Starting migration configuration (1/2)
      3. Starting migration configuration (2/2)
        1. Selecting a DPROP system to migrate
        2. Existing IMS DPROP environments
      4. Migrating a Selector and Receiver system (1/4)
      5. Migrating a Selector and Receiver system (2/4)
      6. Migrating a Selector and Receiver system (3/4)
      7. Migrating a Selector and Receiver system (4/4)
        1. Selector and Receiver system migration panel flow
        2. Working with the Specification Primary Menu panel
        3. Defining the DB2 environment, JOB, and JOBLIB statements
        4. Defining the DB2 subsystem parameters
        5. Defining the JOB and JOBLIB statements
        6. Defining installation and IVP parameters
        7. Defining the IMS DPROP generation macro
        8. Defining the IMS DPROP directory tables
        9. Defining the IMS DPROP MVG input tables
        10. Binding the DB2 application plans
        11. Prepare binding
        12. Creating the privileges for the DB2 collection IDs
        13. Defining the binding plan for the status change utility
        14. Bind plan for mapping verification and generation application
  7. Part 4: Setting up for propagation
    1. Chapter 8: Preparing propagation requests
      1. What is a propagation request
      2. Planning a propagation request
      3. How to set up a propagation request (1/2)
      4. How to set up a propagation request (2/2)
        1. The MVG input tables
        2. Set up a PR via MVG input tables
        3. The mapping verification generation utility (MVGU)
        4. The IMS DPROP directory tables
      5. Sample mapping in a propagation request (1/3)
      6. Sample mapping in a propagation request (2/3)
      7. Sample mapping in a propagation request (3/3)
        1. Propagation request with WHERE clause
    2. Chapter 9: Propagation to staging tables
      1. Propagation of IMS data to staging tables
      2. What are staging tables
      3. Consistent change data tables
      4. Defining staging tables
      5. CCD propagation requests
      6. Restrictions to CCD table propagation
      7. Propagation to other platforms
    3. Appendix A: Additional material
      1. Locating the Web material
      2. Using the Web material
        1. How to use the Web material
    4. Glossary
      1. A
      2. B
      3. C
      4. D
      5. E
      6. F
      7. G
      8. H
      9. I
      10. L
      11. M
      12. N
      13. O
      14. P
      15. R
      16. S
      17. T
      18. U
      19. V
    5. Abbreviations and acronyms
    6. Related publications
      1. IBM Redbooks
        1. Other resources
      2. Referenced Web sites
      3. How to get IBM Redbooks
        1. IBM Redbooks collections
    7. Index (1/3)
    8. Index (2/3)
    9. Index (3/3)
    10. Back cover

Product information

  • Title: IMS DataPropagator Implementation Guide
  • Author(s): Jouko Jantti, Debra Kerry, Armin Kompalka, Rick Long, Greg Mitchell
  • Release date: November 2002
  • Publisher(s): IBM Redbooks
  • ISBN: None