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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
