473,327 Members | 1,952 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Migration from MVS to Oracle 10

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
4 2488
docdiesel
297 Expert 100+
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
Uik
3
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
297 Expert 100+
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
Uik
3
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

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

Similar topics

0
by: Richard Crawford | last post by:
I've been breaking my head over this one for a couple of weeks now. The source database is an MS-SQL Server 7 database living on a Windows NT server; the destination is an Oracle 9i database...
4
by: susmita_ganguly | last post by:
Hi I am trying to upgrade from oracle 8i to oracle 9i on the same server ..I don't know much abt migration . Can anyone help me out. Thanks. Susmita
4
by: Azhar Bilgrami | last post by:
Dear Hi: Hope to see u in good health. " I want to migrate a database which is currently running Unix as Operating System and Oracle ver 6 as Database, it is also using oracle froms version 3...
1
by: ss_dash | last post by:
Hi all, I am using the Oracle Workbench for migrating my DB currently on Sql Server 2000 to Oracle 9i. During the migration the following happens SELECT @tBaseTable = tBaseTable,...
4
by: Abram Friesen | last post by:
Hi, I'm a developer for a software application vendor, and our application makes use of a customer-maintained Oracle 8i/9i database. We've had a customer request to support DB2 database, and I'm...
2
by: _link98 | last post by:
Does IBM publish a complete list of features (of Oracle) which the IBM migration toolkit does *not* convert? The docs seem rather vague. For example: 1. What support for the oracle...
2
by: phantom | last post by:
Hi all. We have a production data source running postgres for reporting/DSS we are thinking on building a warehouse, wherein data would be transferred from postgres to the warehouse. The...
1
by: dunleav1 | last post by:
Is there a db2 tool or utility that will map Oracle structures and data to DB2? For instance Microsoft has a tool called "Microsoft Sql Server Migration Assistant for Oracle". The tool...
2
by: dunleav1 | last post by:
Is there a db2 tool or utility that will map Oracle structures and data to DB2? For instance, Microsoft has a tool called "Microsoft Sql Server Migration Assistant for Oracle". The tool basically...
0
by: Ptero | last post by:
We're using a lot of typed datasets in ASP.NET application, most of them have many tables+adapters and each table has some functions that call Oracle Stored Procedures. It works using...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.