Re: Keeping users off during maintenance.

Keith wrote: > Hello All, > > I am trying to automate a database reorg process. One thing I'd like > to do is keep users/applications off the instance while I'm doing the > dbexport/dbimport. Unfortunately quiescent mode doesn't even allow > the user informix access to a database. > > The only thing I can think of is to rename all the databases -- > perform the reorg -- then rename them back. Seems like a crazy way to > do it. Does anyone have any good ideas to achieve this? Hack the sqlhosts entries so that they can't get in, but you can. Or simply move your sqlhosts file and set your environment variable INFORMIXSQLHOSTS to point to it's new location. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list

Thanks, Mark! For no reason I didn't think this would stop a shared memory connection -- but it works fantastic. Thanks to everyone for the quick replies... "Mark D. Stock" <mdstock@mydassolutions.com> wrote in message news:<bmkk8g$4vp$1@terabinaries.xmission.com>... > Keith wrote: > > > Hello All, > > > > I am trying to automate a database reorg process. One thing I'd like > > to do is keep users/applications off the instance while I'm doing the > > dbexport/dbimport. Unfortunately quiescent mode doesn't even allow > > the user informix access to a database. > > > > The only thing I can think of is to rename all the databases -- > > perform the reorg -- then rename them back. Seems like a crazy way to > > do it. Does anyone have any good ideas to achieve this? > > Hack the sqlhosts entries so that they can't get in, but you can. Or simply > move your sqlhosts file and set your environment variable INFORMIXSQLHOSTS > to point to it's new location. > > Cheers, > -- > Mark. > > +----------------------------------------------------------+-----------+ > | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| > | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| > | +-----------------------------------+//// / ///| > | |We value your comments, which have |/// / ////| > | |been recorded and automatically |// / /////| > | |emailed back to us for our records.|/ ////////| > +----------------------+-----------------------------------+-----------+ > > sending to informix-list