Oracle to IDS 10/11 migration

Hi there, I have been given responsibility to make a cost effective proposal to migrate one of our production database from Oracle 9i.R2 (Windows 2K) to IDS 10/11 (Linux). It's a c/s application. I am in the process of collating info. on resources, time lines, costing, risk analysis, cost-benefit analysis etc. etc. It's a big challenge for me at the moment to present a very cost effective IDS solution. My questions are: 1. Has any one got any template or a link for a good document for this purpose? 2. Regd. IDS and SDK/CSDK licenses, can someone please clarify; a) I am assuming on server, IDS and SDK both need to be installed? b) From my understanding, IDS & server side SDK are bundled together. Server side SDK will cover under IDS licenses. No separate license required for server side SDK? c) Licenses for client side SDK (CSDK)/Informix connect will be required, if support from IBM is required for CSDK. No license, no support but CSDK still can used? As always, thanks very much in advance. Cheers. --------------------------------- Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when.

H, This is the wrong group for this sort of question. You really need to talk to an IBM sales rep. As for the actual conversion, you should look for the migration toolkit (MTK) - I don't know where it is hiding on the IBM website. j. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of H.G Sent: Friday, August 10, 2007 7:17 AM To: ids@iiug.org Subject: Oracle to IDS 10/11 migration [9750] Hi there, I have been given responsibility to make a cost effective proposal to migrate one of our production database from Oracle 9i.R2 (Windows 2K) to IDS 10/11 (Linux). It's a c/s application. I am in the process of collating info. on resources, time lines, costing, risk analysis, cost-benefit analysis etc. etc. It's a big challenge for me at the moment to present a very cost effective IDS solution. My questions are: 1. Has any one got any template or a link for a good document for this purpose? 2. Regd. IDS and SDK/CSDK licenses, can someone please clarify; a) I am assuming on server, IDS and SDK both need to be installed? b) From my understanding, IDS & server side SDK are bundled together. Server side SDK will cover under IDS licenses. No separate license required for server side SDK? c) Licenses for client side SDK (CSDK)/Informix connect will be required, if support from IBM is required for CSDK. No license, no support but CSDK still can used? As always, thanks very much in advance. Cheers. --------------------------------- Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

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=list&sid=396545433

IBM's migration toolkit is a no-charge offering that can help with the migration of the database. Look for it off the IBM/Informix site. For the client-side executables, I-Connect is the product used. This is a no-charge product and can be freely installed on your client machines. The each developer will need the CSDK license which includes I-Connect. The CSDK is a chargeable product. Speak to your business partner or IBM representative about pricing. Christine On Aug 10, 2007, at 6:16 AM, H.G wrote: > Hi there, > > I have been given responsibility to make a cost effective proposal > to migrate > one of our production database from Oracle 9i.R2 (Windows 2K) to > IDS 10/11 > (Linux). It's a c/s application. I am in the process of collating > info. on > resources, time lines, costing, risk > analysis, cost-benefit analysis etc. etc. It's a big challenge for > me at the > moment to present a very cost effective IDS solution. My questions > are: > > 1. Has any one got any template or a link for a good document for this > purpose? > > 2. Regd. IDS and SDK/CSDK licenses, can someone please clarify; > > a) I am assuming on server, IDS and SDK both need to be installed? > b) From my understanding, IDS & server side SDK are bundled > together. Server > side SDK > will cover under IDS licenses. No separate license required for > server side > SDK? > c) Licenses for client side SDK (CSDK)/Informix connect will be > required, if > support from IBM is required for CSDK. No license, no support but > CSDK still > can used? > > As always, thanks very much in advance. > Cheers. > > --------------------------------- > Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see > what's on, > when. > > > ********************************************************************** > ********* > Forum Note: Use "Reply" to post a response in the discussion forum. >

IBM Migration Toolkit - http://www-306.ibm.com/software/data/db2/migration/mtk/ Regards, - Nilesh "Jack Parker" <jack.parker4@verizon.net> Sent by: ids-bounces@iiug.org 08/10/2007 07:00 AM Please respond to ids@iiug.org To ids@iiug.org cc Subject RE: Oracle to IDS 10/11 migration [9754] H, This is the wrong group for this sort of question. You really need to talk to an IBM sales rep. As for the actual conversion, you should look for the migration toolkit (MTK) - I don't know where it is hiding on the IBM website. j. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of H.G Sent: Friday, August 10, 2007 7:17 AM To: ids@iiug.org Subject: Oracle to IDS 10/11 migration [9750] Hi there, I have been given responsibility to make a cost effective proposal to migrate one of our production database from Oracle 9i.R2 (Windows 2K) to IDS 10/11 (Linux). It's a c/s application. I am in the process of collating info. on resources, time lines, costing, risk analysis, cost-benefit analysis etc. etc. It's a big challenge for me at the moment to present a very cost effective IDS solution. My questions are: 1. Has any one got any template or a link for a good document for this purpose? 2. Regd. IDS and SDK/CSDK licenses, can someone please clarify; a) I am assuming on server, IDS and SDK both need to be installed? b) From my understanding, IDS & server side SDK are bundled together. Server side SDK will cover under IDS licenses. No separate license required for server side SDK? c) Licenses for client side SDK (CSDK)/Informix connect will be required, if support from IBM is required for CSDK. No license, no support but CSDK still can used? As always, thanks very much in advance. Cheers. --------------------------------- Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Thanks everyone for pointing me in a right direction. Appreciated. Cheers. Nilesh Ozarkar <nilesho@us.ibm.com> wrote: IBM Migration Toolkit - http://www-306.ibm.com/software/data/db2/migration/mtk/ Regards, - Nilesh "Jack Parker" Sent by: ids-bounces@iiug.org 08/10/2007 07:00 AM Please respond to ids@iiug.org To ids@iiug.org cc Subject RE: Oracle to IDS 10/11 migration [9754] H, This is the wrong group for this sort of question. You really need to talk to an IBM sales rep. As for the actual conversion, you should look for the migration toolkit (MTK) - I don't know where it is hiding on the IBM website. j. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of H.G Sent: Friday, August 10, 2007 7:17 AM To: ids@iiug.org Subject: Oracle to IDS 10/11 migration [9750] Hi there, I have been given responsibility to make a cost effective proposal to migrate one of our production database from Oracle 9i.R2 (Windows 2K) to IDS 10/11 (Linux). It's a c/s application. I am in the process of collating info. on resources, time lines, costing, risk analysis, cost-benefit analysis etc. etc. It's a big challenge for me at the moment to present a very cost effective IDS solution. My questions are: 1. Has any one got any template or a link for a good document for this purpose? 2. Regd. IDS and SDK/CSDK licenses, can someone please clarify; a) I am assuming on server, IDS and SDK both need to be installed? b) From my understanding, IDS & server side SDK are bundled together. Server side SDK will cover under IDS licenses. No separate license required for server side SDK? c) Licenses for client side SDK (CSDK)/Informix connect will be required, if support from IBM is required for CSDK. No license, no support but CSDK still can used? As always, thanks very much in advance. Cheers. --------------------------------- Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --------------------------------- Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when.

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 Österreichische 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 rechtlich geschützte Informationen, insbesondere Betriebs- oder Geschäftsgeheimnisse, enthalten, zu deren Geheimhaltung der Empfänger verpflichtet ist. Die Informationen in dieser E-Mail sind ausschließlich für den Adressaten bestimmt. Sollten Sie die E-Mail irrtümlich erhalten haben so ersuchen wir Sie, die Nachricht von Ihrem System zu löschen und sich mit uns in Verbindung zu setzen. Über das Internet versandte E-Mails können leicht manipuliert oder unter fremdem Namen erstellt werden. Daher schließen wir die rechtliche Verbindlichkeit der in dieser Nachricht enthaltenen Informationen aus. Der Inhalt der E-Mail ist nur rechtsverbindlich, wenn er von uns schriftlich bestätigt 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ür evtl. hieraus entstehende Schäden. Wir danken für Ihr Verständnis. Important notice: The contents of this e-mail may contain confidential and legally protected information that is in particular related to operational 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 error, 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 under 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 have penetrated your system through the sending of this e-mail, we do not accept liability for any damage that may possibly arise as a result of this. We trust that you appreciate our position. ------------------------------------------- -----Ursprüngliche Nachricht----- > Von: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]Im Auftrag von > 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=list&sid=396545433 > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the discussion forum. > >

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. = "Andreas.KUTSCHE@ = spar.at" = <andreas.kutsche@ = To spar.at> ids@iiug.org = Sent by: = cc ids-bounces@iiug. = org Subj= ect AW: Oracle to IDS 10/11 migratio= n [9763] = 08/13/2007 09:33 = AM = = = Please respond to = ids@iiug.org = = = 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 =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= > 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=3Dlist&sid=3D396545433 > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the discussion forum. > > ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

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 Österreichische 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 rechtlich geschützte Informationen, insbesondere Betriebs- oder Geschäftsgeheimnisse, enthalten, zu deren Geheimhaltung der Empfänger verpflichtet ist. Die Informationen in dieser E-Mail sind ausschließlich für den Adressaten bestimmt. Sollten Sie die E-Mail irrtümlich erhalten haben so ersuchen wir Sie, die Nachricht von Ihrem System zu löschen und sich mit uns in Verbindung zu setzen. Über das Internet versandte E-Mails können leicht manipuliert oder unter fremdem Namen erstellt werden. Daher schließen wir die rechtliche Verbindlichkeit der in dieser Nachricht enthaltenen Informationen aus. Der Inhalt der E-Mail ist nur rechtsverbindlich, wenn er von uns schriftlich bestätigt 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ür evtl. hieraus entstehende Schäden. Wir danken für Ihr Verständnis. Important notice: The contents of this e-mail may contain confidential and legally protected information that is in particular related to operational 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 error, 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 under 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 have penetrated your system through the sending of this e-mail, we do not accept liability for any damage that may possibly arise as a result of this. We trust that you appreciate our position. ------------------------------------------- -----Ursprüngliche 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. > > = > > "Andreas.KUTSCHE@ = > > spar.at" = > > <andreas.kutsche@ = > To > > spar.at> ids@iiug.org = > > Sent by: = > cc > > ids-bounces@iiug. = > > org Subj= > ect > > AW: Oracle to IDS 10/11 migratio= > n > > [9763] = > > 08/13/2007 09:33 = > > AM = > > = > > = > > Please respond to = > > ids@iiug.org = > > = > > = > > 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 =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= > > > 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 > > severa

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

IDS includes runtime support for remote and local clients, however, shared library support for 4GL, and Client SDK clients running locally on the server will require installation of runtime or development copy of C4GL or CSDK as appropriate. C4GL is not free if you are using that you have to pay for the runtimes. CSDK is free without support, support is extra. Art S. Kagel ----- Original Message ----- From: H.G <ids@iiug.org> At: 8/10 7:17:00 Hi there, I have been given responsibility to make a cost effective proposal to migrate one of our production database from Oracle 9i.R2 (Windows 2K) to IDS 10/11 (Linux). It's a c/s application. I am in the process of collating info. on resources, time lines, costing, risk analysis, cost-benefit analysis etc. etc. It's a big challenge for me at the moment to present a very cost effective IDS solution. My questions are: 1. Has any one got any template or a link for a good document for this purpose? 2. Regd. IDS and SDK/CSDK licenses, can someone please clarify; a) I am assuming on server, IDS and SDK both need to be installed? b) From my understanding, IDS & server side SDK are bundled together. Server side SDK will cover under IDS licenses. No separate license required for server side SDK? c) Licenses for client side SDK (CSDK)/Informix connect will be required, if support from IBM is required for CSDK. No license, no support but CSDK still can used? As always, thanks very much in advance. Cheers. --------------------------------- Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

You can check this article also http://www.ibm.com/developerworks/db2/library/techarticle/dm-0707adio/ Thanks.. Amitava "Madison Pruet" <mpruet@us.ibm.co m> To Sent by: ids@iiug.org ids-bounces@iiug. cc org Subject Re: AW: AW: Oracle to IDS 10/11 13/08/2007 21:27 migration [9769] Please respond to ids@iiug.org 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

Thank you VERY much Art as always. Ur reply has given me a clear understanding which will certainly help me for costing. Once again thanks to you and some other dedicated gems to support this community. Cheers. "ART KAGEL, BLOOMBERG/ 731 LEXIN" <kagel@bloomberg.net> wrote: IDS includes runtime support for remote and local clients, however, shared library support for 4GL, and Client SDK clients running locally on the server will require installation of runtime or development copy of C4GL or CSDK as appropriate. C4GL is not free if you are using that you have to pay for the runtimes. CSDK is free without support, support is extra. Art S. Kagel ----- Original Message ----- From: H.G At: 8/10 7:17:00 Hi there, I have been given responsibility to make a cost effective proposal to migrate one of our production database from Oracle 9i.R2 (Windows 2K) to IDS 10/11 (Linux). It's a c/s application. I am in the process of collating info. on resources, time lines, costing, risk analysis, cost-benefit analysis etc. etc. It's a big challenge for me at the moment to present a very cost effective IDS solution. My questions are: 1. Has any one got any template or a link for a good document for this purpose? 2. Regd. IDS and SDK/CSDK licenses, can someone please clarify; a) I am assuming on server, IDS and SDK both need to be installed? b) From my understanding, IDS & server side SDK are bundled together. Server side SDK will cover under IDS licenses. No separate license required for server side SDK? c) Licenses for client side SDK (CSDK)/Informix connect will be required, if support from IBM is required for CSDK. No license, no support but CSDK still can used? As always, thanks very much in advance. Cheers. --------------------------------- Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --------------------------------- Pinpoint customers who are looking for what you sell.