LUW to Db2 z/OS "unload / export"

william giannelli

LUW to Db2 z/OS "unload / export"

In Db2 z/OS if we want all the data from a table we might run an "UNLOAD" utility. If we connect from LUW up to Db2 z/OS might one run an "EXPORT" to get all the data from a table?

thanks

Bill

Johnny Wilder

LUW to Db2 z/OS "unload / export"
(in response to william giannelli)
Correct. EXPORT works great. It creates an ixf file or you can load it directly into an LUW table.


Johnny Wilder | Lead Database Administrator
Motion Industries, Inc
1605 ALTON ROAD | BIRMINGHAM, AL 35210
Office: 205-951-6990 | Fax: 205-951-1185
[login to unmask email] | www.motionindustries.com http://www.motionindustries.com

This e-mail and any attachments may contain Motion Industries, Inc confidential information that is proprietary, privileged, and protected by applicable laws. If you have received this message in error and are not the intended recipient, you should not retain, distribute, disclose or use any of this information and you should destroy this e-mail, any attachments or copies therein forthwith. Please notify the sender immediately by e-mail if you have received this e-mail in error.
From: william giannelli <[login to unmask email]>
Sent: Thursday, August 8, 2019 1:44 PM
To: [login to unmask email]
Subject: [DB2-L] - LUW to Db2 z/OS "unload / export"

External Email: Proceed with Caution!


In Db2 z/OS if we want all the data from a table we might run an "UNLOAD" utility. If we connect from LUW up to Db2 z/OS might one run an "EXPORT" to get all the data from a table?

thanks

Bill

-----End Original Message-----

Philip Nelson

LUW to Db2 z/OS "unload / export"
(in response to Johnny Wilder)
Even better is to use "crossloader" (LOAD FROM CURSOR). Works both ways
very well (z/OS --> LUW and LUW --> z/OS).

You'll need to set up the appropriate federation links, but that isn't very
onerous.

Then you can move data straight from table to table without intermediate
files at all.

Phil

On Thu, 8 Aug 2019 at 21:53, Johnny Wilder <[login to unmask email]> wrote:

> Correct. EXPORT works great. It creates an ixf file or you can load it
> directly into an LUW table.
>
>
>
> *Johnny Wilder* | *Lead Database Administrator*
> Motion Industries, Inc
> 1605 ALTON ROAD *|* BIRMINGHAM, AL 35210
> Office: 205-951-6990 * | *Fax: 205-951-1185
> [login to unmask email] *|* www.motionindustries.com
>
> This e-mail and any attachments may contain Motion Industries, Inc
> confidential information that is proprietary, privileged, and protected by
> applicable laws. If you have received this message in error and are not the
> intended recipient, you should not retain, distribute, disclose or use any
> of this information and you should destroy this e-mail, any attachments or
> copies therein forthwith. Please notify the sender immediately by e-mail if
> you have received this e-mail in error.
>
> *From:* william giannelli <[login to unmask email]>
> *Sent:* Thursday, August 8, 2019 1:44 PM
> *To:* [login to unmask email]
> *Subject:* [DB2-L] - LUW to Db2 z/OS "unload / export"
>
>
>
> *External Email:* Proceed with Caution!
>
>
>
> In Db2 z/OS if we want all the data from a table we might run an "UNLOAD"
> utility. If we connect from LUW up to Db2 z/OS might one run an "EXPORT" to
> get all the data from a table?
>
> thanks
>
> Bill
>
>
> -----End Original Message-----
>
> -----End Original Message-----
>

Javier Estrada Benavides

RE: LUW to Db2 z/OS "unload / export"
(in response to Philip Nelson)

Hey Philip, how's it going?

   By any chance, can you point me in the right direction to read on how to set those links up? I know about someone else busting his head on this same topic.

 

Have a great day :)

 

Javier Estrada Benavides, Czech Republic / Mexico

IBM Champion for Analytics

IBM Certified System Administrator - Db2 12 for z/OS

IBM Db2 12 DBA for z/OS - 2018 (the ugly brown badge from IBM Open Badge Program)

IBM Certified System Administrator - DB2 11 for z/OS

IBM Certified Database Administrator - DB2 11 DBA for z/OS