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.
What You'll Learn
- 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
Who Needs to Attend
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.
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.
- Using SQL Replication (CE221G )
There are no follow-ons for this course.
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
- 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
- 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
- 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