SEO

I want to migrate my Oracle 10g database to Db2. I want some
documentation for the comparision between these to databases. I also
want to know which features of Oracle 10g are supported by Db2 and
which are not supported.

"Ashish Patankar" <ashishpatankar@gmail.com> wrote in message
news:1149142524.394632.226950@j55g2000cwa.googlegr oups.com...
>I want to migrate my Oracle 10g database to Db2. I want some
> documentation for the comparision between these to databases. I also
> want to know which features of Oracle 10g are supported by Db2 and
> which are not supported.
>

IBM offers migration toolkits at the following site:
http://www-306.ibm.com/software/data/db2/migration/

DB2 is fairly close to ANSI SQL, but Oracle has introduced many proprietary
SQL extensions, so it depends on how many proprietary extensions where used
in your apps as to how difficult it will be. There are work-arounds for
almost all issues, and if you cannot find it documented in the toolkit, you
can ask here in this forum (but check Google Groups archives first).

"Ashish Patankar" <ashishpatankar@gmail.com> a écrit dans le message de
news: 1149142524.394632.226950@j55g2000cwa.googlegroups. com...
>I want to migrate my Oracle 10g database to Db2. I want some
> documentation for the comparision between these to databases. I also
> want to know which features of Oracle 10g are supported by Db2 and
> which are not supported.
>

The biggest pain will be strict datatype handling, date / time differences,
and error handling.
During migration constraints will also cause some difficulties.

"Ashish Patankar" <ashishpatankar@gmail.com> wrote in message
news:1149142524.394632.226950@j55g2000cwa.googlegr oups.com...
>I want to migrate my Oracle 10g database to Db2. I want some
> documentation for the comparision between these to databases. I also
> want to know which features of Oracle 10g are supported by Db2 and
> which are not supported.
>

Dude, Oracle 8i to DB2 8.2 is a migration. Oracle 10g to DB2 8.2 is a
downgrade and migration. Depending on what 10g features are used, you may
find more or fewer things not supported or different in DB2.

Bob Jones wrote:

> "Ashish Patankar" <ashishpatankar@gmail.com> wrote in message
> news:1149142524.394632.226950@j55g2000cwa.googlegr oups.com...
>
>>I want to migrate my Oracle 10g database to Db2. I want some
>>documentation for the comparision between these to databases. I also
>>want to know which features of Oracle 10g are supported by Db2 and
>>which are not supported.
>>
>
>
> Dude, Oracle 8i to DB2 8.2 is a migration. Oracle 10g to DB2 8.2 is a
> downgrade and migration. Depending on what 10g features are used, you may
> find more or fewer things not supported or different in DB2.
>
>
Such as?

Curious wrote:
> Bob Jones wrote:
>
>> "Ashish Patankar" <ashishpatankar@gmail.com> wrote in message
>> news:1149142524.394632.226950@j55g2000cwa.googlegr oups.com...
>>
>>> I want to migrate my Oracle 10g database to Db2. I want some
>>> documentation for the comparision between these to databases. I also
>>> want to know which features of Oracle 10g are supported by Db2 and
>>> which are not supported.
>>>
>>
>>
>> Dude, Oracle 8i to DB2 8.2 is a migration. Oracle 10g to DB2 8.2 is a
>> downgrade and migration. Depending on what 10g features are used, you
>> may find more or fewer things not supported or different in DB2.
>>
> Such as?

The list is nearly endless. You won't find packages, either built-in or
user defined. You won't a fraction of the instrumentation. You won't
find multiversion read consistency. You won't find a shared-everything
architecture (unless on a mainframe version). You won't find 1/2 of
Oracle's table types or half of Oracle's index types. As I said, the
list is very very long.

Which doesn't mean you need those Oracle features. But if you do you
will not find them in DB2 8.2.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

DA Morgan wrote:

> Curious wrote:
>
>> Bob Jones wrote:
>>
>>> "Ashish Patankar" <ashishpatankar@gmail.com> wrote in message
>>> news:1149142524.394632.226950@j55g2000cwa.googlegr oups.com...
>>>
>>>> I want to migrate my Oracle 10g database to Db2. I want some
>>>> documentation for the comparision between these to databases. I also
>>>> want to know which features of Oracle 10g are supported by Db2 and
>>>> which are not supported.
>>>>
>>>
>>>
>>> Dude, Oracle 8i to DB2 8.2 is a migration. Oracle 10g to DB2 8.2 is a
>>> downgrade and migration. Depending on what 10g features are used, you
>>> may find more or fewer things not supported or different in DB2.
>>>
>> Such as?
>
>
> The list is nearly endless. You won't find packages, either built-in or
> user defined. You won't a fraction of the instrumentation. You won't
> find multiversion read consistency. You won't find a shared-everything
> architecture (unless on a mainframe version). You won't find 1/2 of
> Oracle's table types or half of Oracle's index types. As I said, the
> list is very very long.
>
> Which doesn't mean you need those Oracle features. But if you do you
> will not find them in DB2 8.2.
Daniel ... you know as well as I do that these are primarily
architectural differences between Oracle and DB2. These differences have
been there for years, and the "migration from Oracle 10g to 8.2" is no
different in this respect than the migration from Oracle 8i or Oracle 9i
to DB2 8.2 (which is what the responder was trying to claim). Would be
the same thing as saying that you won't find a shared-nothing
architecture in Oracle 10g so that would make a migration from DB2 8.2
to Oracle 10g a downgrade. Or as saying that because an Airbus airplane
has electric controls and a Boeing plane has hydraulic controls, flying
on a Boeing plane is a downgrade.

And these "differences" as such aren't anything that would cause anyone
with any balanced knowledge of relational databases to say that moving
from Oracle 10g to DB2 8.2 is a "downgrade". That's utterly ridiculous.

Larry Edelstein

Larry wrote:
> DA Morgan wrote:
>
>> Curious wrote:
>>
>>> Bob Jones wrote:
>>>
>>>> "Ashish Patankar" <ashishpatankar@gmail.com> wrote in message
>>>> news:1149142524.394632.226950@j55g2000cwa.googlegr oups.com...
>>>>
>>>>> I want to migrate my Oracle 10g database to Db2. I want some
>>>>> documentation for the comparision between these to databases. I also
>>>>> want to know which features of Oracle 10g are supported by Db2 and
>>>>> which are not supported.
>>>>>
>>>>
>>>>
>>>> Dude, Oracle 8i to DB2 8.2 is a migration. Oracle 10g to DB2 8.2 is
>>>> a downgrade and migration. Depending on what 10g features are used,
>>>> you may find more or fewer things not supported or different in DB2.
>>>>
>>> Such as?
>>
>>
>> The list is nearly endless. You won't find packages, either built-in or
>> user defined. You won't a fraction of the instrumentation. You won't
>> find multiversion read consistency. You won't find a shared-everything
>> architecture (unless on a mainframe version). You won't find 1/2 of
>> Oracle's table types or half of Oracle's index types. As I said, the
>> list is very very long.
>>
>> Which doesn't mean you need those Oracle features. But if you do you
>> will not find them in DB2 8.2.
> Daniel ... you know as well as I do that these are primarily
> architectural differences between Oracle and DB2.

MVCC is more than just architecture. And the 848 built-in packages in
10.2.0.2 are far more than fluff. They are tuning metrics. They are
HTTP and TCP. They are on-line rebuild capabilities. They are
partitioning by hash, range, and list. They are resumable transactions.
They are spatial mapping. They are BLOB compression. They are Advanced
Queuing and Streams Replication.

Architectural differences? I thinks not.

Which, as I said, does not mean that someone will need these
capabilities. But if they do ... it is something they should consider.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

DA Morgan wrote:
> Larry wrote:
>
>> DA Morgan wrote:
>>
>>> Curious wrote:
>>>
>>>> Bob Jones wrote:
>>>>
>>>>> "Ashish Patankar" <ashishpatankar@gmail.com> wrote in message
>>>>> news:1149142524.394632.226950@j55g2000cwa.googlegr oups.com...
>>>>>
>>>>>> I want to migrate my Oracle 10g database to Db2. I want some
>>>>>> documentation for the comparision between these to databases. I also
>>>>>> want to know which features of Oracle 10g are supported by Db2 and
>>>>>> which are not supported.
>>>>>>
>>>>>
>>>>>
>>>>> Dude, Oracle 8i to DB2 8.2 is a migration. Oracle 10g to DB2 8.2 is
>>>>> a downgrade and migration. Depending on what 10g features are used,
>>>>> you may find more or fewer things not supported or different in DB2.
>>>>>
>>>> Such as?
>>>
>>>
>>>
>>> The list is nearly endless. You won't find packages, either built-in or
>>> user defined. You won't a fraction of the instrumentation. You won't
>>> find multiversion read consistency. You won't find a shared-everything
>>> architecture (unless on a mainframe version). You won't find 1/2 of
>>> Oracle's table types or half of Oracle's index types. As I said, the
>>> list is very very long.
>>>
>>> Which doesn't mean you need those Oracle features. But if you do you
>>> will not find them in DB2 8.2.
>>
>> Daniel ... you know as well as I do that these are primarily
>> architectural differences between Oracle and DB2.
>
>
> MVCC is more than just architecture. And the 848 built-in packages in
> 10.2.0.2 are far more than fluff. They are tuning metrics. They are
> HTTP and TCP. They are on-line rebuild capabilities. They are
> partitioning by hash, range, and list. They are resumable transactions.
> They are spatial mapping. They are BLOB compression. They are Advanced
> Queuing and Streams Replication.
>
> Architectural differences? I thinks not.
>
> Which, as I said, does not mean that someone will need these
> capabilities. But if they do ... it is something they should consider.
As usual, Daniel ... now you are saying something else.

Your original statement was "You won't find packages, either built-in or
user defined. You won't a fraction of the instrumentation. You won't
find multiversion read consistency. You won't find a shared-everything
architecture (unless on a mainframe version). You won't find 1/2 of
Oracle's table types or half of Oracle's index types. As I said, the
list is very very long."

The "packages" statement was very non-specific ... and now that you've
managed to cleverly get more specific ... depending upon what you are
talking about, you may or may not find the same or comparable functions
in DB2. The bulk of your statement ... at least the bulk of what was
specific enough to be intelligible ... was devoted to
architectural/implementation differences (shared-everything and
multi-version read consistency), not features and you won't pull the
wool over anyone's eyes here.

We're talking migration here. We're talking that you can often
accomplish the same thing with two different databases ... using similar
features or substitute functionality that one vendor has chosen to
implement somewhat differently.

Larry Edelstein

DA Morgan wrote:
> MVCC is more than just architecture. And the 848 built-in packages in
> 10.2.0.2 are far more than fluff. They are tuning metrics. They are
> HTTP and TCP. They are on-line rebuild capabilities. They are
> partitioning by hash, range, and list. They are resumable transactions.
> They are spatial mapping. They are BLOB compression. They are Advanced
> Queuing and Streams Replication.
Oracle implements implements partitioning and online rebuild (of what,
indices?) in packages? *gosh* No wonder they need so many packages.
BLOB compression... Shouldn't they start with the frequently used row
data and online and transparent please?
Or is this needed to compress lobbyfied XML types?
Queuing... Yeah that's new to IBM. I've heard that term before.. It's
not "advanced" of course. It's just this MQ thing that everyone has...
It'll have to do I s'pose
Streams replication. Here's a thought. When I was in Vienna at IM Tech a
few weeks ago learned that customers using Q-Rep on DB2 learn a new
lesson: Replication can be network bound. Now there's a thought they
weren't used to from competitive products.
In short, juts because it has a different name in DB2, doesn't mean it
doesn't exist. And just because it doesn't use fancy adjectives like
"real", "advanced" or "native" doesn't mean it doesn't work as good or
even better.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab