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

[Dmitri Levin]

When I hear a "single-user mode" I could not stop thinking why all other databases in this world did not come to that brilliant idea to have a "single-user mode". To do a schema changes I use "Three ports method" -- the idea I picked up from George many years ago, So I start database with 1 "dummy port", 1 ABL only port and 1 SQL only port. Separation of 4GL from SQL connections does not need explanation. But first I start database with a "dummy" port number. And at this moment I can make any schema changes I want. The side benefit of that method is that I can restart a secondary broker, either 4GL one or SQL one. While I do not have to restart the primary one that I call "dummy" ( the one port number I am not opening to any one).

Continue reading...