The IBM DB2 Cloning Tool might also provide a solution. -----Original Message----- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of farzad yazdi Sent: Friday, April 17, 2009 5:56 PM To: IBM-MAIN@bama.ua.edu Subject: Re: Is Xrc a reasonable solution between two databases created separately(in DB2)?
Tim, thanks for the clarification and bringing things out in the open. We have the remote distance GDPS/XRC in hand for DR and there are no major problems with that. The issue here is for a local site and I guess the broad question to ask is, if it is possible to do a mirroring of selected DB2 tables' underlaying linear VSAMs from one DSN to another (locally) without the intervention of the source DB2's CPU. We know we can do this but are somewhat unclear about what would happen when the VSAMs get extends, what would happen in source table reorgs, etc. Would any of the tools you have mentioned, like DDF and DRDA, allow the use of certain table replication/propagation without the intervention of the source CPU? ________________________________ From: IBM Mainframe Discussion List on behalf of Timothy Sipples Sent: Thu 16/04/2009 17:57 To: IBM-MAIN@bama.ua.edu Subject: Re: Is Xrc a reasonable solution between two databases created separately(in DB2)? I'm still a little unclear on your exact situation, but I think I'm starting to understand. Do you mean GDPS/XRC, for example? (Are these two databases separated by some distance?) I expect you'll get more thoughts in reply. I tend to think of XRC-based approaches as more appropriate for like-for-like (asynchronous, with XRC) mirroring -- storage-oriented with database awareness -- but you've talked about how the source and target databases are somehow different in construction. I think you might want to expand your investigation list, as another commenter suggested. It's probably easier to list most or all of the options, then relatively quickly eliminate some of them. DB2 for z/OS itself supports linking multiple DB2s through DDF and DRDA. This doesn't require copying the data -- it allows "parent" and "child" DB2s, basically. (Or "local" and "remote.") Sometimes people asking about copying or replication don't actually need copying or replication, so that's why I mention this. It's an integral DB2 for z/OS feature, so you already have it. Then you've got a bunch of replication technologies, in addition to XRC, with varying capabilities. Another commenter mentioned two of them (IBM DB2 DataPropagator for z/OS and ENET RRDF). Actually, the successor to DataPropagator (and Q Replication) is IBM InfoSphere Replication Server for z/OS (5655-R55), so that's what you want to look for if DataPropagator looks interesting. Yet another option is IBM InfoSphere Change Data Capture for z/OS (5655-U96). If you were looking for DataMirror, then InfoSphere CDC is what you are looking for now. There are a lot of options if this is a one-time only event (or near one-time only). Unloads and loads, for example. I assume you're not asking about that. There are no doubt other options, but that's a good list for the time being, pending more information., - - - - - Timothy Sipples IBM Consulting Enterprise Software Architect Based in Tokyo, Serving IBM Japan / Asia-Pacific E-Mail: timothy.sipp...@us.ibm.com ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html