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: [email protected] ---------------------------------------------------------------------- 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
