Course description: SQL Replication: Advanced Topics (Web Based)

This is a self-paced online course. The average amount of time to complete this course is 16 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.

This course will provide you the ability to use advanced functions of DB2 SQL replication such as the Command Line Processor, Signal table usage, the general trace facility, and alert monitoring. In addition, you will learn the basic operations of the Capture, Apply, and Monitor components, including details of their use of control tables. This course also includes special techniques which can be used to solve replication requirements more complex than those that can be implemented using the functions and techniques presented in CE22, Using SQL Replication. It also provides basic skills in problem determination and performance tuning.

The course includes lectures and several intensive hands-on machine exercises with DB2 SQL replication components: Capture, Apply, Monitor, and the Replication Center. The machine exercises will be performed using the DB2 for Linux, UNIX, and Windows on a Windows workstation, but the skills developed from these exercises are also applicable to the DB2 for z/OS environment.

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.

This is the Web-Based version of Classroom course SQL Replication: Advanced Topics (CE231), Instructor-Led Online course SQL Replication: Advanced Topics - Instructor Led Online (3E231) and Self-Paced Virtual course SQL Replication: Advanced Topics (SPVC) (2E231).

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 intermediate course is for persons who will be administering DB2 SQL replication applications including designing and implementing complex replication solutions. This would include DB2 Database Administrators, programmers, and IBM professionals.

Back to top

You should have:

• a working knowledge of the basic usage of DB2 SQL replication and the Replication Center.

Performing the lab exercises will be easier if you have usage skills with workstation hardware, Windows desktop functions, and SQL.

These skills could be obtained by completing the course Using SQL Replication (CE22), plus some on-the-job usage of DB2 SQL Replication and Replication Center to define and manage replication objects.

Back to top

• Use the command line processor, asnclp, to create control tables, register source tables, and create subscriptions
• Explain DB2 SQL Replication 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 SQL Replication problem determination facilities
• Relate basic performance considerations for Replication operations

Back to top

Review and Introduction

• Describe the general architecture of DB2 SQL replication 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 SQL replication in the federated database environment

Command Line Processor

• Perform asnclp functions in both command mode and file mode
• Use asnclp to setup a replication environment
• Use asnclp to perform replication tasks, such as source registration and subscription creation

How Does DB2 SQL Replication 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, and 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, and 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, and 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, and Implement a peer-to-peer replication process

Problem Determination and Resolution

• List the DB2 SQL Replication 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 asntrep 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 SQL Replication replication processes
• Modify files and parameters that affect the performance of DB2 SQL Replication operations

Agenda

• Unit 1 - Review and Introduction
• Unit 2 - Command Line Processor
• Exercise 1 - Command Line Processor
• Unit 3 - How Does DB2 SQL Replication Work?
• Exercise 2 - Control Tables
• Unit 4 - Administration Techniques, Part 1 (through Schema changes)
• Exercise 3 - Administration Techniques
• Exercise 3 - Administration Techniques (Continued)
• Unit 4 - Administration Techniques, Part 2 (from New Member)
• Unit 5 - Problem Determination and Resolution
• Exercise 4 - Problem Determination
• Unit 6 - 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