[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Any proactive schema lock for exclusive access to perform database changes (SQL92 DDL)?

  • Thread starter Thread starter Tim Hutchens
  • Start date Start date
Status
Not open for further replies.
T

Tim Hutchens

Guest
If you were editing schema from the Data Dictionary, you could just start in single-user mode which would lock everyone else out. But I don't think there is a concept of SQL connections in single-user mode. Starting the database on a different port than all the clients are connecting to would essentially lock all of them out because the server wouldn't be listening on that port. If you already are stopping/starting the database, this seems like a very straightforward option. Alternatively, you could mess with database startup parameters to limit the number of connections on that port to a single client, but that seems like a bad idea and you may still have interference with other clients reconnecting before you do.

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