real-time replication DB2 zOS to SQLServer 2005?

Robert Brock

real-time replication DB2 zOS to SQLServer 2005?
Hi Larry,

You might want to look at SQData as an alternative. The original DataMirror
product that morphed into Infosphere CDC for z was developed for the iSeries
platform originally and ported to z. SQData was developed specifically for
the mainframe environment and as such I suspect you will see better
performance out of SQData. As you mentioned also I think you will find the
license associated with SQData will be more palatable to your customer than
the IBM alternatives. Feel free to contact me offline if you would like to
discuss how a couple of other CSC customers that I'm familiar with are using
SQData today to accomplish similar things.

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

----- Original Message -----
From: "Larry D'Agostino" <[login to unmask email]>
Sent: Wednesday, December 29, 2010 11:07 AM
Subject: Re: real-time replication DB2 zOS to SQLServer 2005?


Hi Wayne,

I have a client who is looking for options to access DB2 z/OS V8 order and
invoice data from a Microsoft SQL/Server 2008. Two of the options they came
up with are Infosphere and SQL/Server Linked Server. I saw your post about
Infosphere and was intrigued. When you write the CPU usage averaged around
4-5 % of CPU, how many MIPs are you running on the LPAR where Infosphere
resides ? Are all processors available to this LPAR ?

I am asking, because my client is MIP-constrained .. running a Z10 box with
300 MIPs and 3 CPs ...... already running it flat out for large chunks of
the day. Aside from the license cost of Infosphere, resource utilization is
a concern. This client is probably going to end up trying to obtain
near-real-time data and pull frequently. The largest DB2 tables are 300 M
rows. DB2 updates would be 500,000 + an hour.

Any input would be appreciated

Thanks,


Larry

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information.
*
** DB2 certification -> no additional charge
** Meet fellow DB2 users and leading DB2 consultants
_____________________________________________________________________

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
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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

Larry D'Agostino

Re: real-time replication DB2 zOS to SQLServer 2005?
(in response to Robert Brock)
Phil -

Thanks for the response. Your points made are valid. Just as FYI .. the client bought a Microsoft E-Commerce Solution and they want to use MIcrosoft Fast Search on SQL/Server. Want to control the data .. don't want it in DB2, because they don't control it. But right now the only place where the data exists is in DB2.

Larry

_____________________________________________________________________
* 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