v11 upgrade

hello all I am wondering what kind of experiences people are having upgrading to version 11 - specifically in place upgrades. we are currently on AIX 5.3 (on a carved out LPAR) running HDR with version 10.FC9 thanks tom

-----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Tom Lehr Sent: Thursday, October 15, 2009 8:14 AM To: informix-list@iiug.org Subject: v11 upgrade hello all I am wondering what kind of experiences people are having upgrading to version 11 - specifically in place upgrades. we are currently on AIX 5.3 (on a carved out LPAR) running HDR with version 10.FC9 thanks tom -- One problem that we had was existing entries in the SYSAGGREGATES table in each database. It seems that when going from IDS 10.00.FC8 to 11.50.FC4 it would fail hard and I could not revert, I had to restore. Apparently, 11.50 "assumes" that the sysaggregates are NOT there and tries to create them, thus failing. This is an example of one of the entries that will trip you up. name aggrxml owner informix aggid 5 init_func init_aggrxml iter_func iter_aggrxml combine_func comb_aggrxml final_func final_aggrxml handlesnulls f My solution was to create Level 0 first, to be safe, drop all entries in the SYSAGGREGATES tables for each DB in your instance, then do the upgrade. Of course the usual checks apply as well: Check for no in place alters as well as make sure that you do not have any open transactions. Joe

I can only say that so far all of our clients who have made the step from 10 to 11.50 or the leap up from 7.31 have been happy with the results. Most have been in-place upgrades while several have been migrations to an upgraded server or even part of a hardware upgrade. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Oct 15, 2009 at 9:14 AM, Tom Lehr <tomcaml@gmail.com> wrote: > hello all > > I am wondering what kind of experiences people are having upgrading to > version 11 - specifically in place upgrades. > we are currently on AIX 5.3 (on a carved out LPAR) running HDR with > version 10.FC9 > > thanks > tom > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >