Data replication for DB2, Oracle, VSAM

Alison Pelletier

Data replication for DB2, Oracle, VSAM
Hello.

Does anyone (customers) have firsthand experience, they wouldn't mind sharing, with IBM's Q Replication? Do you know of any other products that are resilient enough to handle high volume DB2 for z/OS to DB2 for z/OS bidirectional active/active replication? It would be of added interest, if it also handles VSAM to VSAM unidirectional, and Oracle to DB2 and DB2 to Oracle unidirectional. Feel free to contact me offline, if you prefer.

Thanks,

Alison Pelletier
Discover Financial Services
[login to unmask email]
(801) 902-4184

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Robert Brock

Re: Data replication for DB2, Oracle, VSAM
(in response to Alison Pelletier)
Hi Alison,

One of the biggest issues I know of with the IBM toolset for what you would
like to accomplish is you are looking at several components to get
everything done. Q Rep is an older version of one of the IBM infosphere
line of products. It was originally a newer version of Data Propagator that
was modified to use MQ. I believe you would need multiple capture
components and event publishers to process the variety of data that you
referenced in your message. I replied to a similar message last week asking
about overhead associated with infosphere and gave my recommendation of
SQData as an alternative to the IBM offerings. One tool from SQData could
accomplish everything you listed without going the ala carte route. I've
worked with SQData at a couple customers doing very similar high performance
active/active projects with great success.

Thanks,
Bob Brock
Krypton Consulting LLC
800-687-8884

----- Original Message -----
From: "Alison Pelletier" <[login to unmask email]>
Sent: Friday, January 07, 2011 2:12 PM
Subject: Data replication for DB2, Oracle, VSAM


Hello.

Does anyone (customers) have firsthand experience, they wouldn't mind
sharing, with IBM's Q Replication? Do you know of any other products that
are resilient enough to handle high volume DB2 for z/OS to DB2 for z/OS
bidirectional active/active replication? It would be of added interest, if
it also handles VSAM to VSAM unidirectional, and Oracle to DB2 and DB2 to
Oracle unidirectional. Feel free to contact me offline, if you prefer.

Thanks,

Alison Pelletier
Discover Financial Services
[login to unmask email]
(801) 902-4184

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it!
*
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

David Tolleson

Re: Data replication for DB2, Oracle, VSAM
(in response to Robert Brock)
Hi, Alison,

An IBM software sales rep can put you in contact with reference customers for Q Replication. There are also some customer presentations from IOD that are available at ibm.com. I have two about active-active linked from a post on ChannelDB2:

http://www.channeldb2.com/profiles/blogs/2010s-10-most-popular

Bob,

SQL Replication (aka DataPropagator) is IBM's older replication technology. It's been around since the early 1990's. Q Replication is a newer technology, delivered in about 2004. It shares some commands and utilities with SQL Replication, but is not a newer version of SQL Replication.

For Alison's DB2-DB2, DB2-Oracle, and Oracle-DB2, only one Capture program is needed per source. For example, the same Capture program can send changed data to both DB2 and Oracle. No event publishing function is required.

thanks
david

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv