> -----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