Re: migrating from 7.x/9.x to IDS 10....any risks ?

On 4 Oct, 15:14, Veeru71 <m_ad...@hotmail.com> wrote: > We have a got dozens of applications running on Informix Ver 7.x & > 9.x on Solaris for several years successfully. > Now we are planning to upgrade all these installations to Ver 10. > > What are the key things that we have to keep in mind from development > perspective (code perspective) in order to successfully perform this > task ? You should perform a full test of the applicatons that access the database. Every line of application code that is used in your configuration of the application should be tested. > I know few things like > (1) We could have issues with new reserved words (that got added in > various releases) Should be covered by testing above. > (2) The limit on # of varchar columns in a tables has been reduced Should be covered by testing above. > (3) DBAs have to revisit all the config params and tune them properly > after the upgrade. Should be covered by testing above (include load testing). > > Any other big things / obvious things that we have to worry about ? > I am more interested in knowing the risks that we are taking (rather > than benefits we might get) by disturbing the stable systems with > this upgrade plan. > Any expericens ?? > Thanks in advance > - Murty