Course description: Using Queue Replication - Web Based

This is a self-paced online course. The average amount of time to complete this course is 24 hours. Once you receive your access information, you will have 1 year to complete this course.

Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course.

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.

The self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours.

View this course in other countries

Training Paths that reference this course are:

• Replication

Back to top

IBM Education Advantage Program Eligibility:

• Yes - IBM Education Pack - online account

Back to top

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.

Back to top

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

Back to top

• 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

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

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

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

• 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
• 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
• 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
• Unit 12 - Q Replication Processing
• Exercise 11 - Adding Columns and Changing Schemas
• Unit 13 - Failover Consideration
• Exercise 12- Conflict Detection
• Unit 14 - Performance Considerations

Back to top

HW/SW CONFIGURATION

The minimum hardware and software required to launch the course are:

• Reliable HIGH-SPEED INTERNET connection (min 200 kbps up and down)
• Windows 2000 or XP or Vista
• Computer with soundcard
• Headset or computer speakers
• Internet Explorer 5.01 or later, or Firefox 1.0 or later

Network Speed Test

http://clpext.moppssc.com/index.php?option=com_wrapper&view=wrapper&Itemid=8

User: clp

Pass: ibmeduc

For example, a speed test against the server with a slow connection of 140 Kbps download and 28 Kbps upload took 14 minutes to load a 30min recording before the video began. Extrapolate from this result to estimate approximately how fast your network internet access would be.

High-speed broadband internet access is the recommended configuration for this course.

Keyboard Configuration

If you use a different character keyboard, you may experience errors when entering passwords. If possible, change your language/country settings for your keyboard to USA, which allows you to enter characters as in a QWERTY keyboard.

Back to top