Re: Keeping users off during maintenance.

John Carlson wrote: > On 15 Oct 2003 11:58:50 -0700, kknauss@yahoo.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? >> > > > Revoke connect privileges to the database? > Fixing their .login (or whatever) so INFORMIXDIR=/dev/null should hold them for a while... -- ( ______ )) .-- Scott MacKenzie; Dine' College ISD --. >===<--. C|~~| (>--- Phone/Voice Mail: 928-724-6639 ---<) | ; o |-' | | \\--- Senior DBA/CARS Coordinator/Etc. --/ | _ | `--' `-- E: scottm at dinecollege dot edu -' `-----' sending to informix-list