Re: Copy Oracle database to DB2/400

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

Schemas --- me.... I would buy ERWin.

Reverse engineer the database schemas into ERWin. ERWin establishes a
connection to the database and reads the catalogs for the meta-data and
builds the database in the tool.

Correct and edit in the tool.
Change the target database in the tool to the 400.
Finish corrections and edits.

Recreate the generation scripts
Use OpsNav to execute the scripts against the 400.

That puts the database there and documents it.

Next, export the data from Oracle. Most DBs have import/export functions in
multiple formats, including csv.

Import the data (load) to DB2. On the 400, this is CPYFRMIMPF.

These last two steps are much faster (loads and unloads) than other forms,
like ODBC or DPropR or whatever, and are generally refered to in everybody's
docs as load and unload. The 400 can do loads in parallel, given the
resources.

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"America is the land that fought for freedom and then
  began passing laws to get rid of it."

     - Alfred E. Neuman

-----Original Message-----
From: David.X.Kahn@gsk.com <David.X.Kahn@gsk.com>
To: midrange-l@midrange.com <midrange-l@midrange.com>
Date: Thursday, October 25, 2001 5:11 AM
Subject: Re: Copy Oracle database to DB2/400


>Many thanks to Chuck Morehead, Bruce Odum, Nathan Andelin and David Morris
>for their suggestions. I think my main problem now is going to be getting
>the co-operation of the "keepers of the Oracle". I think there are likely
>to be some technical objections, and I'll naturally throw any of these
>straight out to midrange-l for comment.
>
>Dave...
>
>=======================================================
>The opinions expressed in this communication are my own and do not
>necessarily reflect those of my employer.
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>