Converting application from Oracle to DB2 UDB

[login to unmask email]

Converting application from Oracle to DB2 UDB
Hi,

We have the opportunity of converting a Siebel application from Oracle
8.16 to DB2 UDB on a RS6000. The application has about 2,000 tables
and 6,000 indexes. We are also neophytes with DB2 UDB. So, is there an
easy process to migrate the structures and data? Are tools required
for the migration? Any silver bullets? Any successes or horror
stories?

TIA

Patrick Poziwilko



Dan Sullivan

Re: Converting application from Oracle to DB2 UDB
(in response to Nicole Cook)
Have you looked at DBArtisan from Embacadero¿
They have a wb site EMBARCADERO.COM. I beleive the software can be
downloaded from the site.


[login to unmask email]

Re: Converting application from Oracle to DB2 UDB
(in response to Patrick_D_Poziwilko@EMAIL.WHIRLPOOL.COM)
Patrick,

You will be joining the thousands of "soon to be ex-Oracle" users
especially since Sieble has
Divorced Oracle like many other software vendors. The migration process is
fairly simple because
a company called Mantech has joined forces with IBM to migrate customers
from Oracle to the "Number-1
DBMS in the World". Attached is a URL that should get you and your
asociates to the "starting line"
for the Migration process.

http://www-4.ibm.com/software/data/db2/migration/

Good Luck,
Don Alden


-----Original Message-----
From: [login to unmask email]
[mailto:[login to unmask email]
Sent: Thursday, January 04, 2001 10:10 AM
To: [login to unmask email]
Subject: Converting application from Oracle to DB2 UDB


Hi,

We have the opportunity of converting a Siebel application from Oracle
8.16 to DB2 UDB on a RS6000. The application has about 2,000 tables
and 6,000 indexes. We are also neophytes with DB2 UDB. So, is there an
easy process to migrate the structures and data? Are tools required
for the migration? Any silver bullets? Any successes or horror
stories?

TIA

Patrick Poziwilko








Nicole Cook

Re: Converting application from Oracle to DB2 UDB
(in response to Don.Alden@I-STRUCTURE.COM)
Here is a link to an article in DB2 magazine. It has some wonderful
information on how to move an Oracle database to UDB. It also provides
tables on how to convert Oracle data types into ones used by UDB, plus
translations from PL/SQL to SQL used by UDB.

http://www.db2mag.com/db_area/archives/2000/q2/spratt.shtml

I hope this helps.

Nicole Cook
Senior Product Marketing Manager
bmcsoftware
512.340.6817
800.841.2031
[login to unmask email]

-----Original Message-----
From: [login to unmask email]
[mailto:[login to unmask email]
Sent: Thursday, January 04, 2001 11:10 AM
To: [login to unmask email]
Subject: Converting application from Oracle to DB2 UDB

Hi,

We have the opportunity of converting a Siebel application from Oracle
8.16 to DB2 UDB on a RS6000. The application has about 2,000 tables
and 6,000 indexes. We are also neophytes with DB2 UDB. So, is there an
easy process to migrate the structures and data? Are tools required
for the migration? Any silver bullets? Any successes or horror
stories?

TIA

Patrick Poziwilko








Georg Peter

AW: Converting application from Oracle to DB2 UDB
(in response to Dan Sullivan)
Patrick,

take a look at http://www-4.ibm.com/software/data/db2/migration/ and you'll
find what you need.

And as a last thought: Welcome to the DB2 community !!

With kind regards - mit freundlichen Grüssen,
G e o r g H . P e t e r
DB2 Data Base Administrator c/o
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Software Development & Technology Center
Knowlegde Center Database Systems
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------

"Long ago, when knights were bold, dragons walked the earth, and
both DB2 and I were young, I had a real job. I was a programmer."




-----Ursprüngliche Nachricht-----
Von: [login to unmask email]
[mailto:[login to unmask email]
Gesendet am: Donnerstag, 4. Januar 2001 18:10
An: [login to unmask email]
Betreff: Converting application from Oracle to DB2 UDB

Hi,

We have the opportunity of converting a Siebel application from Oracle
8.16 to DB2 UDB on a RS6000. The application has about 2,000 tables
and 6,000 indexes. We are also neophytes with DB2 UDB. So, is there an
easy process to migrate the structures and data? Are tools required
for the migration? Any silver bullets? Any successes or horror
stories?

TIA

Patrick Poziwilko


visit the

.



Alan Johns

Re: Converting application from Oracle to DB2 UDB
(in response to Georg Peter)
Hi Patrick.
You might try loking at a tool called Move for Servers from Princeton
Softech. This can extract both data and supporting DDL from Oracle, and then
create corrresponding objects within DB2 UDB, and then populate them with
the extracted data, converting the data from one DBMS format to the other
for you.

I'm a product specialist for the group (ie a techie, not a salesman). So if
you want to go over any technical stuff with me, drop me a line.

You might also find the web site useful.

Cheers. Alan



Alan Johns
Product Specialist
Princeton Softech
Westmoreland House
80-86 Bath Road, Cheltenham
Gloucestershire GL53 7JT England
+44.(0).1242.229700
+44.(0).1242.229779 (direct)
+44.(0).7967.552234 (mobile)
+44.(0).1242.229701 (fax)
[login to unmask email]
http://princetonsoftech.com



-----Original Message-----
From: [login to unmask email]
[mailto:[login to unmask email]
Sent: 04 January 2001 17:10
To: [login to unmask email]
Subject: Converting application from Oracle to DB2 UDB


Hi,

We have the opportunity of converting a Siebel application from Oracle
8.16 to DB2 UDB on a RS6000. The application has about 2,000 tables
and 6,000 indexes. We are also neophytes with DB2 UDB. So, is there an
easy process to migrate the structures and data? Are tools required
for the migration? Any silver bullets? Any successes or horror
stories?

TIA

Patrick Poziwilko








Roger Miller

Re: Converting application from Oracle to DB2 UDB
(in response to Alan Johns)
I think Siebel has a conversion process, so that the general conversion
facilities are not required. So the first call should probably go to your
Siebel rep. I did not see the information with a quick look at the web,
http://www.ibm-siebel.com/us/

Roger Miller



csc266

Re: Converting application from Oracle to DB2 UDB
(in response to Roger Miller)
Get a hold of a copy of Embarcadero's DBArtisan. It was a lifesaver for a
whole host of little tasks that are supportive to the migration process. DDL
Extracts, comparisons,

I even moved a majority of the tables with DBArtisan ( any table that's
under 5-10 Mb ). Of course, the big data tables would need import,
bulk-copy methods. But, in most schemas , there are several small tables and
some huge tables. A tool like Artisan helped me atleast focus on heavy duty
migration just on tables that were large and volatile.

Watch out for text, blob columns. Also, TIMESTAMP formats - read up on
variances.


----- Original Message -----
From: <[login to unmask email]>
Sent: Thursday, January 04, 2001 10:09 AM
Subject: Converting application from Oracle to DB2 UDB


> Hi,
>
> We have the opportunity of converting a Siebel application from
Oracle
> 8.16 to DB2 UDB on a RS6000. The application has about 2,000 tables
> and 6,000 indexes. We are also neophytes with DB2 UDB. So, is there
an
> easy process to migrate the structures and data? Are tools required
> for the migration? Any silver bullets? Any successes or horror
> stories?
>
> TIA
>
> Patrick Poziwilko
>



csc266

Re: Converting application from Oracle to DB2 UDB
(in response to csc266)
The download is for trial purposes only. You'll need to buy the software if
you needed to actually use it for your business.

----- Original Message -----
From: "Daniel Sullivan" <[login to unmask email]>
Sent: Thursday, January 04, 2001 10:19 AM
Subject: Re: Converting application from Oracle to DB2 UDB


Have you looked at DBArtisan from Embacadero¿
They have a wb site EMBARCADERO.COM. I beleive the software can be
downloaded from the site.



Scott Saunders

Re: Converting application from Oracle to DB2 UDB
(in response to csc266)
Patrick;

Siebel Systems Expert Services Division has experience and methodologies for
converting to DB2 as well as experience with DB2 administration and
management.

Regards,
Scott Saunders Siebel Systems, Inc.
Senior Architecture Specialist 14502 N. Dale Mabry
Siebel 2000 Certified Professional Suite 200
IBM DB2 Certified Database Administrator Tampa, FL 33618
[login to unmask email] 727-403-4981
http://www.siebel.com/worldwide-services


-----Original Message-----
From: [login to unmask email]
[mailto:[login to unmask email]
Sent: Thursday, January 04, 2001 9:10 AM
To: [login to unmask email]
Subject: Converting application from Oracle to DB2 UDB


Hi,

We have the opportunity of converting a Siebel application from Oracle
8.16 to DB2 UDB on a RS6000. The application has about 2,000 tables
and 6,000 indexes. We are also neophytes with DB2 UDB. So, is there an
easy process to migrate the structures and data? Are tools required
for the migration? Any silver bullets? Any successes or horror
stories?

TIA

Patrick Poziwilko








Isaac Yassin

Re: Converting application from Oracle to DB2 UDB
(in response to Scott Saunders)
Hi,
On top of all the other good advice you've got - pay attention to the
differences between ORACLE PL/SQL and DB2 stored proceduers and the same
goes for triggers.
I miss the option to issue SQL commands within "before trigger" without
reverting to calling a stored procedure. Sometimes you need to do some work
"before trigger" and use the result data from it in an "after trigger" - in
ORACLE it's in the same package, so you have it immediatly, in DB2 you have
either to calculate it twice - ones "before" and once "after" , or call a
stored proc to keep it in a temp table, as you can't keep it in a temp table
in a "before" trigger.


Isaac Yassin
DBMS & IT Consultant
[login to unmask email]



Kent Collins

Re: Converting application from Oracle to DB2 UDB
(in response to Isaac Yassin)
Also, IBM has a Pre-Sales Technical Team that focuses on converting other
DBMS applications to DB2. They have extensive experience in Oracle to DB2
conversions. This is a very talented group.

Dominic Marrese is the manager of the group. ( [login to unmask email] )

Robert M. Collins Jr ( Kent )
IBM Certified DB2 UDB DBA
Phone: 940.241.2242
Email: [login to unmask email]

<snip>