Prev: Disabling a MQT in db2 9.7
Next: DB2 DBA - Distributed Database Administrator required at Morgan Stanley, UK, London
From: Hardy on 18 May 2010 11:06
On May 17, 7:25 am, situ <SRIDHAR...(a)REDIFFMAIL.COM> wrote:
> On May 17, 1:10 pm, Serge Rielau <srie...(a)ca.ibm.com> wrote:
>
> > I agree an ORA to DB2 migration should be done on DB2 9.7.
> > It's 10x easier compared to Db2 9.1 and some of the 9.5 Ora
> > compatibility features were only in beta (such as VARCHAR2).
>
> > Cheers
> > Serge
>
> > --
> > Serge Rielau
> > SQL Architect DB2 for LUW
> > IBM Toronto Lab
>
> Thanks all for the Suggestion, though the current running code is 9.5,
> soon we are moving into 9.7 and as you said i can utilize the DB2 to
> the maximum and make my job easy.
> But i worry about backward compatibility , suppose i setup a db using
> compatibility vector of  9.7 and convert all oracle packages as it is
> into db2.
> if client wants to apply the same code on application running on 9.5 ,
> then I've nowhere to go but to prepare the DB2 relevant code and
> maintainability of the code become difficult.
>
> so right now i prefer to use DB2 specific code for some time.
>
> Any thoughts or suggestion on this
>
> Regards,
> Sridhar

I'm afraid you have to do so. From the view of migration, 9.5 and 9.7
are very very different unless you don't utilize 9.7's potential.
From: Serge Rielau on 20 May 2010 05:26
Sridhar,

Is this need to support DB2 9.5 real or just a monster under the bed?
We have hundreds of customers and ISVs exploiting DB2 9.7 to enable
Oracle applications.
But it's your resources.. just don't complain it's hard then given that
IBM already has shipped the solution to the problem;-)

Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

First  |  Prev  | 
Pages: 1 2
Prev: Disabling a MQT in db2 9.7
Next: DB2 DBA - Distributed Database Administrator required at Morgan Stanley, UK, London