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 (SPVC) (2E221) |
 |
|
| Format: Formation en classe avec formateur |
| Autres formats: |
|
|
|
|
|
|
| |
This is the Self-Paced version of Classroom course Using SQL Replication (CE221) and Instructor-Led Online course Using SQL Replication - Instructor Led Online (3E221) and Web-based course Using SQL Replication (Web Based) (1E221). This is a self-paced online course and includes hands-on remote labs. The average amount of time to complete this course is 24 hours. Once you receive your access information, you will have 60 days to complete this course and its labs. 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 audio, video and remote labs. 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 for Linux, UNIX and Windows. 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, but lab system access is allocated on a first-come, first-served basis. You will have a total of 40 hours allocated to complete all of the lab exercises, so when you are not using the system, ensure that you log out to maximize ability to use the lab system. 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. |
|
|
|
|
|
|
|
 |
|
 |
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. |
|
|
|
| |
 | 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: |
2E221 |
| Format: |
Formation en classe avec formateur |
|
| Durée: |
< select item > days |
| Certifié par: |
IBM |
|
| Frais d’inscription (CAD): $contact |
|
|
 |
|
|
|
|
 | Ce cours n'est pas prévu à l'horaire pour l'instant. Si vous êtes intéressé à suivre ce cours, utilisez le lien ci-dessous pour demander une date. |
|
|
|
Using SQL Replication (SPVC) (2E221) 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
| |
- Unit 1 - Overview of DB2 SQL Replication
- Unit 2 - Setting up a Federated Database
- Exercise 1
- Unit 3 - Preparing the Replication Environment
- Exercise 2
- Unit 4 - Creating Replication Sources
- Unit 4 - Creating Replication Sources
- Exercise 3
- Unit 5 - Creating Replication Subscriptions
- Exercise 4
- Unit 6 - Operating Capture and Apply
- Exercise 5
- Unit 7 - Subscription Set Processing (to Update-Anywhere)
- Exercise 6
- Unit 7 - Subscription Set Processing (Continued - UA)
- Exercise 7
- Unit 8 - Replication Administration
- Unit 9 - Designing a Data Replication System
| |
| |
|
