Using Queue Replication

start > courses and registration > training feature sheet

code.

CE242

length.

4 days

type.

Instructor-Led

partner.

IBM

price.

$2,600

Skill level: Intermediate

Gain knowledge on WebSphere Replication Server using WebSphere MQ, and how it is used to perform queue-based data replication activities between DB2 tables and from DB2 tables to non-DB2 Relational tables.

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 console command interpreter for definitional tasks, along with utilities such as ASNTDIFF and ASNTREP, in your replication environment.

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

Included are a number intensive hands-on machine exercises demonstrating WebSphere Replication Server's capability utilizing the Windows platform as a control point for administering the WebSphere Replication Server for Linux, UNIX, Windows, and z/OS.

Towson/Baltimore, MD	nov.10.2008 - nov.13.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

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

skills gained

After completing this course, you should be able to:

	Use WebSphere Information Integrator Replication Edition to perform queue based data replication activities in a multiplatform environment
	Define WebSphere MQ queues required by WebSphere Information Integrator 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 XML Publication transaction publishing capabilities
	Operate the various components of WebSphere Information Integrator Q Replication
	Use DB2 Replication Center GUI to perform basic administration of sources and subscriptions
	Use ASNTDIFF and ASNTREPAIR
	Discuss basic Q Replication performance considerations

course content details

	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