RE: Whatcha' wanta have?????

> -----Original Message----- > From: Mark Denham [mailto:mkdenham@comcast.net] > > 1) An 'admin' mode for a database whereby user activity is suspended but > the administrator still has the ability to manipulate the database; > alternatively a means of taking an individual database offline [kicks > off all users, stops user reconnects, allows admin access] without > having to take down the entire server. Totally agree. Sometimes, it is necessary to disconnect all transactional users for a very short time (20-30 seconds) to make necessary database update: reload stored procedure, alter table, create index, etc. Current workaround is to restart Informix with specific network interface down, but it takes more then 20 seconds to restart IDS twice. I think that it should be a mode when only 'informix' user can connect to the database - something between 'online' and 'quiescent' ------------------------------------------ Alexey Sonkin Senior Database Administrator sending to informix-list