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