Q
Get started Bring yourself up to speed with our introductory content.

Can I configure DB2 replication from the mainframe to AIX?

I want to replicate DB2 from the mainframe to an AIX box since it's cheaper and the copy can be used for testing. Is this possible?

DB2 replication options hinge on the integration skills available and how much you want to spend.

The least expensive way to move DB2 database information from the mainframe onto an AIX operating system involves DB2 utilities or writing custom code in-house. An unload on the mainframe followed by a load on AIX should suffice. You would need to write a home-grown program to perform any data transformation or masking tasks.

If you have a budget with room for DB2 replication, look into vendors that provide sophisticated tools that gather, transform and mask data from disparate sources in batch mode. Options include Treehouse Software's tcVISION, Attunity Replicate and others, or replication services from specialists like XTIVIA, Inc.

Another set of software tools asynchronously replicate data from the mainframe to AIX in near real time. Options include the open source SymmetricDS and DBReplicator tools.

Consider using IBM's DB2 for z/OS Distributed Data Facility (DDF), connecting the mainframe to other servers over a network. The transaction monitor offers thread pooling and connection management with z/OS workload management priority settings. You may use DDF to push data down to AIX or pull data from the mainframe as you run tests.

There is a drawback to pulling data -- it will stretch out response times as the rows make their way through the network.

Consider security whenever handling business data. In some mainframe shops, programmers will be required to mask the customer data pulled from production. Making the data as anonymous as possible protects the business from leaks without invalidating use, as with software testing.

About the author:
Robert Crawford spent 29 years as a systems programmer, covering CICS technical support, Virtual Storage Access Method, IBM DB2, IBM IMS and other mainframe products. He programmed in Assembler, Rexx, C, C++, PL/1 and COBOL. Crawford is currently an operations architect based in south Texas, establishing mainframe strategy for a large insurance company.

Next Steps

Look under the hood of IBM's BD2 BLU Acceleration, Netezza

DB2 BLU Acceleration vs. the competition

This was last published in March 2015

Dig Deeper on IBM system z and mainframe systems

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Join the conversation

4 comments

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

How much did you budget for DB2 replication this year?
Cancel
We're putting more budget into DB2 replication this year -- based mostly on the amount of time we lost to slow data transfers in 2014.
Cancel
Rather than writing a homegrown program, I would go with vendors that I could replicate the program as this would save time and headaches.
Cancel
Copying data from one DB2 system to another has been provided by IBM for well over 20 years. See https://www.ibm.com/developerworks/community/blogs/a82063fa-aecf-4716-81a4-8d33425a8735/entry/what_happened_to_datapropagator_on_z_os3?lang=en

IBM offers a choice of SQL based, or MQ based. Both can provide for ongoing replication (1) without hindering transaction processing on the database of record, and (2) with inserts/updates/deletes flowing within seconds or minutes.

Is it cheaper to write your own? I can assure you that it is not, not in the long run.
Cancel

-ADS BY GOOGLE

SearchWindowsServer

SearchServerVirtualization

SearchCloudComputing

Close