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
>
>



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