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.
 |
Using SQL Replication (CE221) |
 |
|
| Format: Formation en classe avec formateur |
| Autres formats: |
|
|
|
|
|
|
| |
This replaces Course Code DW145. This is the Classroom version of the Instructor Led Online Course 3E221. This course is designed to provide you the ability to use DB2 SQL Replication to perform data replication activities between IBM relational database systems, and also between IBM relational database systems and other non-IBM 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 z/OS 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 Universal Database for Linux, UNIX and Windows. |
|
|
|
|
|
|
|
 |
|
 |
Compétences acquises |
| |
- Setup a DB2 Federated database in order to use InfoSphere Federated Server to replicate to non-IBM 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 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
|
|
|
|
|
Qui peut en profiter |
| |
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. |
|
|
|
|
Special note |
| |
IBM Education Advantage Program Eligibility:
|
| |
Yes - IBM Education Pack - online account
| | | |
|
|
|
| |
 | 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: |
CE221 |
| Format: |
Formation en classe avec formateur |
|
| Durée: |
3 days |
| Certifié par: |
IBM |
|
| Frais d’inscription (CAD): $contact |
|
|
 |
|
|
|
|
| | | | | Towson/Baltimore, MD | Nov.26 - Nov.28.2012 |  | | | 1 Dates Offered | | | |
|
|
|
Using SQL Replication (CE221) Contenu détaillé |
| |
| |
| 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 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, and Nicknames
| |
| 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 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 targets
| |
| |
- Welcome
- Unit 1 - Overview of DB2 SQL Replication
- Unit 2 - Setting up a Federated Database
- Exercise 1
- Unit 3 - Preparing the Replication Environment
- Exercise 2 (including review)
- Unit 4 - Creating Replication Sources
| |
- Unit 4 - Creating Replication Sources
- Exercise 3 (including review)
- Unit 5 - Creating Replication Subscriptions
- Exercise 4 (including review)
- Unit 6 - Operating Capture and Apply
| |
- Exercise 5 (including review)
- Unit 7 - Subscription Set Processing (to Update-Anywhere)
- Exercise 6 (including review)
- Unit 7 - Subscription Set Processing (Continued - UA)
- Exercise 7 (including review)
- Unit 8 - Replication Administration
- Unit 9 - Designing a Data Replication System
| |
| |
|
