this problem won't occur on an Oracle Database. I've upgraded several AR-Servers from 6.3 to 7.1 within 20 Minutes having tables containing over 100 million records. Kind Regards Conny
________________________________ Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Steve McDonald Gesendet: Dienstag, 28. April 2009 21:55 An: arslist@ARSLIST.ORG Betreff: Accellerating the 6.3 -> 7.x upgrade process ** Hello All, Disclaimer: This upgrade involved an Informix upgrade as well. While testing the ARSystem upgrade process, what we thought would be around 4 hours turned into about 12. With tables containing nearly two million records and an audit trail table with over 9 million, the outage would have been unacceptable. What we found was the ARSystem database upgrade was increasing the length of three columns, c2, c4, and c5, in every table that had them to varchar(254). As part of our upgrade we were changing from v9.4 -> v10 of Informix. My DBA had already created scripts to migrate the data from the 9.4 instance to the 10.0 instance by first creating empty tables and then moving the data. By changing his scripts to pre-alter the three columns in the largest table BEFORE moving in the data, we saved 11 hours of upgrade time as the ARSystem alter effectively did nothing to the table. The problem with Remedy's upgrade script is that it performs 3 seperate alters for every table it changes instead of one alter to change all 3 at once. Having a talented DBA is a good thing! Hope this helps someone. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
