Faites confiance à votre formation en TI |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.
ExitCertified renforce sa relation avec Red Hat en obtenant le statut de revendeur avancés.
Oracle University décerne à ExitCertified le prix de Qualité exceptionnelle des instructeurs.
ExitCertified en vedette dans le répertoire des Entrepreneurs dynamiques du 21e siècle.
ExitCertified est mis en candidature une troisième fois pour les prix de la Chambre de commerce.
ExitCertified élargit sa relation avec Apple en ajoutant la diffusion de formation agréée Mac OS à Phoenix, en Arizona.
 |
SQL Replication: Advanced Topics (CE231) |
 |
|
| Format: Formation en classe avec formateur |
| Autres formats: |
|
|
|
|
|
|
| |
This course replaces DW154. This is the Classroom version of the Instructor Led On Line course 3E231. 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 Using SQL Replication (CE22). 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. |
|
|
|
|
|
|
|
 |
|
 |
Compétences acquises |
| |
- 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
|
|
|
|
| |
 | Ce cours est donné par des formateurs certifiés IBM.
À titre de partenaire en formation agréée , ExitCertified peut vous inscrire à n’importe quel cours en Amérique du Nord.
Il y a une différence. Découvrez-la  |
|
 |
| Code: |
CE231 |
| Format: |
Formation en classe avec formateur |
|
| Durée: |
2 days |
| Certifié par: |
IBM |
|
| Frais d’inscription (CAD): $contact |
|
|
 |
|
|
|
|
| | | | | Towson/Baltimore, MD | Nov.29 - Nov.30.2012 |  | | | 1 Dates Offered | | | |
|
|
|
SQL Replication: Advanced Topics (CE231) Contenu détaillé |
| |
| |
- 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
| |
- 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
| |
| |
| |
- 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
| |
| |
|
