CE24: Using Queue Replication

Code: CE24
Duration: 4 days


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.


  • 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.


You should have 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
  • SQL
  • DB2 platform knowledge


Classroom and hands on lab exercises.

This course is offered as web-based training. Please contact us for more information.

Course Schedule »