This is the Classroom version of Instructor-led Online course Using Queue Replication - Instructor Led Online (3E243GB), Self-paced Virtual course (2E243GB) and Web-based course Web-based course Using Queue Replication - Web Based (1E243GB).
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.
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 exercises:
- Relational databases
- Database system design
- DB2 Control Center
- DB2 platform knowledge
- Unit 1 - WebSphere MQ for the Q Replication Administrator
- Unit 2 - Overview of WebSphere Replication Server
- Unit 3 - Setting Up a Federated Environment
- Unit 4 - Preparing the Replication Environment
- Unit 5 - Performing Unidirectional Replication
- Unit 6 - Operating Q Capture and Q Apply
- Unit 7 - Bidirectional and Peer-to-Peer Replication
- Unit 8 - Creating Publications
- Unit 9 - Utilities and Replication Monitoring
- Unit 10 - How Does Q Replication Work?
- Unit 11 - Command Line Processor
- Unit 12 - Q Replication Processing
- Unit 13 - Failover Considerations
- Unit 14 - Performance Considerations
- Use InfoSphere Replication Server to perform queue-based data replication activities in a multiplatform environment
- Define WebSphere MQ queues required by Q 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 ASNCLP
- Describe the Q Capture Schemas, Q Subscriptions, and Q Apply Browser components
- Highlight Q Replication's transaction publishing capabilities
- Use ASNTDIFF and ASNTREP to synchronize two tables
- Use the Replication Monitor to setup alert notification for chosen exceptions
- Discuss the implications of using bidirectional or two node peer-to-peer in a failover scenario
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.