Re: Upgrade to 7.3

In article <6vjj5d$9ki$1@nnrp1.dejanews.com>, cxvale@promarkone.com writes >In article <361CE0EA.3991A2EA@ix.netcom.com>, > "Stephen F. Cawley" <sfcawley@ix.netcom.com> wrote: >> I am starting to plan for an upgrade from 7.24.UC5 to 7.3.UC3 on Solaris >> 2.6, Sun Ultra 2. Has anyone done this upgrade, and would you have any >> advice on what to look out for? >> >> Thanks in advance, >> >> - Steve >> >> > >Boy, have we! We just upgraded 15 ultra 2 from informix 7.23UC1 to 7.3UC2 >last month (solaris 2.51 and 2.6). Here's what we found out: > We have 7.30.UC3-1 for Solaris 2.5.1 and 7.30.UC3 for Solaris 2.6, try upgrading to those... >1) any 4gl with an update subquery within a cursor does not work. the >update doesn't happen. But it does work within dbaccess. The fix is an >environment variable NO_SUBQF. Make sure you bounce your instance with that >env sourced. The problem is with the changes they made to the optimizer, how >it "flattens" subqueries. We put it in /etc/profile. > >2) composite indexes on temporary tables do not work within either 4gl or >dbaccess. > >3) general performance problems without the NO_SUBQF environment variable. > >4) bug with running a level 1 archive -- the problem is with the temporary >dbspace flag. the fix was either make the temp spaces real spaces, or we've >been running a level 0 archive to /dev/null before running the level 1. for >some reason this works. > >We also found that the output of some onstat commands changed, so any scripts >relying on onstat outputs will need to change. I can't remember which one it >was. > >Hope this give you enough heads up. I strongly suggest thorough testing of >all 4gl programs you may use. > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care