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