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