Kbase P162235: How to find if a user is connected against a read-only Progress database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/03/2010 |
|
Status: Unverified
GOAL:
How to find if a user is connected against a read-only Progress database?
GOAL:
How to find if an ABL client is connected to the target or source replication enabled database?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
Progress 9.1E
FIX:
If a database is opened with -RO, the string returned by the DBRESTRICTIONS function includes the keyword READ-ONLY.
For example:
DEFINE VARIABLE iLoop AS INTEGER NO-UNDO.
DO iLoop = 1 TO NUM-DBS:
MESSAGE DBRESTRICTIONS(iLoop) VIEW-AS ALERT-BOX.
END.
There is no database startup parameter to open a Progress database in read-only mode, only a client connection parameter -RO. Refer to Solution P22224, "How to use the -RO parameter?" for further information in this regard. It is not necessary to use -RO for client access to a replication target enabled database, as the target database is started in Enhanced Read-Only mode by design when a Replication Plus license is in use.