[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 George Potemkin
  • Start date Start date
Status
Not open for further replies.
G

George Potemkin

Guest
In theory it should be better to allow for all process to undo their transactions when db shutdown is initiated. Otherwise they will be rolled by in single threaded mode by broker at next db startup. So the -F option to shut db down can be a bad choice. Though I did not verify this in the tests. BTW, we can easy get the time of crash recovery at db startup. It's the difference between broker login time and db startup time: FOR FIRST DICTDB._DbStatus NO-LOCK, FIRST DICTDB._Connect NO-LOCK WHERE DICTDB._Connect._Connect-Id EQ 1: DISPLAY DICTDB._Connect._Connect-Time DICTDB._DbStatus._DbStatus-LastOpen WITH SIDE-LABELS 1 DOWN. END. or the interval between the messages: BROKER 0: (333) Multi-user session begin. BROKER 0: (10471) Database connections have been enabled.

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