Upgrade to IDS2000 or 7.31??

We've been cleared to upgrade from our current 7.30.uc7 engine, which will be dropped in support at the end of this year. My question is how far up the ladder should be upgrade? Here are a few basic facts: 1. We're a basic OLTP shop running Informix 4GL and Lawson Financials. 2. Our database size is about 20G. 3. We're still using ontape for backups, but we plan to upgrade to OnBar soon. 4. I'd like to get rid of a few bugs and/or workarounds (current with 7.30.uc7) while still maintaining my KAIO capabilities. 5. I'd also like to take advantage of any possible performance benefits, which I believe that both version would have. 6. Also, the end of the year is in sight and support for the 7.30 version will end with it. 7. I really like HPL; hopefully it's not broken in a higher release. 8. I'd like to be able to use VTI (IDS2000 only) to talk to an Oracle database. We have some upcoming development; it would be great to keep the program development within the Informix family (4GL), but I don't know if this capability actually works. Any experienced VTI users out there?? Just thought I'd throw a few things out. It feels good being able to upgrade; it's just a matter of what level to upgrade to. Thanks in advance! -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */

"Carlson@WHSmith" wrote: > > We've been cleared to upgrade from our current 7.30.uc7 engine, which > will be dropped in support at the end of this year. My question is how > far up the ladder should be upgrade? Here are a few basic facts: > > 1. We're a basic OLTP shop running Informix 4GL and Lawson Financials. > 2. Our database size is about 20G. > 3. We're still using ontape for backups, but we plan to upgrade to OnBar > soon. > 4. I'd like to get rid of a few bugs and/or workarounds (current with > 7.30.uc7) while still maintaining my KAIO capabilities. > 5. I'd also like to take advantage of any possible performance benefits, > which I believe that both version would have. > 6. Also, the end of the year is in sight and support for the 7.30 > version will end with it. > 7. I really like HPL; hopefully it's not broken in a higher release. > 8. I'd like to be able to use VTI (IDS2000 only) to talk to an Oracle > database. We have some upcoming development; it would be great to keep > the program development within the Informix family (4GL), but I don't > know if this capability actually works. Any experienced VTI users out > there?? In case Mehdi misses this one, know that Querix claims to be able to port yout 4GL source to Oracle databases and IMS even be able to access both Informix and Oracle from the same app. Worth looking into before you start coding a VTI. > Just thought I'd throw a few things out. It feels good being able to > upgrade; it's just a matter of what level to upgrade to. Thanks in > advance! I'd lean towards IDS.2000. Art S. Kagel

In article <395B7D24.EF88D83E@bellsouth.net>, "Carlson@WHSmith" <carlson1@bellsouth.net> wrote: > We've been cleared to upgrade from our current 7.30.uc7 engine, which > will be dropped in support at the end of this year. My question is how > far up the ladder should be upgrade? Here are a few basic facts: > >> Useful facts snipped.... > 6. Also, the end of the year is in sight and support for the 7.30 > version will end with it. >> More useful facts snipped... For what it's worth, my reading of the latest support matrix on the Informix site has IDS 7.3x for UNIX staying in category 3, with no move to category 4 announced. The previous matrix had 7.30 moving into category 4 at the end of the year. We're still looking to upgrade, and the future seems to be IDS2000 so that's the way it's going. However, missing the end of the year is now less critical... John. Sent via Deja.com http://www.deja.com/ Before you buy.

goodbodyj@my-deja.com wrote: > > In article <395B7D24.EF88D83E@bellsouth.net>, > "Carlson@WHSmith" <carlson1@bellsouth.net> wrote: > > We've been cleared to upgrade from our current 7.30.uc7 engine, which > > will be dropped in support at the end of this year. My question is > how > > far up the ladder should be upgrade? Here are a few basic facts: > > > > >> Useful facts snipped.... > > > 6. Also, the end of the year is in sight and support for the 7.30 > > version will end with it. > > >> More useful facts snipped... > > For what it's worth, my reading of the latest support matrix on the > Informix site has IDS 7.3x for UNIX staying in category 3, with no move > to category 4 announced. > > The previous matrix had 7.30 moving into category 4 at the end of the > year. > > We're still looking to upgrade, and the future seems to be IDS2000 so > that's the way it's going. However, missing the end of the year is now > less critical... > This is true. I verified it with Customer Service. The date has not been set, but the CSR said that, assuming that the development matrix is consistent that 7.30 would be decommissioned around the beginning of the year. Hopefully I can still do my upgrade even if 7.30 sticks around . . . . so many new toys to play with . . . . <G>. -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */

In article <3960E22F.F20A06D8@bellsouth.net>, Carlson@WHSmith <carlson1@bellsouth.net> writes >goodbodyj@my-deja.com wrote: >> >> > > >This is true. I verified it with Customer Service. The date has not >been set, but the CSR said that, assuming that the development matrix is >consistent that 7.30 would be decommissioned around the beginning of the >year. Hopefully I can still do my upgrade even if 7.30 sticks around . >. . . so many new toys to play with . . . . <G>. > I would definitely go for 7.31.X i.e. 7.31.UC6-1 or higher (Informix UK said UC7 was not released yet due to a problem so expect UC7 and UC8 close together). IDS 2000 is not as widely used in production as 7.31 and hence not as well field tested. -- David Williams