Using Queue Replication

start > courses and registration > training feature sheet

code.

DW241

length.

4 days

type.

Instructor-Led

partner.

IBM

price.

$2,500

IACET credits 0.0

Gain knowledge on WebSphere Information Integrator Queue (Q) Replication's use of WebSphere MQ to perform queue based data replication activities between IBM relational database systems and between IBM and non-IBM relational database systems. Learn to use Q Replication's highly parallel, transaction based, asynchronous message based transmission capability. Compare Q Replication's architecture to SQL Replication's 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 UDB for z/OS and DB2 UDB for Linux, UNIX, and Windows. Additionally, incorporate the use of the ASNCLP console command interpreter for definitional tasks, along with new tools such as ASNTDIFF and ASNTREPAIR, in your replication environment.

Discover how WebSphere Information Integrator Publisher Edition can be engaged to exploit Q Replication's Extensible Markup Language (XML) publication transaction publishing capabilities. Become versed on the usage of WebSphere MQ V5.3 queues required by WebSphere Information Integrator Queue Replication Version 8.2 and their efficiency in handling the transmission of data between DB2 UDB for Linux, UNIX, and Windows servers as well as DB2 UDB for z/OS.

Learn the various contingencies that should be taken into consideration when implementing a bidirectional or peer-to-peer failover system.

Not only are you challenged with informative, thought provoking lectures, but there are be several intensive hands-on machine exercises. The Windows platform in the exercises is used as the administration control point, but the concepts learned can be applied when running on Linux, UNIX, Windows, or z/OS.

Chicago, IL	jul.15.2008 - jul.18.2008	register
Towson/Baltimore, MD	aug.18.2008 - aug.21.2008	register
Greenville, SC	jun.3.2008 - jun.6.2008	register

who can benefit

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

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 UDB Control Center
	SQL
	Workstation hardware
	Windows desktop functionality
	DB2 and Windows scripting
	DB2 platform knowledge

skills gained

	Use WebSphere Information Integrator Q Replication to perform queue based data replication activities in a multiplatform environment
	Define WebSphere MQ V5.3 queues required by WebSphere Information Integrator Q Replication Version 8.2
	Differentiate between Q Replication's architecture and SQL Replication's architecture
	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 XML Publication transaction publishing capabilities
	Operate the various components of WebSphere Information Integrator Q Replication's Version 8.2 release
	Use DB2 Replication Center GUI to perform basic administration of sources and subscriptions
	Use ASNCLP, ASNTDIFF, and ASNTREPAIR
	Identify the problem determination facilities of WebSphere Information Integrator Q Replication
	Implement a bidirectional or peer-to-peer failover environment
	Modify existing Q subscriptions to replicate additional columns
	Discuss basic Q Replication performance considerations

course materials

The course materials cover WebSphere Information Integrator Queue Replication Version 8.2.

hands-on labs

Thirteen labs are included to address Queue Replication.

ibm education advantage program eligibility:

	Yes - IBM Education Card
	Yes - IBM Corporate Education Pass
	Yes - IBM Education Pack - online account

course content details

	An introduction to WebSphere MQ

	position messaging and queuing in today's business environment
	provide a high level view of WebSphere MQ functions
	describe how queue managers communicate with each other

	Overview of WebSphere II replication

	describe various reasons and needs for replication solutions
	review 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 federate 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 Replication Center'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 XML publications

	understand the background and requirements for publishing
	describe Q Replication's event publishing
	create an XML event publication
	list some of the targets of an XML event publication

	Utilities and performance

	describe and operate ASNTDIFF and ASNTREPAIR utilities
	describe and create a replication alert monitor
	operate the replication alert monitor
	understand Q Capture and Q Apply scalability
	list some performance techniques for Q Replication

	How does 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

	Command line processor

	perform ASNCLP functions in both command mode and file mode
	use ASNCLP to setup a replication environment
	use ASNCLP to perform Q replication tasks, such as Q subscription creation

	Q Replication processing

	understand the basic source and target requirements
	describe the Q Replication architecture
	describe the Q Capture architecture
	describe the Q Apply 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

	Daily Agenda :: Day 1

	welcome
	WebSphere MQ for the Q Replication administrator
	exercise - WebSphere MQ setup
	overview of DB2 II replication
	setting up a federated database
	exercise - setting up a federated database
	preparing the replication environment
	exercise - Q Replication configuration

	Day 2

	performing unidirectional replication
	exercise - unidirectional replication setup
	operating Q Capture and Q Apply
	exercise - operating Q Capture and Q Apply
	exercise - stored procedure replication
	bidirectional and peer-to-peer replication
	exercise - bidirectional Q Replication

	Day 3

	exercise - peer-to-peer replication
	creating XML publications
	exercise - XML publishing
	utilities and performance
	exercise - monitoring and utilities
	how does Q Replication work?
	command line processor
	exercise - using ASNCLP

	Day 4

	Q Replication processing
	exercise - adding columns and changing schemas
	failover consideration
	exercise - conflict detection
	performance considerations