The Multifunctioning DBA

Mar 22 2010   4:44PM GMT

Sybase Upgrade

Colin Smith Colin Smith Profile: 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.

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: