Informix Upgrade - Some general questions
A DBA planning to move from Solaris 2.6/IDS 7.23-7.24 (4GL 6.04, ISQL 6.03) to Solaris 2.8 and IDS 9.3/9.4 asked about rowid support, ISQL's future, upgrade paths and 4GL compatibility. Answers from the list and an IBM specialist: rowid still works in 9.40 (with caveats on fragmented tables - not unique, blocks detaching fragments); ISQL isn't being dropped (7.32 shipped); 9.40 upgrades directly only from 7.24, so 7.23 should go via 7.24 first (see the migration guide PDF); and 4GL 6.04UC2 isn't certified on Solaris 8 - at least 4GL 7.30UC6 is needed. Questions answered.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Looks like we are finally going to upgrade our Informix environment. I have just a few question (many actually). Everything we have is on Sun2.6 Informix 7.23, and 7.24 are our primary concern right now. 4GL 6.04UC2 ISQL 6.03 We would like to go to Sun2.8 and Informix 9.3 or 9.4. We also use rowid in our applications and we use isql extensively. 1. What version of Informix can you not reference rowid by "rowid"? What release would/could it become an issue. 2. I understand that isql is going away? What version of Informix did/will isql go away. The isql that we currently have is running on a 2.6 machine, would it run on a 2.8 machine and would it work with the newer releases of Informix IDS. 3. I can find references that IDS 7.24 can migrate directly to 9.4. I would like to confirm this. Can IDS 7.23 migrate directly to 9.4? I can not find any reference to this question. 4. Our primary concern is to upgrade the engines. There is no real reason to upgrade our 4gl at this time. Our applications are working fine and we are not looking for new features at this time. The push for the upgrade is driven by the operating system upgrade from 2.6 to 2.8. Will 4GL 6.04UC2 run on a 2.8 operating system? Is there a 4GL 6.04 release for 2.8 ? Any help would be appreciated. Thanks g GE Financial Assurance _________________________________________________ Kenneth C. Olson Database Administrator GE Financial Assurance - Partnership Marketing Group 200 N. Martingale Rd. Schaumburg, IL 60173 %: (847) 605-4610 *: kenneth.olson@gecapital.com
Olson, Kenn.... wrote: > Looks like we are finally going to upgrade our Informix environment. I have > just a few question (many actually). > > Everything we have is on Sun2.6 > Informix 7.23, and 7.24 are our primary concern right now. > 4GL 6.04UC2 > ISQL 6.03 What database server? > We would like to go to Sun2.8 and Informix 9.3 or 9.4. We also use rowid in > our applications and we use isql extensively. > > 1. What version of Informix can you not reference rowid by "rowid"? What > release would/could it become an issue. None. You can reference rowid by "rowid" in all versions. It may become an issue in IDS version 7.x onwards if you decide to use fragmented tables (table partitioning). Even then, if you need rowids then you can add them to fragmented tables and your application will run as before with no changes. > 2. I understand that isql is going away? What version of Informix did/will > isql go away. The isql that we currently have is running on a 2.6 machine, > would it run on a 2.8 machine and would it work with the newer releases of > Informix IDS. Really? Did you get this from IBM? Mmm, you'd need to check compatibility with IBM first. > 3. I can find references that IDS 7.24 can migrate directly to 9.4. I > would like to confirm this. Can IDS 7.23 migrate directly to 9.4? I can > not find any reference to this question. You mean an in-place upgrade. I think it should be possible, but I have never done that particular leap. As with any migration you will be testing this before the actual day, so you can test this then. > 4. Our primary concern is to upgrade the engines. There is no real reason > to upgrade our 4gl at this time. Our applications are working fine and we > are not looking for new features at this time. The push for the upgrade is > driven by the operating system upgrade from 2.6 to 2.8. Will 4GL 6.04UC2 > run on a 2.8 operating system? Is there a 4GL 6.04 release for 2.8 ? Ask IBM. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+
1. What version of Informix can you not reference rowid by "rowid"? What release would/could it become an issue. We strive to maintain backward compatibility in our products in order to ensure ease of upgrade/reversion. Rowid is supported in IDS 9.40 and there are no plans to eliminate it. Be aware that there are restrictions when using rowid on a fragmented tables. For example, you cannot detach a fragment from a table with rowids, so you would have to alter the table to drop the rowid before detaching the fragment. Also be aware that in a fragmented table, the rowid may not be unique. 2. I understand that isql is going away? What version of Informix did/will isql go away. The isql that we currently have is running on a 2.6 machine, would it run on a 2.8 machine and would it work with the newer releases of Informix IDS. I-SQL will be supported as long as customers require. I-SQL 7.32 was released in March of this year. New functionality will be added to other query tools such as DB2 Web Query Tool which is certified to work with IDS. 3. I can find references that IDS 7.24 can migrate directly to 9.4. I would like to confirm this. Can IDS 7.23 migrate directly to 9.4? I can not find any reference to this question. IDS 9.40 is a direct upgrade path from IDS 7.24. For earlier versions of IDS, such as 7.23, we recommend that you upgrade to an interim version of IDS, such as 7.24, prior to upgrading to 9.40. IDS 7.24 is the oldest version that IDS 9.40 will allow reversion from. 4. Our primary concern is to upgrade the engines. There is no real reason to upgrade our 4gl at this time. Our applications are working fine and we are not looking for new features at this time. The push for the upgrade is driven by the operating system upgrade from 2.6 to 2.8. Will 4GL 6.04UC2 run on a 2.8 operating system? Is there a 4GL 6.04 release for 2.8 ? 4GL 6.04 pre-dates my experience so I have asked R&D to answer this. Should you change your mind on upgrading 4GL, 4GL 7.32, released this March, is certified for Sun 6 and 8. To take advantages of some IDS 9 features, 4GL 7.32 is required. Client SDK 2.80 and 2.81 are certified with IDS 9.40. Christine Normile I/T Specialist, Informix Solutions Data Management Worldwide Technical Enablement Toronto Lab Telephone: 877-252-5399 T/L 273-0981 Mobile: 210-365-5073 "Olson, Kenn...." <Kenneth.Olson@ge.com> Sent by: forum.subscriber@iiug.org 09/24/2003 01:36 PM To: ids@iiug.org cc: Subject: Informix Upgrade - Some general questions [1919] Looks like we are finally going to upgrade our Informix environment. I have just a few question (many actually). Everything we have is on Sun2.6 Informix 7.23, and 7.24 are our primary concern right now. 4GL 6.04UC2 ISQL 6.03 We would like to go to Sun2.8 and Informix 9.3 or 9.4. We also use rowid in our applications and we use isql extensively. 1. What version of Informix can you not reference rowid by "rowid"? What release would/could it become an issue. 2. I understand that isql is going away? What version of Informix did/will isql go away. The isql that we currently have is running on a 2.6 machine, would it run on a 2.8 machine and would it work with the newer releases of Informix IDS. 3. I can find references that IDS 7.24 can migrate directly to 9.4. I would like to confirm this. Can IDS 7.23 migrate directly to 9.4? I can not find any reference to this question. 4. Our primary concern is to upgrade the engines. There is no real reason to upgrade our 4gl at this time. Our applications are working fine and we are not looking for new features at this time. The push for the upgrade is driven by the operating system upgrade from 2.6 to 2.8. Will 4GL 6.04UC2 run on a 2.8 operating system? Is there a 4GL 6.04 release for 2.8 ? Any help would be appreciated. Thanks g GE Financial Assurance _________________________________________________ Kenneth C. Olson Database Administrator GE Financial Assurance - Partnership Marketing Group 200 N. Martingale Rd. Schaumburg, IL 60173 %: (847) 605-4610 *: kenneth.olson@gecapital.com
Olson, Kenn.... wrote > > > 3. I can find references that IDS 7.24 can migrate directly to 9.4. I > would like to confirm this. Can IDS 7.23 migrate directly to 9.4? I can > not find any reference to this question. http://publibfi.boulder.ibm.com/epubs/pdf/ct1suna.pdf Chapter 3 Migrating to Dynamic Server 9.40 or 9.30 from 9.x, 7.3x, or 7.24 Will answer all your questions Colin Bull c.bull@videonetworks.com
Regarding 4GL 6.04UC2 on Sun 8, it is not certified. You will need to upgrade to at least 4GL 7.30UC6. Christine Normile I/T Specialist, Informix Solutions Data Management Worldwide Technical Enablement Toronto Lab Telephone: 877-252-5399 T/L 273-0981 Mobile: 210-365-5073 "Olson, Kenn...." <Kenneth.Olson@ge.com> Sent by: forum.subscriber@iiug.org 09/24/2003 01:36 PM To: ids@iiug.org cc: Subject: Informix Upgrade - Some general questions [1919] Looks like we are finally going to upgrade our Informix environment. I have just a few question (many actually). Everything we have is on Sun2.6 Informix 7.23, and 7.24 are our primary concern right now. 4GL 6.04UC2 ISQL 6.03 We would like to go to Sun2.8 and Informix 9.3 or 9.4. We also use rowid in our applications and we use isql extensively. 1. What version of Informix can you not reference rowid by "rowid"? What release would/could it become an issue. 2. I understand that isql is going away? What version of Informix did/will isql go away. The isql that we currently have is running on a 2.6 machine, would it run on a 2.8 machine and would it work with the newer releases of Informix IDS. 3. I can find references that IDS 7.24 can migrate directly to 9.4. I would like to confirm this. Can IDS 7.23 migrate directly to 9.4? I can not find any reference to this question. 4. Our primary concern is to upgrade the engines. There is no real reason to upgrade our 4gl at this time. Our applications are working fine and we are not looking for new features at this time. The push for the upgrade is driven by the operating system upgrade from 2.6 to 2.8. Will 4GL 6.04UC2 run on a 2.8 operating system? Is there a 4GL 6.04 release for 2.8 ? Any help would be appreciated. Thanks g GE Financial Assurance _________________________________________________ Kenneth C. Olson Database Administrator GE Financial Assurance - Partnership Marketing Group 200 N. Martingale Rd. Schaumburg, IL 60173 %: (847) 605-4610 *: kenneth.olson@gecapital.com
IDS 9.30 and 9.40 both have rowids, unless you create a temp table with "create temp table blah blah blah WITH NO LOG".
BRIAN GRELL.... wrote: > IDS 9.30 and 9.40 both have rowids, unless you create a temp table with "create temp table blah blah blah WITH NO LOG". That last statement makes no sense at all. What are you trying to say? If you CREATE TEMP TABLE ... WITH NO LOG, the table will still have rowid's. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+