asked on

Any Script to Unload from DB2 Z/OS(Mainframe) for load into DB2 UDB Windows and Linux

Hi all,
I have a need to copy z/OS data and load into DB2 UDB on Linux and Windows Servers. What are the options that I have to accomplish this requirement. Please be kind enough to describe the steps in detail and if possible sample scripts will be very welcomed.

My thanks and appreciation in advance.

Enuda

SOLUTION

Kent Olsen

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Enuda

ASKER

Hello kdo,
Thanks for your response. I wish all I needed was move data from one UDB to another. However, what I need is to Unload data from the mainframe Z/OS DB2 , turn around and load the extracted data into its UDB clone. The data format as you know is EBCDIC to ASCII I think. And to make matter worse the UDB column names may not be the same, but I need to consider that also.

So, that brings me to the question: How can I do this? Anyone with any example?

Thanks

SOLUTION

momi_sabag

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Enuda

ASKER

Hi momi_sabag,
We are run DB2v8 on a z/OS machine. Could you provide a example unload SQL code for the Unload to csv format including how to specify the ccsid?

Thanks

SOLUTION

Kent Olsen

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Enuda

ASKER

How do one go about federating the mainframe DB2 to UDB/LUW - what are the steps to do this?

I read several ways of doing what I need to do - move data fom MF to LUW - and that gives me more ways to do things.
Thanks

SOLUTION

Kent Olsen

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

momi_sabag

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Kent Olsen

Hi Momi,

The federated approach is a lot faster than I had expected. I federate several UDB/LUW 8/9 on AIX 5.3 systems to other databases, including Oracle 8,9, and 10.

Using LOAD FROM CURSOR, I can load about 1,000,000 rows/minute across the network(1GB backbone) using the federated hooks. The drivers handle all of the date, time, timestamp, decimal, integer, float, and character set conversions on the fly.

I'll take 1,000,000 rows a minute. Absolutely.

Kent

Kent