Articles & Content
Topic: DB2 for z/OS
DATE: 2010-11-11 (09:45 - 10:45)
SPEAKERS: Frederic Bothy (Toyota Motor Europe)
The goal of this presentation is to share our user experience with â IBM Infosphere Q-Replication & Event Publisherâ ?.Indeed, IBM manuals contain all the info you need to build a brand new online replication process with Q-rep or an CSV or XML output file with Event Publisher.But it does not give a lot of information (if any) on how to:- migrate from an existing replication process.- setup your DB2, Websphere MQ, Q-REP and monitoring tools.- handle data model changes on the source & target databases.- fix the replication issues you will encounter. - replicate data both synchronously and asynchronously, for different applications, on different lpar's.By attending this session, you will have a clear idea on how to plan, build, monitor & debug an online replication process.
EXP. LEVEL: Intermediate
DB2, Websphere MQ series, Q-Replication & Event Publisher setup for high availability.Activate subsystems monitoring, alerting & debugging. Share encountered problems at setup and applied countermeasures.
Implementation of â IBM Infosphere Event Publisherâ ?.Creation of CSV or XML output files using Event Publisher and REXX/C application programs. Best practices.
Creation & monitoring of Q-rep & Event Publisher applications through the DB2 Replication Center, the IBM Infosphere Replication Dashboard and an in-house ISPF application.
Implementation of an online replication with low latency & high throughput on the same or on separate LPAR's. Impact of DB2 data model changes on the replication process.
Usage of Q-REP for batch replication.Replacement of Log scan & apply utilities. Replication to â Consistent Change-Data â CCDâ ? tables (with before & after images). Impact of the migration on the existing data warehouse applications.
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.