IDS Forum

Re: AW: AW: Oracle to IDS 10/11 migration

Posted By: Madison Pruet
Date: Monday, 13 August 2007, at 11:57 a.m.

In Response To: AW: AW: Oracle to IDS 10/11 migration (Andreas.KUTSCHE@spar.at)

Andreas,

No real impact. We are simply maintaining the LSN of the update which
caused the update lock within the lock structure. That means we can go=

directly to the log record containing the before image.

M.P.

=

"Andreas.KUTSCHE@ =

spar.at" =

<andreas.kutsche@ =
To

spar.at> ids@iiug.org =

Sent by: =
cc

ids-bounces@iiug. =

org Subj=
ect

AW: AW: Oracle to IDS 10/11 =

migration [9767] =

08/13/2007 09:48 =

AM =

=

=

Please respond to =

ids@iiug.org =

=

=

Hi,

thats a very interesting feature, but how is the performance impact?
I presume IDS has to lookup the values in the logical logs and they
are not designed for this kind of job?!

Nevertheless this might be very helpful for migrations from
Oracle to Informix.

Regards,
Andreas Kutsche

>
-------------------------------------------
SPAR =D6sterreichische Warenhandels-AG
Hauptzentrale
A - 5015 Salzburg, Europastrasse 3
FN 34170 a

Tel: +43 662 4470 24223
Mobile: +43 664 6259575
E-Mail: Andreas.KUTSCHE@spar.at
Internet: http://www.spar.at

Wichtiger Hinweis: Der Inhalt dieser E-Mail kann vertrauliche und recht=
lich

gesch=FCtzte Informationen, insbesondere Betriebs- oder Gesch=E4ftsgehe=
imnisse,

enthalten, zu deren Geheimhaltung der Empf=E4nger verpflichtet ist. Die=

Informationen in dieser E-Mail sind ausschlie=DFlich f=FCr den Adressat=
en
bestimmt. Sollten Sie die E-Mail irrt=FCmlich erhalten haben so ersuche=
n wir
Sie, die Nachricht von Ihrem System zu l=F6schen und sich mit uns in
Verbindung
zu setzen.
=DCber das Internet versandte E-Mails k=F6nnen leicht manipuliert oder =
unter
fremdem Namen erstellt werden. Daher schlie=DFen wir die rechtliche
Verbindlichkeit der in dieser Nachricht enthaltenen Informationen aus. =
Der
Inhalt der E-Mail ist nur rechtsverbindlich, wenn er von uns schriftlic=
h
best=E4tigt und gezeichnet wird.
Sollte trotz der von uns verwendeten Virus-Schutzprogramme durch die
Zusendung
von E-Mails ein Virus in Ihre Systeme gelangen, haften wir nicht f=FCr =
evtl.
hieraus entstehende Sch=E4den.
Wir danken f=FCr Ihr Verst=E4ndnis.

Important notice: The contents of this e-mail may contain confidential =
and
legally protected information that is in particular related to operatio=
nal
and
trade secrets, which the recipient is obliged to treat as confidential.=
The

information in this e-mail is made available exclusively for use by the=

addressee. In the event that the e-mail may have been sent to you in er=
ror,
we
would ask you to kindly delete this communication from your system and =
to
contact us.
E-mails sent via the Internet can be easily manipulated or sent out und=
er
someone else's name. We therefore do not accept legal liability for the=

information contained in this communication. The contents of the e-mail=
are

only legally binding if they have been confirmed and signed by us in
writing.
If, in spite of our using Antivirus protection software, a virus may ha=
ve
penetrated your system through the sending of this e-mail, we do not ac=
cept

liability for any damage that may possibly arise as a result of this.
We trust that you appreciate our position.

-------------------------------------------
-----Urspr=FCngliche Nachricht-----

> Von: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]Im Auftrag von=

> Uday Kale
> Gesendet: Montag, 13. August 2007 16:38
> An: ids@iiug.org
> Betreff: Re: AW: Oracle to IDS 10/11 migration [9765]
>
>
> In IDS 11, you can always use the last committed isolation
> level, by -
> > set isolation level to committed read last committed;
> or
> setting USELASTCOMMITTED ONCONFIG parameter.
>
> Regds,
> Uday.
>
> =3D
>
> "Andreas.KUTSCHE@ =3D
>
> spar.at" =3D
>
> <andreas.kutsche@ =3D
> To
>
> spar.at> ids@iiug.org =3D
>
> Sent by: =3D
> cc
>
> ids-bounces@iiug. =3D
>
> org Subj=3D
> ect
>
> AW: Oracle to IDS 10/11 migratio=3D
> n
>
> [9763] =3D
>
> 08/13/2007 09:33 =3D
>
> AM =3D
>
> =3D
>
> =3D
>
> Please respond to =3D
>
> ids@iiug.org =3D
>
> =3D
>
> =3D
>
> Hi,
>
> depending on the application type (many concurrent sessions)
> the different locking behavior might be the biggest challenge.
> Oracle uses a multiversion model that leads to the fact that
> there are never locks for select statements - you may have to
> play with dirty read / committed read in Informix.
>
> Regards,
> Andreas Kutsche
>
> >
> -------------------------------------------
> SPAR =3DD6sterreichische Warenhandels-AG
> Hauptzentrale
> A - 5015 Salzburg, Europastrasse 3
> FN 34170 a
>
> Tel: +43 662 4470 24223
> Mobile: +43 664 6259575
> E-Mail: Andreas.KUTSCHE@spar.at
> Internet: http://www.spar.at
>
> Wichtiger Hinweis: Der Inhalt dieser E-Mail kann vertrauliche
> und recht=3D
> lich
>
> gesch=3DFCtzte Informationen, insbesondere Betriebs- oder
> Gesch=3DE4ftsgehe=3D
> imnisse,
>
> enthalten, zu deren Geheimhaltung der Empf=3DE4nger
> verpflichtet ist. Die=3D
>
> Informationen in dieser E-Mail sind ausschlie=3DDFlich f=3DFCr
> den Adressat=3D
> en
> bestimmt. Sollten Sie die E-Mail irrt=3DFCmlich erhalten haben
> so ersuche=3D
> n wir
> Sie, die Nachricht von Ihrem System zu l=3DF6schen und sich mit uns i=
n
> Verbindung
> zu setzen.
> =3DDCber das Internet versandte E-Mails k=3DF6nnen leicht
> manipuliert oder =3D
> unter
> fremdem Namen erstellt werden. Daher schlie=3DDFen wir die rechtliche=

> Verbindlichkeit der in dieser Nachricht enthaltenen
> Informationen aus. =3D
> Der
> Inhalt der E-Mail ist nur rechtsverbindlich, wenn er von uns
> schriftlic=3D
> h
> best=3DE4tigt und gezeichnet wird.
> Sollte trotz der von uns verwendeten Virus-Schutzprogramme durch die
> Zusendung
> von E-Mails ein Virus in Ihre Systeme gelangen, haften wir
> nicht f=3DFCr =3D
> evtl.
> hieraus entstehende Sch=3DE4den.
> Wir danken f=3DFCr Ihr Verst=3DE4ndnis.
>
> Important notice: The contents of this e-mail may contain
> confidential =3D
> and
> legally protected information that is in particular related
> to operatio=3D
> nal
> and
> trade secrets, which the recipient is obliged to treat as
> confidential.=3D
> The
>
> information in this e-mail is made available exclusively for
> use by the=3D
>
> addressee. In the event that the e-mail may have been sent to
> you in er=3D
> ror,
> we
> would ask you to kindly delete this communication from your
> system and =3D
> to
> contact us.
> E-mails sent via the Internet can be easily manipulated or
> sent out und=3D
> er
> someone else's name. We therefore do not accept legal
> liability for the=3D
>
> information contained in this communication. The contents of
> the e-mail=3D
> are
>
> only legally binding if they have been confirmed and signed by us in
> writing.
> If, in spite of our using Antivirus protection software, a
> virus may ha=3D
> ve
> penetrated your system through the sending of this e-mail, we
> do not ac=3D
> cept
>
> liability for any damage that may possibly arise as a result of this.=

> We trust that you appreciate our position.
>
> -------------------------------------------
> -----Urspr=3DFCngliche Nachricht-----
>
> > Von: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]Im
> Auftrag von=3D
>
> > leslie johnson
> > Gesendet: Freitag, 10. August 2007 19:45
> > An: ids@iiug.org
> > Betreff: RE: Oracle to IDS 10/11 migration [9755]
> >
> >
> > I agree with Jack
> > conversion is easier with a toolkit, however having
> > done a half dozen fairly large systems there are
> > several things to consider that go beyond the actual
> > database.
> > 1. embedded SQL statements in application code
> > 2. packages in oracle
> > 3. trigger logic
> > 4. field type changes (mapping char, number, date, and
> > xlob fields) between the two systems.
> > 5. the conversion software should take care of most of
> > the syntax changes in functions, procs, and packages
> > but should be validated carefully.
> > Good Luck
> >
> >
> > ______________________________________________________________
> > ______________________
> > Be a better Heartthrob. Get better relationship answers from
> > someone who
> > knows. Yahoo! Answers - Check it out.
> > http://answers.yahoo.com/dir/?link=3D3Dlist&sid=3D3D396545433
> >
> >
> > **************************************************************
> > *****************
> > Forum Note: Use "Reply" to post a response in the discussion forum.=

> >
> >
>
> **************************************************************
> *********=3D
> ********
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> =3D
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

***********************************************************************=
********

Forum Note: Use "Reply" to post a response in the discussion forum.

=

Messages In This Thread

• Oracle to IDS 10/11 migration
  H.G -- Friday, 10 August 2007, at 7:16 a.m.
  • RE: Oracle to IDS 10/11 migration
    Jack Parker -- Friday, 10 August 2007, at 10:00 a.m.
    • RE: Oracle to IDS 10/11 migration
      leslie johnson -- Friday, 10 August 2007, at 1:45 p.m.
      • AW: Oracle to IDS 10/11 migration
        Andreas.KUTSCHE@spar.at -- Monday, 13 August 2007, at 10:33 a.m.
        • Re: AW: Oracle to IDS 10/11 migration
          Uday Kale -- Monday, 13 August 2007, at 10:37 a.m.
          • AW: AW: Oracle to IDS 10/11 migration
            Andreas.KUTSCHE@spar.at -- Monday, 13 August 2007, at 10:48 a.m.
            • Re: AW: AW: Oracle to IDS 10/11 migration
              Madison Pruet -- Monday, 13 August 2007, at 11:57 a.m.
              • Re: AW: AW: Oracle to IDS 10/11 migration
                Amitava Chakraborty -- Monday, 13 August 2007, at 3:23 p.m.
    • RE: Oracle to IDS 10/11 migration
      Nilesh Ozarkar -- Friday, 10 August 2007, at 2:01 p.m.
      • RE: Oracle to IDS 10/11 migration
        H.G -- Friday, 10 August 2007, at 8:55 p.m.
  • Re: Oracle to IDS 10/11 migration
    Christine Normile -- Friday, 10 August 2007, at 1:54 p.m.
  • Re:Oracle to IDS 10/11 migration
    ART KAGEL, BLOOMBERG/ 731 LEXIN -- Monday, 13 August 2007, at 12:40 p.m.
    • Re:Oracle to IDS 10/11 migration
      H.G -- Monday, 13 August 2007, at 3:45 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.