Exclusive access to engine in multi-user state

Neurologic's question about exclusive access to a database, and B. Dana's response about secret DBSERVERALIAS's has reminded me of a half-baked theory to get exclusive access to an engine which is still in multi-user mode - necessary for housekeeping scripts and programs. I think I have heard that you can disable and presumably re-enable specific services without having to edit possibly remote files. So, the theory goes: *) setup the usual shm connection for local users, a few tcp servces for remote, and a special admin service. *) Assign the special admin service to $INFORMIXSERVER on chosen session. *) Disable the other services WITHOUT bouncing the engine and without editing sqlhosts, $ONCONFIG etc. So, the whole theory hinges on the ability to "down and up" specific engine connection services thru the command line. Am I dreaming or is there a way to do this? It would be very nice for administrating user sites where the users INSIST on sitting there clicking and clicking and clicking and clicking... Some sites we have, you put the engine online and BANG! 50 users before you can blink. Any ideas? Jonathan? Anyone? -- __END__ Andrew Hamm Technical Consultant Sanderson Australia Pty Ltd e-mail: <mailto:ahamm@sanderson.net.au> web: <http://www.sanderson.net.au>; -- I like cats too - let's exchange recipies

You can always block the port ids at the network hub! Art S. Kagel Andrew Hamm wrote: > > Neurologic's question about exclusive access to a database, and B. Dana's > response about secret DBSERVERALIAS's has reminded me of a half-baked theory > to get exclusive access to an engine which is still in multi-user mode - > necessary for housekeeping scripts and programs. > > I think I have heard that you can disable and presumably re-enable specific > services without having to edit possibly remote files. So, the theory goes: > > *) setup the usual shm connection for local users, a few tcp servces for > remote, and a special admin service. > > *) Assign the special admin service to $INFORMIXSERVER on chosen session. > > *) Disable the other services WITHOUT bouncing the engine and without > editing sqlhosts, $ONCONFIG etc. > > So, the whole theory hinges on the ability to "down and up" specific engine > connection services thru the command line. > > Am I dreaming or is there a way to do this? It would be very nice for > administrating user sites where the users INSIST on sitting there clicking > and clicking and clicking and clicking... Some sites we have, you put the > engine online and BANG! 50 users before you can blink. > > Any ideas? Jonathan? Anyone? > > -- > __END__ > Andrew Hamm > Technical Consultant > Sanderson Australia Pty Ltd > e-mail: <mailto:ahamm@sanderson.net.au> > web: <http://www.sanderson.net.au>; > -- > I like cats too - let's exchange recipies

Art S. Kagel wrote in message <3A66255B.5FA37E92@bloomberg.net>... >You can always block the port ids at the network hub! > >Art S. Kagel > Huh? That's beyond me I'm afraid, and it's also a physical change to some setup isn't it? I was hoping for a simple poke which is undone merely by bouncing the engine. I'm a shocker for remembering to completely restore state after 15 hours of labour. I've been looking in detail at TFM for onmode -p and quite frankly I'm not holding out much hope now. Perhaps it needs to be a feature request to Informix. Sigh*

I didn't see the original message, as it has expired off my server for some reason. Anyway, what about doing a checkpoint with the block option: onmode -c block This disables additional database connections and blocks all current activity. I guess depending on what you originally were asking to be able to do, that might also block out your isql session, or whatever. Rob "Andrew Hamm" <ahamm@sanderson.net.au> wrote in message news:3a66382a@news.iprimus.com.au... > Art S. Kagel wrote in message <3A66255B.5FA37E92@bloomberg.net>... > >You can always block the port ids at the network hub! > > > >Art S. Kagel > > > Huh? That's beyond me I'm afraid, and it's also a physical change to some > setup isn't it? > > I was hoping for a simple poke which is undone merely by bouncing the > engine. I'm a shocker for remembering to completely restore state after 15 > hours of labour. > > I've been looking in detail at TFM for onmode -p and quite frankly I'm not > holding out much hope now. Perhaps it needs to be a feature request to > Informix. > > Sigh* > > >