coursemonster.com/uk
IBM: Using Queue Replication
View training dates »Overview
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.
Included are a number of intensive hands-on machine exercises demonstrating InfoSphere Replication Server's capabilities in unidirectional replication as well as multidirectional replication. Linux will serve as the control point for administering the InfoSphere Replication Server for Linux, UNIX, Windows, and z/OS.
Audience
This is an intermediate course for system administrators, database administrators, replication administrators, data warehouse architects, programmers, users, IBM professionals, and other individuals desiring a highly parallel, transaction-based,
asynchronous queue message-based transmission replication architecture. This includes all individuals who perform or support evaluation, implementation, and usage activities for data movement, data availability, and data replication.
Prerequisites
Having a working knowledge of WebSphere MQ and an understanding of the basic operation and creation of queues and related queue managers will provide a good foundation for this course.
Skills or experience in the following specific areas enable you to more easily navigate the course material and facilitate in the execution of the lab exercises:
• Relational databases • Database system design • DB2 Control Center
• SQL
• DB2 platform knowledge
Skills Gained
• 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
Course Outline
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
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 methodology and functionality of Q Replication
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 troubleshooting actions when the access to remote data objects cannot be successfully verified
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 queues used for Q Replication • Describe the control tables used by Q Capture and Q Apply
• Create the required control tables
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
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 Center
• Use operational commands to control Q Apply and Q Capture processing • Change Q Capture and Q Apply parameters
• Use Replication Center for diagnostic inquiries • Troubleshoot Q Capture and Q Apply processes
Bidirectional and Peer-to-Peer Replication
• 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 peer-to-peer Replication and learn how to create peer-to-peer subscriptions
Creating Publications
• Understand the background and requirements for publishing • Describe Q Replication's Event Publishing capabilities • Create a publishing queue map
• Create a publication
Utilities and Replication 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
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
• 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
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 Q Capture schema
Failover Considerations
• 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
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
Agenda Day 1
• Welcome
• Unit 1 - Websphere MQ for the Q Replication Administrator • Exercise 1 - WebSphere MQ Setup
• Unit 2 - Overview of WebSphere Replication Server • Unit 3 - Setting up a Federated Database
• Exercise 2 - Setup the Federated Environment • Unit 4 - Preparing the Replication Environment • Exercise 3 - Q Replication Configuration
Day 2
• Unit 5 - Performing Unidirectional Replication • Exercise 4 - Unidirectional Replication Setup • Unit 6- Operating Q Capture and Q Apply • Exercise 5 - Operating Q Capture and Apply
• Unit 7 - Bidirectional and Peer-to-Peer Replication - Bidirectional • Exercise 6 - Bidirectional Q Replication
Day 3
• Unit 7 - Bidirectional and Peer-to-Peer Replication - P2P • Exercise 7 - Peer-to-Peer Replication
• Unit 8 - Creating XML Publications • Exercise 8 - XML Publishing
• Unit 9 - Utilities and Monitoring • Exercise 9 - Monitoring and Utilities • Unit 10 - How Does Q Replication Work? • Unit 11 - Command Line Processor • Exercise 10 - Using ASNCLP
Day 4
• Unit 12 - Q Replication Processing
• Exercise 11 - Adding Columns and Changing Schemas • Unit 13 - Failover Consideration
• Exercise 12- Conflict Detection • Unit 14 - Performance Considerations
View training dates »
Need more information? Why not call one of our professional training
advisors on
0800 40 848 40
or email us at
[email protected]
The training course outline shown above is a standardised version representing all the dates available and may vary from the course you attend. You will be sent the supplier's course outline when you enquire about a specific date.
SeaKom Ltd, Preston Park House, South Road, Brighton, BN1 6SB
