Re: finding inplace alters

You do have a way with words don't you Art ? ha. Yea I hear you totally. Thanks again ! ----- Original Message ----- From: art.kagel@gmail.com Sent: Thu, November 18, 2010, 6:48 AM Subject: Re: finding inplace alters Yes, Floyd. If there is even a single table that has pending alters the reversion will fail. Well, it's more like it will refuse to start. If that happens, any way that you can eliminate the pending alters is OK. So unloading the troublesome tables and reloading (either before or after the reversion) is OK. The only problem with waiting until the possible time of reversion to eliminate the pending alters is that at that point you are usually in crunch mode and downtime is a problem. Most people say "But I have downtime scheduled for the upgrade and there's lots of slack in there in case I have to revert!" The problem that they are missing is that it is REALLY rare for the upgrade itself to fail (and if it does a restore is the more likely required way to repair the damage) the more likely scenario is that the upgrade will succeed but after the upgrade, once everything is back online and users are using the system you will discover some serious performance issue or a deal breaking bug that you hadn't found during your testing of the new version in QA beforehand. At that point, users are complaining to support, the head of support has camped out behind your chair, your boss is calling every few minutes to ask when the system will be back, and you are pulling out whate ver little hair you have left after the last big problem. That's not the time to begin a multiple hour long update or unload to eliminate the barriers to reversion. You want to have done that during the several days or weeks prior to the upgrade. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Nov 18, 2010 at 6:14 AM, Floyd Wellershaus >;floyd@fusemail.com