SQL Replication: Advanced Topics

start > courses and registration > training feature sheet

code.

DW154

length.

2 days

type.

Instructor-Led

partner.

IBM

price.

$1,300

IACET credits 1.6

Learn to use advanced functions of DB2 DataPropagator, such as the command line processor, signal table usage, the general trace facility, and alert monitoring. In addition, learn the basic operations of the Capture, Apply, and Monitor components, including details of their use of control tables. Explore special techniques that can be employed to solve replication requirements more complex than those that can be implemented using the functions and techniques presented in:

»DW145 Using SQL Replication

Also, develop basic skills in problem determination and performance tuning.

Attend lectures and complete several intensive hands-on machine exercises with DB2 DataPropagator components: Capture, Apply, Monitor, and the Replication Center. Although you perform the machine exercises using the DB2 UDB for Linux, UNIX, and Windows on a Windows workstation, the skills you develop from these exercises are also applicable to the DB2 UDB for z/OS and OS/390 environment.

This course has been updated to Version 8 of DB2 DataPropagator and is applicable for the DB2 UDB for Linux, UNIX, and Windows or the DB2 UDB for z/OS and OS/390 environments. Most of it is also applicable to replication between either of these environments and the OS/400 platform, but commands and processes specific to this environment are not included in the course.

Towson/Baltimore, MD	feb.26.2009 - feb.27.2009	register

who can benefit

This intermediate course if for DB2 database administrators, programmers, IBM professionals, and other individuals, who administer DB2 DataPropagator replication applications, including designing and implementing complex replication solutions.

prerequisites

You should complete the following to gain basic data replication skills and you should have working knowledge of the basic usage of DB2 DataPropagator and UDB Control Center along with some on-the-job experience using DB2 DataPropagator and UDB Control Center to define and manage replication objects. Completing the lab exercises is easier if you also have skills with workstation hardware, Windows desktop functions, and SQL.

	Data Replication: Basic Usage (DW144) or
	Heterogeneous Replication with DB2 Information Integrator and DataPropagator (DW160)

skills gained

	Use the command line processor, asnclp, to create control tables, register source tables, and create subscriptions
	Explain DB2 DataPropagator control tables
	Describe details of selected capture, apply, and administration functional processes
	Explain representative techniques for accomplishing desired replication administration tasks beyond the basic operations of apply and capture
	Use DB2 DataPropagator problem determination facilities
	Relate basic performance considerations for replication operations

course materials

The course materials cover the DB2 DataPropagator function in DB2 UDB for Linux, UNIX, and Windows V8.2 and DB2 UDB for z/OS V8.

hands-on labs

Four labs are included to address DB2 DataPropagator.

training path

This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.

ibm education advantage program eligibility:

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

skill level

Advanced

course content details

	Review and introduction

	describe the general architecture of DB2 DataPropagator including its components, specific terminology, and control table structure
	explain the basic processes of Capture and Apply including the replication cycle, the Apply cycle, source registration, and subscription creation
	relate the basic administration and operational functions of the Replication Center
	discuss the use of DB2 DataPropagator in the Federated Database environment

	Command line processor

	perform asnclp functions in both command mode and file mode
	use asnclp to set up a replication environment
	use asnclp to perform replication tasks, such as source registration and subscription creation

	How does DB2 DataPropagator work?

	describe how the control tables are used by the processes that define the replication environment, register and manage sources, and create and manage subscriptions
	explain the major Capture processes and control table usage for:
	accessing the DB2 Log and tracking its progress
	responding to signals
	avoiding cyclic updates
	pruning control tables
	performing interval commits
	recording monitor information
	discuss the Apply processes and control table usage for:
	finding subscriptions ready to be processed
	performing a full refresh
	finding new changes
	replicating qualified changes
	completing the subscription cycle
	relate the basic operational characteristics of the Monitor processes:
	report operational status and gather and report historical statistics
	monitor alert conditions and send alerts
	report monitor activities

	Administration techniques

	explain how to perform the following replication techniques:
	filter changes
	force Apply to perform a full refresh
	use the Signal table to affect source capture and subscription processing activities
	add a member to a set without full refresh of the whole set
	add a new source table column to the replication definitions
	change/split Capture schemas
	promote registrations and subscriptions
	implement a peer-to-peer replication process

	Problem determination and resolution

	list the DB2 DataPropagator diagnostic tools for problem determination activities
	identify the contents of traces, trace tables, and message logs
	use the Replication Center to determine operational status of Capture and Apply
	operate the Monitor program including setup and start actions, specification of alert conditions, and produce alert reports
	describe and operate asntdiff and asntrepair utilities
	use messages, traces and log files to define a problem and possible resolutions for the problem

	Performance considerations

	use the Replication Center to produce static operational reports
	discuss possible settings, definitions, and actions that could improve the performance of the DB2 DataPropagator replication processes
	modify files and parameters that affect the performance of DB2 DataPropagator operations