Re: SHUTDOWN

Loren Budd (Loren_Budd_at_nt.com) wrote:
: A shutdown immediate will not log off any current users, but it will
: prevent new connections from being established. You will still have to
: wait until current transactions are completed before the shutdown will

Okay gang. We just had this discussion. Shutdown normal waits for users to log off. And waits. Any ghost processes that haven't been cleaned up yet will also cause you to wait.

Shutdown immediate will kiss the users and rollback the transactions and actually shut down the dbms *right now*. It is not a clean shutdown, however. You then need to start it up again and then do a Shutdown Normal to get a clean shutdown.

Shutdown abort is for emergency only. Like the infamous 'space leak' problem. You still have to bring it up and do a shutdown normal to make it clean.

Hope this helps.

Roger Snowden
snowden_at_haven.ios.com
snowdenr_at_boystown.org Received on Fri Sep 15 1995 - 00:00:00 CEST