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 Queue Replication (CE243) |
 |
|
| Format: Formation en classe avec formateur |
| Autres formats: |
|
|
|
|
|
|
| |
This course replaced Using Queue Replication (CE242). This is the classroom version of Instructor Led OnLine Using Queue Replication - Instructor Led Online (3E243). Gain knowledge on InfoSphere Replication Server and how it is used to perform both queue-based homogeneous data replication and heterogeneous data replication. Learn to distinguish the differences in functionality of the queue architecture's highly parallel, transaction-based, asynchronous message-based transmission capability with the SQL based architecture. Use the Replication Center Graphical User Interface (GUI) to perform the Q Replication operations necessary to define, manage, and maintain queue-based data replication functions for DB2 for z/OS and DB2 for Linux, UNIX, and Windows. Additionally, incorporate the use of the ASNCLP command line interpreter for definitional tasks, along with utilities such as ASNTDIFF and ASNTREP and the Q Replication Dashboard, in your replication environment. Discover how InfoSphere Replication Server can be engaged to publish transactions in either an Extensible Markup Language (XML) format or in a character delimited format. Become versed in the use of the WebSphere MQ queues required by InfoSphere Replication Server. Included are a number of intensive hands-on machine exercises demonstrating InfoSphere Replication Server's capabilities in unidirectional replication as well as multidirectional replication. Linux will serve as the control point for administering the InfoSphere Replication Server for Linux, UNIX, Windows, and z/OS. This course replaced CE242. Â This is the classroom version of Instructor Led OnLine 3E243. |
|
|
|
|
|
|
|
 |
|
 |
Compétences acquises |
| |
- Use InfoSphere Replication Server to perform queue based data replication activities in a multiplatform environment
- Define WebSphere MQ queues required by Q Replication
- Differentiate between the architectures of Q Replication and SQL Replication
- Detail each of the four basic tasks performed during Q Replication (preparation, infrastructure, definitional, and operational)
- Define, manage, and maintain queue based data replication functions using the Replication Center GUI
- Describe the Q Capture Schemas, Q Subscriptions, and Q Apply Browser components
- Highlight Q Replication's transaction publishing capabilities
- Operate the various components of Q Replication
- Use DB2 Replication Center GUI to perform basic administration of sources and subscriptions
- Use ASNTDIFF and ASNTREP
- Discuss basic Q Replication performance considerations
|
|
|
|
|
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 a highly parallel, transaction-based, asynchronous queue message-based transmission 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: |
CE243 |
| Format: |
Formation en classe avec formateur |
|
| Durée: |
4 days |
| Certifié par: |
IBM |
|
| Frais d’inscription (CAD): $contact |
|
|
 |
|
|
|
|
| | | | | Towson/Baltimore, MD | Jun.18 - Jun.21.2012 |  | | | Towson/Baltimore, MD | Aug.27 - Aug.30.2012 | | | | Towson/Baltimore, MD | Sep.24 - Sep.27.2012 | | | | 3 Dates Offered | | | |
|
|
|
Using Queue Replication (CE243) Contenu détaillé |
| |
| |
| WebSphere MQ for the Q Replication Administrator | - Position messaging and queuing in today’s business environment
- Provide a high level view of WebSphere MQ functions
- Describe how to place data into a queue owned by a remote queue manager
| |
| Overview of WebSphere Replication Server | - Describe various reasons and needs for replication solutions
- Overview SQL Replication and the need for Q Replication
- Describe the Q Replication and Event Publishing Architectures
- List Q Replication components and administration tasks
- Discuss the methodology and functionality of Q Replication
| |
| 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
- Nicknames
- Discuss how federated objects are stored within the DB2 catalog
- Determine the correct troubleshooting actions when the access to remote data objects cannot be successfully verified
| |
| 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
- Start the RC's Launchpad and utilize its quick operation capabilities
- Name and describe the WebSphere MQ queues used for Q Replication
- Describe the control tables used by Q Capture and Q Apply
- Create the required control tables
| |
| Performing Unidirectional Replication | - List the types of Q Replication and types of Q subscriptions
- Describe unidirectional replication
- Create a unidirectional queue mapping
- Create a unidirectional subscription
- Create a stored procedure subscription
| |
| Operating Q Capture and Q Apply | - Start Q Capture in the z/OS, Linux, UNIX, and Windows environments using operating system facilities and the Replication Center
- Start Q Apply in the z/OS, Linux, UNIX, and Windows environments using operating system facilities and the Replication Center
- Use operational commands to control Q Apply and Q Capture processing
- Change Q Capture and Q Apply parameters
- Use Replication Center for diagnostic inquiries
- Troubleshoot Q Capture and Q Apply processes
| |
| Bidirectional and Peer-to-Peer Replication | - Overview the need for and concerns of multidirectional replication
- List the various types of multidirectional replication solutions available in Q Replication
- Describe bidirectional replication and learn how to create bidirectional subscriptions
- Describe peer-to-peer Replication and learn how to create peer-to-peer subscriptions
| |
- Understand the background and requirements for publishing
- Describe Q Replication's Event Publishing capabilities
- Create a publishing queue map
- Create a publication
| |
| Utilities and Replication Monitoring | - Describe and operate asntdiff and asntrep utilities
- Invoke the Q Analyzer utility
- Describe the Replication Center’s reporting capabilities
- Create a Replication Alert Monitor
- Operate the Replication Alert Monitor
- Use the Q Replication Dashboard
| |
| |
| How Does Q Replication Work? | - Explain the major Q Capture processes and control table usage
- Discuss the Q Apply processes and control table usage
- Relate the basic operational characteristics of the Monitor processes
| |
- • Perform ASNCLP functions in both command mode and file mode
- • Use ASNCLP to setup a Q Replication environment
- • Use ASNCLP to perform replication tasks, such as Q subscription creation
| |
- •Understand the basic Source and Target requirements
- •Describe the Q Replication architecture
- •Describe the Subscription process
- •Differentiate Value-based Conflict Resolution from Version-based
- •Add a column to a Q subscription
- •Move a Q subscription to a new Q Capture schema
| |
- •Specify the correct conflict detection for a Bidirectional failover scenario
- •Describe the proper conflict resolution for a Bidirectional failover scenario
- •List the potential sources of conflicts
- •Describe the switchback considerations
| |
| Performance Considerations | - •Discuss possible settings, definitions, and actions that could improve the performance of Q Replication processes
- •Modify parameters that affect the performance of Q Replication operations
| |
| |
- Welcome
- Unit 1 - Websphere MQ for the Q Replication Administrator
- Exercise 1 - WebSphere MQ Setup
- Unit 2 - Overview of WebSphere Replication Server
- Unit 3 - Setting up a Federated Database
- Exercise 2 - Setup the Federated Environment
- Unit 4 - Preparing the Replication Environment
- Exercise 3 - Q Replication Configuration
| |
- Unit 5 - Performing Unidirectional Replication
- Exercise 4 - Unidirectional Replication Setup
- Unit 6- Operating Q Capture and Q Apply
- Exercise 5 - Operating Q Capture and Apply
- Unit 7 - Bidirectional and Peer-to-Peer Replication - Bidirectional
- Exercise 6 - Bidirectional Q Replication
| |
- Unit 7 - Bidirectional and Peer-to-Peer Replication - P2P
- Exercise 7 - Peer-to-Peer Replication
- Unit 8 - Creating XML Publications
- Exercise 8 - XML Publishing
- Unit 9 - Utilities and Monitoring
- Exercise 9 - Monitoring and Utilities
- Unit 10 - How Does Q Replication Work?
- Unit 11 - Command Line Processor
- Exercise 10 - Using ASNCLP
| |
- Unit 12 - Q Replication Processing
- Exercise 11 - Adding Columns and Changing Schemas
- Unit 13 - Failover Consideration
- Exercise 12- Conflict Detection
- Unit 14 - Performance Considerations
| |
| |
|
