Re: Alter Table non-exclusive

Some things already only require an exclusive lock momentarily. Most alters that add or drop a column or change it's type, adding or dropping an index, and others are accomplished in-place or online and do not lock that table for long. What are you trying to do that's causing you trouble? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) 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 Wed, Aug 17, 2011 at 6:17 AM, Habichtsberg, Reinhard < RHabichtsberg@arz-emmendingen.de> wrote: > Hi all**** > > ** ** > > We have 24 x 7 production with our Informix databases. We all heard of > Informix Server that ran a year or longer without interruption<http://dict.leo.org/ende?lp=ende&p=Ci4HO3kMAA&search=interruption&trestr=0x8001>;. > **** > > ** ** > > What we wish is the ability to do „Alter tables“ and other administrative > tasks that needs „exclusive locks“ without this need. Each change on the > table structures which come continuous from our software developement causes > trouble with our production: Workflows has to be stopped, dialog programs > can’t run.**** > > ** ** > > Is there any chance do these tasks without exclusive locks, perhaps in > futur? Or, is there any other way to do these tasks without a production > break?**** > > ** ** > > TIA, Reinhard.**** > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >