Kbase P17453: What are the connection modes for a Progress database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/03/2003 |
|
Status: Unverified
GOAL:
What are the connection modes for a Progress database?
GOAL:
Can you connect in single-user mode when a server is running on the database?
FIX:
1. If you want to connect to the database in single-user mode, then no server is required for the database.
2. If a server is running or has to be running for the database (because it is on a remote system, for example, or because it is from an earlier Progress version), then the concept of "single-user" doesn't apply. Please see the definitions below.
From the Database Administration Guide and Reference:
Connection Modes
Progress databases run in one of two connection modes: single-user or multi-user. Connection modes control how many users can access a database simultaneously.
Single-user Mode
A database running in single-user mode allows one user to access a specified database at a time. If another user is already accessing a database, you cannot connect to that database from a different Progress session. The database engine uses a lock file (.lk) to lock out other users. Running a database in single-user mode is helpful when you perform system administration tasks that require exclusive access to the database.
Multi-user Mode
A database running in multi-user mode enables more than one user to access it simultaneously. A broker coordinates all the database requests from all the users using a single database. For example, the broker process locks the database to prevent any other broker or single-user process from opening it. Also, all users must request access from the broker to connect to the database.