Home » Infrastructure » Other Operating Systems » DB2 to Oracle conversion on OS/390
|
|
| Re: DB2 to Oracle conversion on OS/390 [message #113891 is a reply to message #113890] |
Sat, 03 May 2003 19:07   |
Eric Harper
Messages: 1
Registered: May 2003
|
Junior Member |
|
|
: Does anyone have any information or experience of converting DB2 to Oracle?
James,
* Yes, I've converted some DB2 applications to Oracle and vice-versa. Pro*Cobol and CICS are the typical structure; however, I've seen Cobol to PL/SQL at two shops. If you are interested about evaluating a conversion effort, I can email you some documentation that I've done for other customers and I'm always happy to talk to someone about databases.
* If CICS is part of the equation, you must purchase or negotiate for free the CICS Access Manager product. It's the stub that works like DB2's RCT and allows CICS to become the coordinator of 2-phase commits, without it, things could get ugly.
* I'm sure I've got some scripts for making DCLGENs out of Oracle. I also have some queries that will hit the DB2 Catalog and produce Oracle DDL table, index, and synonym creates. One other thing was unloading all of the data with DSNTIAUL, then generating the SQL Loader syntax for each table.
* Also I wrote an ISPF application with a backend Rexx that uses IBM's Spufi panels to invoke SQL Plus (yeah, it was a slap in the face to IBM). But programmers were happy to have their output automatically saved to a dataset and they could even do the three semicolons with a PF3 to skip the intermediate screens. It was almost transparent to the programmers that they had switched to Oracle.
* If you use QMF, wow, there's some serious work to get over to SQL Plus. SQL Plus is free from Oracle and is a very sophisticated report writer with control break capabilities just like QMF, without the .query and .forms.
* Hopefully you don't have a lot of stored procedures or triggers yet in DB2, they would involve some work to convert too.
* If your company is serious about a conversion effort to Oracle, SIG attendance is a must. You'll make all kinds of contacts and get ideas about conversion scenarios. It's a small group, but we've all got interesting stories to tell, that and there is no Oracle OS/390 classes offered by Oracle.
Hope this helps,
Eric Harper
|
|
|
|
| Re: DB2 to Oracle conversion [message #113964 is a reply to message #113891] |
Fri, 10 October 2003 23:13 |
Shankar Hegde
Messages: 1
Registered: October 2003
|
Junior Member |
|
|
Hello Eric,
your insight is very good. I am supposed to start work on migrating an application package from DB2(OS/390) to Oracle 8 on Sun Solaris and was wondering about
1) any tools availability for the data migration (apart from the respective export/import SQL*Loader like tools) and
2) technical issues
The package version is the same so the challenge is with the data and interfaces written in Cobol.
Am very comfortable with Oracle but have little knowledge of the M/F. Any thoughts you can share?
Thanks
Shankar
: : Does anyone have any information or experience of converting DB2 to Oracle?
: James,
: * Yes, I've converted some DB2 applications to Oracle and vice-versa. Pro*Cobol and CICS are the typical structure; however, I've seen Cobol to PL/SQL at two shops. If you are interested about evaluating a conversion effort, I can email you some documentation that I've done for other customers and I'm always happy to talk to someone about databases.
: * If CICS is part of the equation, you must purchase or negotiate for free the CICS Access Manager product. It's the stub that works like DB2's RCT and allows CICS to become the coordinator of 2-phase commits, without it, things could get ugly.
: * I'm sure I've got some scripts for making DCLGENs out of Oracle. I also have some queries that will hit the DB2 Catalog and produce Oracle DDL table, index, and synonym creates. One other thing was unloading all of the data with DSNTIAUL, then generating the SQL Loader syntax for each table.
: * Also I wrote an ISPF application with a backend Rexx that uses IBM's Spufi panels to invoke SQL Plus (yeah, it was a slap in the face to IBM). But programmers were happy to have their output automatically saved to a dataset and they could even do the three semicolons with a PF3 to skip the intermediate screens. It was almost transparent to the programmers that they had switched to Oracle.
: * If you use QMF, wow, there's some serious work to get over to SQL Plus. SQL Plus is free from Oracle and is a very sophisticated report writer with control break capabilities just like QMF, without the .query and .forms.
: * Hopefully you don't have a lot of stored procedures or triggers yet in DB2, they would involve some work to convert too.
: * If your company is serious about a conversion effort to Oracle, SIG attendance is a must. You'll make all kinds of contacts and get ideas about conversion scenarios. It's a small group, but we've all got interesting stories to tell, that and there is no Oracle OS/390 classes offered by Oracle.
: Hope this helps,
: Eric Harper
|
|
|
|
|
|
|
|
| Re: DB2 to Oracle conversion on OS/390 [message #113969 is a reply to message #113891] |
Wed, 26 November 2003 13:12 |
Shanmuga Babu
Messages: 1
Registered: November 2003
|
Junior Member |
|
|
: : Does anyone have any information or experience of converting DB2 to Oracle?
: James,
: * Yes, I've converted some DB2 applications to Oracle and vice-versa. Pro*Cobol and CICS are the typical structure; however, I've seen Cobol to PL/SQL at two shops. If you are interested about evaluating a conversion effort, I can email you some documentation that I've done for other customers and I'm always happy to talk to someone about databases.
: * If CICS is part of the equation, you must purchase or negotiate for free the CICS Access Manager product. It's the stub that works like DB2's RCT and allows CICS to become the coordinator of 2-phase commits, without it, things could get ugly.
: * I'm sure I've got some scripts for making DCLGENs out of Oracle. I also have some queries that will hit the DB2 Catalog and produce Oracle DDL table, index, and synonym creates. One other thing was unloading all of the data with DSNTIAUL, then generating the SQL Loader syntax for each table.
: * Also I wrote an ISPF application with a backend Rexx that uses IBM's Spufi panels to invoke SQL Plus (yeah, it was a slap in the face to IBM). But programmers were happy to have their output automatically saved to a dataset and they could even do the three semicolons with a PF3 to skip the intermediate screens. It was almost transparent to the programmers that they had switched to Oracle.
: * If you use QMF, wow, there's some serious work to get over to SQL Plus. SQL Plus is free from Oracle and is a very sophisticated report writer with control break capabilities just like QMF, without the .query and .forms.
: * Hopefully you don't have a lot of stored procedures or triggers yet in DB2, they would involve some work to convert too.
: * If your company is serious about a conversion effort to Oracle, SIG attendance is a must. You'll make all kinds of contacts and get ideas about conversion scenarios. It's a small group, but we've all got interesting stories to tell, that and there is no Oracle OS/390 classes offered by Oracle.
: Hope this helps,
: Eric Harper
Hi Eric,
I am involved in DB2 to Oracle conversion project. Can you please provide me the information about (1) Conversion Effort (2) Conversion Strategy etc.,
Thanks
Babu
|
|
|
|
| Re: DB2 to Oracle conversion on OS/390 [message #113981 is a reply to message #113969] |
Mon, 16 February 2004 20:42 |
Kapil
Messages: 145
Registered: May 2002
|
Senior Member |
|
|
: : : Does anyone have any information or experience of converting DB2 to Oracle?
: : James,
: : * Yes, I've converted some DB2 applications to Oracle and vice-versa. Pro*Cobol and CICS are the typical structure; however, I've seen Cobol to PL/SQL at two shops. If you are interested about evaluating a conversion effort, I can email you some documentation that I've done for other customers and I'm always happy to talk to someone about databases.
: : * If CICS is part of the equation, you must purchase or negotiate for free the CICS Access Manager product. It's the stub that works like DB2's RCT and allows CICS to become the coordinator of 2-phase commits, without it, things could get ugly.
: : * I'm sure I've got some scripts for making DCLGENs out of Oracle. I also have some queries that will hit the DB2 Catalog and produce Oracle DDL table, index, and synonym creates. One other thing was unloading all of the data with DSNTIAUL, then generating the SQL Loader syntax for each table.
: : * Also I wrote an ISPF application with a backend Rexx that uses IBM's Spufi panels to invoke SQL Plus (yeah, it was a slap in the face to IBM). But programmers were happy to have their output automatically saved to a dataset and they could even do the three semicolons with a PF3 to skip the intermediate screens. It was almost transparent to the programmers that they had switched to Oracle.
: : * If you use QMF, wow, there's some serious work to get over to SQL Plus. SQL Plus is free from Oracle and is a very sophisticated report writer with control break capabilities just like QMF, without the .query and .forms.
: : * Hopefully you don't have a lot of stored procedures or triggers yet in DB2, they would involve some work to convert too.
: : * If your company is serious about a conversion effort to Oracle, SIG attendance is a must. You'll make all kinds of contacts and get ideas about conversion scenarios. It's a small group, but we've all got interesting stories to tell, that and there is no Oracle OS/390 classes offered by Oracle.
: : Hope this helps,
: : Eric Harper
: Hi Eric,
: I am involved in DB2 to Oracle conversion project. Can you please provide me the information about (1) Conversion Effort (2) Conversion Strategy etc.,
: Thanks
: Babu
|
|
|
|
| DB2 to Oracle conversion on OS/390 [message #113982 is a reply to message #113981] |
Tue, 09 March 2004 05:24 |
Enrique
Messages: 2
Registered: June 2002
|
Junior Member |
|
|
Hola un favor oye no si si tienes informacion que pueda acceder a traves de la web, sobre empresas que vendan productos para convertir, DB2 a Oracle, como funciones, triger, procedimientos,etc espero que me ayudes porque en si necesito esa informacion con urgencia
Gracias
|
|
|
|
|
|
| Re: DB2 to Oracle conversion on OS/390 [message #114149 is a reply to message #113891] |
Wed, 22 September 2004 01:22 |
Leon Heutmekers
Messages: 1
Registered: September 2004
|
Junior Member |
|
|
eric,
Would be interested in the scripts/doc that make up the following part of a DB2 to Oracle migration.
Thanks,
: * I'm sure I've got some scripts for making DCLGENs out of Oracle. I also have some queries that will hit the DB2 Catalog and produce Oracle DDL table, index, and synonym creates. One other thing was unloading all of the data with DSNTIAUL, then generating the SQL Loader syntax for each table.
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Wed Jan 22 06:15:09 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
