Progress OpenEdge Database Hub

We can connect to the OpenEdge Database in Single user mode or Multi user user mode.In single user mode database can be accessed by one user at a time. Multi user mode database can be accessed in different ways and multiple user can access the database at a time or simultaneously. Different Connection Mode:- Single-user Mode Multi-user Mode Batch Mode Interactive Mode Single-user Mode: Running an OpenEdge database in Single-user mode allows only one user to access specified database at a time. Database cannot permit to connect a user form a different Progress session if another user is already accessing the database. Database engine maintain a lock file (.lk) to lock out other users from making connecting to the database Multi-user Mode: Running an OpenEdge database in Multi-user mode allows simultaneous access of the database to more than one user. All the database connection requests are coordinated by the broker, and servers retrieve and store data on beh...

Different ways of Starting OpenEdge Database                  OpenEdge database can be Start Up by the four ways: PROSERVE command DBMAN utility OpenEdge Management OpenEdge Explorer    PROSERVE command: §    PROSERVE command starts the  Broker  or  Server   which coordinates all the database requests from all the users to the specified OpenEdge database. §    PROSERVE command starts the main database server i.e.  Broker  which manages all the shared resources and starts the servers as needed for the remote users. §    By default PROSERVE starts the default brokers that can launch both  4GL  and  SQL servers . The 4GL server supports only  remote OpenEdge ABL clients  and SQL server supports only  OpenEdge SQL clients .     DBMAN utility: §   DBMAN utility can only start the database when the da...