RE: -710's in 24 x 7

David E. Grove wrote > > The problem is either method entails downtime for users. We > typically play > this game every quarter, sometimes more. > > The question is: how do other 24 x 7 shops maintain user > access while making > structural database changes to their application? > We often use synonyms, views, ER and renaming of tables to allow manipulation of tables without affecting users. There are a couple of pitfalls, one of which is to update stats for procedures after renaming tables. This of course depends on the willingness of your contractors to help. Colin Bull c.bull@videonetworks.com sending to informix-list

> This of course depends on the willingness of your contractors to help. Too True. I don't want to embarass pubicly our contractor, but I will say that, in addition to consulting services, they also manufacture a product that is Internally Buffered & Multithreaded, if you get my drift. :-) DG "Colin Bull" <c.bull@videonetworks.com> wrote in message news:bm5t5v$fi$1@terabinaries.xmission.com... > > > > > > David E. Grove wrote > > > > The problem is either method entails downtime for users. We > > typically play > > this game every quarter, sometimes more. > > > > The question is: how do other 24 x 7 shops maintain user > > access while making > > structural database changes to their application? > > > We often use synonyms, views, ER and renaming of tables to allow > manipulation > of tables without affecting users. There are a couple of pitfalls, one of > which > is to update stats for procedures after renaming tables. > > This of course depends on the willingness of your contractors to help. > > Colin Bull > c.bull@videonetworks.com > > sending to informix-list