[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Is there a faster way to shut down a database than proshut <mydb> -F -by ?

  • Thread starter Thread starter Akshay Guleria
  • Start date Start date
Status
Not open for further replies.
A

Akshay Guleria

Guest
I'll try to explain this in very simplistic manner. It is the state that matters in starting and stopping a DB, so shutting a DB will always take more time. 1. When starting a DB, the DB is at rest, not accessible and hence there are no ongoing transaction and/or activities being performed on it. So the amount of verification and validation needed to start the DB are very minimal (comparably). 2. When stopping a DB, the DB is active and there is lot of activity going on. The shutdown command needs to make sure that all those activities are either finished or rolled back in full before the DB can be stopped, resulting in a consistent DB state.

Continue reading...
 
Status
Not open for further replies.
Back
Top