Also, if you have the DRDA setup, catalog the subsystem as a database on
the windows machine and do the import remotely( then you don't have to ftp
files on step 2) :)

Suresh G.




"Paul Le Claire "
<db2udbdba-ezmlmshield-x96840861.[Email address protected]
12/26/2006 10:09 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Re: Export from Windows & Import to z/OS






Bob,

I know of two options:

1.) Use the db2 migrate facility

2.) use a db2 look to export all of the table structures,
Build the DB on Zos and use the output from the db2look to build the

table structures,
export every table ftp them, and then import them

If you want examples of the exports and imports, I can get you those, but
they are very simple. Then you only need to get a table list. Also, be
VERY careful of tables with Identity columns on them, you will have to
reset
those counters with an alter table statement.

Paul

----- Original Message -----
From: "Bob Khosla "
<db2udbdba-ezmlmshield-x87083115.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, December 26, 2006 5:52 PM
Subject: Export from Windows & Import to z/OS


> What is the best way to migrate data from a DB2/UDB database on WINDOWS
> platform -to-> a DB2 database on z/OS ??
>
> Any proven clues/suggestions?
>
> Bob
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time
without any further consent.


DB2 & UDB email list listserv db2-l LazyDBA home page