Farzad, That's true, but it does not change me answer. There's no free lunch in this. XRC, TrueCopy, PPRC, SRDF, HUR, etc are all designed to copy volumes. The volume is the only level of granularity that is understood. These products are not aware of VTOC, Datasets, VVDS, UCAT or DB2 System Tables, all they track is whether there is a change to a track or not.
If you are using a DB2 instance on one LPAR to access tablespaces that are being updated, via XRC, on another system then you must expect to continuously have database integrity problems as the changes propagated by XRC will not be reflected in theDB2 buffers or catalogs. I've been forced to try this with CICS/VSAM and DB2 on SRDF and failed as expected. I've also tried it with RRDF and CA/IDMS and it was problematic with around four failures a day. If any of your source tablespaces take another extent on another volume, the secondary DB2 will have no idea. The only method I'm aware of that is problem free is IBM InfoSphere Replication Server for z/OS (thanks Tim) as it publishes and applies changes through the secondary database instance, with a lot of granularity as to what is copied. With the updates applied as a UOW through the DB2 instance there are no integrity problems to deal with. So if you want real time data I'm not aware of a way to do it without burning MIPS on the primary LPAR. Ron > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of > farzad yazdi > Sent: Thursday, April 16, 2009 10:42 PM > To: [email protected] > Subject: Re: [IBM-MAIN] ****SPAM**** Re: Is Xrc a reasonable solution between > two databases created separately(in DB2)? > > Ron I don't know about PRDF but Progagator does put a load on the source CPU > which isn't desirable. This is what's different and quite nice about XRC. > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
