Home About Courses Schedule Services Webinars Contact Search

IBM InfoSphere Data Replication (IIDR) for Everyone

SEE SCHEDULE

Duration: 3.0 days

Method: Instructor-Led, Hands-on

Price: $1800.00

Course Code: DR1000



Audience

The course is aimed at DBA’s, application technical support personnel, Db2 SYSADM’s, plus anyone wanting to understand the details involved in using IIDR.

Description

You are about to embark on implementation of IIDR and not sure what it is all about. Come to this course to learn the details about implementing and using IIDR. We begin with an introduction to the product, its components, and terminology. Included in the introduction is a brief look at what it takes to install the product. From there we move into a look at SQL Replication and its usage. Then it is onto Q Replication and its usage. We will also discuss a little bit of performance for both SQL Replication and Q Replication. Next we will provide an overview of IBM MQ and what it takes to implement the Q Replication resources. This does include some performance topics and the need to have multiple “paths” between MQ queue managers. While the course is based upon IIDR 11.4 on z/OS, a later version of the course will include IIDR usage on Linux, UNIX, and Windows.

Objectives

Upon successful completion of this course, the student will be able to:

  • Define the product, its components and terminology
  • Detail coverage of SQL Replication and its implementation
  • Detail coverage of Q Replication and its implementation
  • Provide an overview of IBM MQ and what is involved in support of Q Replication
  • Provide some performance topics for both SQL and Q replication
  • Provide some trouble-shooting guidelines
  • Provide some IBM Db2 and IBM MQ concerns in normal usage of IIDR

Prerequisites

The course is aimed at DBA’s, SYSADM’s, and application technical support personnel with at least 1 year experience in support of IBM Db2. The attendee should also have a good understanding of TSO/ISPF and z/OS JCL. A basic knowledge of IBM MQ is considered a plus.

Topics

  1. Product Overview - This section provides a product overview, the terminology involved and a brief look at system requirements and product installation.
    • What is IIDR?
    • A look at solution topologies including unidirectional and bidirectional
    • A look at Change Data Capture (CDC) component
    • A look at SQL Replication (SQLRep) component
    • A look at Q Replication (QRep) component
    • System requirements for implementation and usage
    • A brief look at the install process.
    • Overview and implementation of the Management Console and Access Server on Windows
    • Overview and implementation of the ASNCLP command line processor on z/OS
  2. SQL Replication – This section covers the implementation and usage of SQL Replication for both testing and production environments.
    • Db2 requirements for SQL Replication, including authorizations
    • Configuring Db2 for SQL Replication
    • Setting up the Capture and Apply programs
    • Registering and subscribing Db2 tables and views as sources for replication
    • Special considerations for data type and mappings
    • Running the Capture and Apply programs on z/OS
    • Maintaining and changing the SQL Replication environment
  3. Q Replication – This section covers the implementation and usage of Q Replication for both testing and production environments.
    • Db2 Requirements for Q Replication, including authorizations
    • IBM MQ requirements for Q Replication
    • Configuring Db2 and MQ for Q Replication
    • Setting up unidirectional, bidirectional, and multidirectional Q Replication environments
    • Setting up publications and subscriptions for Q Replications in the MQ
    • Special considerations for data type and mappings
    • Running the Capture and Apply programs on z/OS
    • Maintaining and changing the Q Replication environment.
  4. Overview of IBM MQ – This section covers some necessary MQ technology and administration for successful implementation of Q Replication.
    • Overview of MQ resources like Queues. Queue Managers, Channels, and Events
    • Guide to definitions of MQ resources in support of Q Replication
    • MQ resources in support of multidirectional Q Replication
    • MQ resources in support of high volume usage and Large Object (LOB) replication
    • MQ resources in support of data encryption
  5. Performance Considerations – This section covers a few considerations for performance in the data replication environment.
    • Differences between SQP and Q Replication as related to performance
    • Considerations for moderate to high volume Db2 table changes
    • Considerations when LOBs are involved
    • Considerations related to Db2 tables, indexes, and relationships between them
  6. Trouble Shooting – this section covers a few common trouble shooting topics as related to data replication.
    • Avoiding -904 and -911 due to contention between multiple replication tasks
    • Avoiding issues related to implementation of referential integrity
    • Considerations for Q Replication spill queues
    • Concerns due to loss of communication between MQ Queue managers
    • Concerns for bottle-necks due to high volume traffic
    • Considerations for data encryption