Using Queue Replication

Using Queue Replication Course Description

Duration: 4.00 days (32 hours)

Gain knowledge on InfoSphere Replication Server and how it is used to perform both queue-based homogeneous data replication and heterogeneous data replication. Learn to distinguish the differences in functionality of the queue architecture's highly parallel, transaction-based, asynchronous message-based transmission capability with the SQL based architecture.

Use the Replication Center Graphical User Interface (GUI) to perform the Q Replication operations necessary to define, manage, and maintain queue-based data replication functions for DB2 for z/OS and DB2 for Linux, UNIX, and Windows. Additionally, incorporate the use of the ASNCLP command line interpreter for definitional tasks, along with utilities such as ASNTDIFF and ASNTREP and the Q Replication Dashboard, in your replication environment.

Discover how InfoSphere Replication Server can be engaged to publish transactions in either an Extensible Markup Language (XML) format or in a character delimited format. Become versed in the use of the WebSphere MQ queues required by InfoSphere Replication Server.

Next Class Dates

Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.

Back to Top

Intended Audience for this Using Queue Replication Course

  • » System Administrators
  • » Database Administrators
  • » Replication Administrators
  • » Data Warehouse Architects
  • » Programmers
  • » IBM professionals
  • » Individuals desiring a highly parallel, transaction-based, asynchronous queue message-based transmission replication architecture.

Back to Top

This Course is also part of:

Back to Top

Using Queue Replication Course Objectives

  • » Use InfoSphere Replication Server to perform queue based data replication activities in a multiplatform environment
  • » Define WebSphere MQ queues required by Q Replication
  • » Differentiate between the architectures of Q Replication and SQL Replication
  • » Detail each of the four basic tasks performed during Q Replication (preparation, infrastructure, definitional, and operational)
  • » Define, manage, and maintain queue based data replication functions using the Replication Center GUI
  • » Describe the Q Capture Schemas, Q Subscriptions, and Q Apply Browser components
  • » Highlight Q Replication's transaction publishing capabilities
  • » Operate the various components of Q Replication
  • » Use DB2 Replication Center GUI to perform basic administration of sources and subscriptions
  • » Use ASNTDIFF and ASNTREP
  • » Discuss basic Q Replication performance considerations

Back to Top

Using Queue Replication Course Outline

      1. WebSphere MQ for the Q Replication Administrator
        1. Position messaging and queuing in today’s business environment
        2. Provide a high level view of WebSphere MQ functions
        3. Describe how to place data into a queue owned by a remote queue manager
      2. Overview of WebSphere Replication Server
        1. Describe various reasons and needs for replication solutions
        2. Overview SQL Replication and the need for Q Replication
        3. Describe the Q Replication and Event Publishing Architectures
        4. List Q Replication components and administration tasks
        5. Discuss the methodology and functionality of Q Replication
      3. Setting Up a Federated Database
        1. Choose the appropriate DB2 product to set up a federated database
        2. Configure access to DB2 and non-DB2 remote data sources using:
          1. Wrappers
          2. Servers
          3. Nicknames
        3. Discuss how federated objects are stored within the DB2 catalog
        4. Determine the correct troubleshooting actions when the access to remote data objects cannot be successfully verified
      4. Preparing the Replication Environment
        1. Start the Replication Center and use its general functions such as the tool bar, tree of folders, folder contents, and actions on folders and contents
        2. Start the RC's Launchpad and utilize its quick operation capabilities
        3. Name and describe the WebSphere MQ queues used for Q Replication
        4. Describe the control tables used by Q Capture and Q Apply
        5. Create the required control tables
      5. Performing Unidirectional Replication
        1. List the types of Q Replication and types of Q subscriptions
        2. Describe unidirectional replication
        3. Create a unidirectional queue mapping
        4. Create a unidirectional subscription
        5. Create a stored procedure subscription
      6. Operating Q Capture and Q Apply
        1. Start Q Capture in the z/OS, Linux, UNIX, and Windows environments using operating system facilities and the Replication Center
        2. Start Q Apply in the z/OS, Linux, UNIX, and Windows environments using operating system facilities and the Replication Center
        3. Use operational commands to control Q Apply and Q Capture processing
        4. Change Q Capture and Q Apply parameters
        5. Use Replication Center for diagnostic inquiries
        6. Troubleshoot Q Capture and Q Apply processes
      7. Bidirectional and Peer-to-Peer Replication
        1. Overview the need for and concerns of multidirectional replication
        2. List the various types of multidirectional replication solutions available in Q Replication
        3. Describe bidirectional replication and learn how to create bidirectional subscriptions
        4. Describe peer-to-peer Replication and learn how to create peer-to-peer subscriptions
      8. Creating Publications
        1. Understand the background and requirements for publishing
        2. Describe Q Replication's Event Publishing capabilities
        3. Create a publishing queue map
        4. Create a publication
      9. Utilities and Replication Monitoring
        1. Describe and operate asntdiff and asntrep utilities
        2. Invoke the Q Analyzer utility
        3. Describe the Replication Center's reporting capabilities
        4. Create a Replication Alert Monitor
        5. Operate the Replication Alert Monitor
        6. Use the Q Replication Dashboard
      10. How Does Q Replication Work?
        1. Explain the major Q Capture processes and control table usage
        2. Discuss the Q Apply processes and control table usage
        3. Relate the basic operational characteristics of the Monitor processes
      11. Command Line Processor
        1. Perform ASNCLP functions in both command mode and file mode
        2. Use ASNCLP to setup a Q Replication environment
        3. Use ASNCLP to perform replication tasks, such as Q subscription creation
      12. Q Replication Processing
        1. Understand the basic Source and Target requirements
        2. Describe the Q Replication architecture
        3. Describe the Subscription process
        4. Differentiate Value-based Conflict Resolution from Version-based
        5. Add a column to a Q subscription
        6. Move a Q subscription to a new Q Capture schema
      13. Failover Considerations
        1. Specify the correct conflict detection for a Bidirectional failover scenario
        2. Describe the proper conflict resolution for a Bidirectional failover scenario
        3. List the potential sources of conflicts
        4. Describe the switchback considerations
      14. Performance Considerations
        1. Discuss possible settings, definitions, and actions that could improve the performance of Q Replication processes
        2. Modify parameters that affect the performance of Q Replication operations

Back to Top

Do you have the right background for Using Queue Replication?

Skills Assessment

We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.

Our required skill-assessments ensure that:

  1. All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
  2. NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
  3. We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.

Take your FREE Skill Assessment test »

Back to Top

Award winning, world-class Instructors

Our instructors are passionate at teaching and are experts in their respective fields. Our average NetCom instructor has many, many years of real-world experience and impart their priceless, valuable knowledge to our students every single day. See our world-class instructors.   See more instructors...

Back to Top

Client Testimonials & Reviews about their Learning Experience

We are passionate in delivering the best learning experience for our students and they are happy to share their learning experience with us.
Read what students had to say about their experience at NetCom.   Read student testimonials...

Back to Top