Using SQL Replication

start > courses and registration > training feature sheet

code.

DW145

length.

3 days

type.

Instructor-Led

partner.

IBM

price.

$1,950

This course is designed to provide you the ability to use SQL Replication capabilities of DB2 9 to perform data replication activities between IBM DB2 relational database systems, and also between IBM DB2 relational database systems and other non-DB2 relational systems. This course will also teach how to perform the IBM Replication operations to define, manage, and maintain data replication functions for DB2 for OS/390 and DB2 for Linux, UNIX and Windows. Included are lectures and several intensive hands-on machine exercises with DB2 SQL Replication on Windows workstations using DB2 9 for Linux, UNIX and Windows.

After completing this course, you are encouraged to attend:

	SQL Replication: Advanced Topics (DW154)
	To minimize travel, DW145 and DW154 are normally scheduled back to back in the same week.
	You may also sign up for both of these courses at a reduced price by using course code:
	SQL Replication Mini-Curriculum (U5745)

Towson/Baltimore, MD	feb.23.2009 - feb.25.2009	register
Towson/Baltimore, MD	jun.15.2009 - jun.17.2009	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 an SQL based replication architecture. This includes all individuals who perform or support evaluation, implementation, and usage activities for data movement, data availability, and data replication.

prerequisites

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

skills gained

After completing this course, you should be able to:

	Setup a DB2 Federated database in order to use WebSphere Federated Server to replicate to and from non-DB2 relational database systems.
	Use DB2 SQL Replication to perform data replication activities in both a multiplatform and a multivendor environment
	Register source tables and define subscriptions using the DB2 Replication Center
	Describe DB2 SQL Replication's basic components and control tables
	Operate the various components of DB2 SQL Replication
	Use DB2 Replication Center to perform basic administration of sources and subscriptions
	Discuss basic replication performance considerations
	Identify the problem determination facilities of DB2 SQL Replication

note

This course is applicable for the DB2 for Linux, UNIX, and Windows or the DB2 for z/OS 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 the OS/400 environment are not included in the course.

ibm education advantage program eligibility:

Yes - IBM Education Pack - online account

related courses, exams and materials

	after related training and products

	DW154 SQL Replication: Advanced Topics
	U5745 SQL Replication Mini-Curriculum

course content details

	Overview of DB2 SQL Replication

	List DB2 SQL Replication features and components
	Describe the basic component architecture
	Discuss data staging concepts
	Explain how the DB2 replication architecture is extended to multi-vendor data replication
	List non-DB2 heterogeneous replication sources and targets

	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
	Describe the control tables used by Capture and Apply
	Create the required control tables
	Customize the control table profile

	Creating Replication Sources

	Define tables as replication sources using the Replication Center
	View and modify existing source registrations using the RC
	Determine objects related to a specific registered source
	Define profiles to simplify defining replication sources

	Creating Replication Subscriptions

	Create a subscription for a registered source using the Replication Center
	View and modify existing subscriptions using the RC
	Determine objects related to a specific subscription

	Operating Capture and Apply

	Start Capture in the z/OS, Linux, UNIX, and Windows platforms using operating system facilities
	Start Apply in the z/OS, Linux, UNIX, and Windows platforms using operating system facilities
	Use operational commands to control Apply and Capture processing
	Start Capture and Apply using the Replication Center

	Subscription Set Processing

	Explain how Apply processes subscription sets to accomplish selected replication functions
	Define a Replication Source which will allow Update-anywhere functions
	Define a Replication Subscription which will allow Update-anywhere functions
	Explain the Update-anywhere process and the Apply and Capture functions supporting the process

	Replication Administration

	Use the Replication Center to activate, deactivate, delete, and modify existing replication sources and subscriptions
	List the DB2 SQL Replication facilities for problem determination activities
	Identify the contents of traces, trace tables and message logs
	Describe the major factors and characteristics affecting the performance of DB2 SQL Replication

	Designing a Federated Data Replication System

	Explain the major factors of a good replication design
	Discuss design options for the various replication scenarios with DB2 replication sources and DB2 replication targets
	Discuss design options for the various replication scenarios with non-DB2 replication sources and targets

	Day 1

	Welcome
	Unit 1 - Overview of DB2 SQL Replication
	Unit 2 - Setting up a Federated Database
	Exercise 1 Setup the Federated Environment
	Unit 3 - Preparing the Replication Environment
	Exercise 2 Creating Control Tables
	Unit 4 - Creating Replication Sources

	Day 2

	Unit 4 - Creating Replication Sources
	Exercise 3 Registering Tables and Views
	Unit 5 - Creating Replication Subscriptions
	Exercise 4 Creating Subscription Sets
	Unit 6 - Operating Capture and Apply

	Day 3

	Exercise 5 Operating Capture and Apply
	Unit 7 - Subscription Set Processing (to Update-Anywhere)
	Exercise 6 Subscription Processing
	Unit 7 - Subscription Set Processing (Continued - UA)
	Exercise 7 Update Anywhere
	Unit 8 - Replication Administration
	Unit 9 - Designing a Federated Data Replication Environment