By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,611 Members | 2,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,611 IT Pros & Developers. It's quick & easy.

Migration from MVS to Oracle 10

P: 3
Hi all,

I have a bunch of tables (peopleSoft tables) and i want to migrate them to an Oracle 10i server.

I'm looking for a fast process like an Export from DB2 (MVS z/OS V7) and a load data to my Oracle Server. I'm facing problem because DB2 MVS V7 can't export data in an ASCII mode and as a consequence i'm not able to load data in oracle...
I can only use the IXF format that is not supported by Oracle server ...

Any help would be appreciated.

Regards,
Alexis BRICE
Dec 12 '07 #1
Share this Question
Share on Google+
4 Replies


docdiesel
Expert 100+
P: 297
Hi,

I'm more from the Linux side of the world, but as far as I know the z/world the following should work:
  1. Export the data from DB2 in delimited (DEL) or fixed length (ASC) format.
  2. Open an ftp connection from your Oracle server to the mainframe.
  3. Download the EBCDIC datasets in ftp ASCII mode.
  4. The host ftp server should convert them automatically from EBCDIC to ASCII.
  5. Load the files into Oracle.
Regards, Bernd
Dec 16 '07 #2

P: 3
Uik
HI,

Thx for your reply docdiesel, your process should be good with an DB2 UDB database but the export utility from db2 for z/OS (v7) don't allows you to export in an ASCII or a DEL mode but only in IXF format which is only supported by DB2 databases... here is my issue !

Thx for any help.

Regards,
Alexis BRICE
Dec 17 '07 #3

docdiesel
Expert 100+
P: 297
Hi,

hmmmm, well, ... as far as I remember there's a SQL command tool called SPUFI or so. Furthermore, there's a binary for SQL in batch/JCL the name of which I don't recall. Could you start something like

Expand|Select|Wrap|Line Numbers
  1. SELECT some_int, ',"', somevarchar, '",', ...
and store the results in EBCDIC datasets before transfering them via FTP?

Otherwise, there's the following way which should work. IBM offers a free LUW version of DB2, called Express-C, for download. Install it on Linux or window$ and LOAD there the IXF's you exported at first on the mainframe. On the LUW system you then should be able to export ASC/DEL format.

Regards,

Bernd
Dec 17 '07 #4

P: 3
Uik
Hi all,

Thx docdiesel for your reply i wiil try the LUW version of DB2 u pointed at, i'll try it after new year and give u a feedback here !!

In the meanwhile happy xmass and new year :p

Regards
Alexis BRICE
Dec 19 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.