Posted by: Colin Smith
It has been a while since I spoke about the Sybase Upgrade from 12.5 to 15 that I am working on but it looks like we are very close to making it happen now. All of the application groups have completed testing and signed off on the upgrade. I have been working to make sure that all of the DBA Stuff will run smoothly as well as figure out a timeline for the upgrade.
One thing that we are going to do in order to save some time and be able to get the upgrade done in a reasonable amount of time is cheat a bit on the statistics. For the upgrade to work correctly and run smooth in the 15 environment, we will have to load all the databases from the 12.5, and then update all the statistics on every user table. That takes like 10 hours to run and we do not really have that much time on the go live date. We are going to cheat by doing a load this week, optdiag the statistics out and then when we do the load for go live we will optdiag the stats back in. This will give us 15 stats but they will be a few days old. That should not really matter and from the testing we have done it seems to work great. Then we will be able to run our re-indexing and update stats routines on our normal maintanance schedule and not have to take 10 hours during the upgrade to do so.
Right now I am working on our Re-Indexing scripts to make sure that all will go as planned on upgrade day and during our Re-Indexing windows.