Hi Robert,



I've got it running ok in a couple of production installations.





Win server 2008 - new install, migrated data from ingres 2.6sp2 with
unloaddb.



Solaris 8 - dev box upgraded from ingres 2.6sp2. I messed up the
procedure because I was in a hurry and tried to skip a few steps in the
procedure (be sure to follow the release notes carefully). All working ok
now.







I'm planning to roll it out to Linux EL5, Solaris 9 and Solaris 10 by the
end of the month.



Paul





From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Robert
Allely
Sent: Tuesday, 17 March 2009 12:02 PM
To: Ingres and related product discussion forum
Subject: [Info-Ingres] Upgrading from Ingres 2.6 to Ingres 2006- version 9.2



We have finally decided to move to the new version of the dbms- does anyone
think Ingres 9.2 is too new to move to? How long has it been out there?

Thanks,
Robert



Confidentiality/Privilege Notice:
This communication is confidential and may be legally privileged. If you
are not the intended recipient please delete the message and notify the
sender at Ports of Auckland Limited. Any use, disclosure, copying,
distribution or retention of this communication is strictly prohibited.

Upgrading from Ingres 2.6 to Ingres 2006- version 9.2We moved to 9.1.1 on Solaris 10 October 2008. Since then we've encountered various different bugs and had to deploy 3 patches. We've recently discovered another bug that will require a service pack and another patch. Many of theissues we've faced have been to do with the optimizer and query performance. In some instances queries that worked fine in 2.6 just don't work in 2006. They either hang in the QEF or fill the work location and rollback. 90% of the query performance issues we' ve had were a direct result of a new bug. Some queries just required a little re-working or a new index and they ran OK. In the most recent issue we've discovered a UNION of two queries is returning way more rows than it should do.

Regards

Damien Owen

Sandyx Systems
www.sandyxsystems.co.uk


----- Original Message -----
From: Robert Allely
To: Ingres and related product discussion forum
Sent: Tuesday, March 17, 2009 2:01 AM
Subject: [Info-Ingres] Upgrading from Ingres 2.6 to Ingres 2006-version 9.2


We have finally decided to move to the new version of the dbms- does anyone think Ingres 9.2 is too new to move to? How long has it been out there?

Thanks,
Robert




Confidentiality/Privilege Notice:
This communication is confidential and may be legally privileged. If you are not the intended recipient please delete the message and notify thesender at Ports of Auckland Limited. Any use, disclosure, copying,distribution or retention of this communication is strictly prohibited.



------------------------------------------------------------------------------


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres


-------------------------------------------------------------------------------------------
This email and the files transmitted with it are meant solely for the use of the individual addressee named above. They may contain confidential and/or legally privileged information. If you are not the addressee or responsible for delivery of the message to the addressee, please delete it from your system and contact the sender right away. Sandyx Systems Ltd has taken steps to ensure that this email and any attachments are virus-free,but it remains your responsibility to confirm and ensure this.