Consultor Eletrônico

SUMMARY:

There are some cases where you want a database to be read only. This could be true for fixed databases or those not frequently updated -- for example a help reference, or a schema holder in a case where you are using a Progress DataServer product.

EXPLANATION:

The way to make a read only database is just by using -RO in the connection parameters.

A read only database can be accessed by multiple users without sharing resources such as database buffers, the lock table (doesn't create an .lk file) or index cursors, so they are less expensive to run. If you serve one of these databases and you connect to it using the connection parameter -RO, you will get the message:

Warning: another user is using this database in update mode.
Accessing the database with -RO may give unexpected results. (1531)

SOLUTION:

To prevent a read only database from being served, set the permissions of the database to read only. If you are in Windows set the file attributes using the property option. If you are in UNIX use the command:

$ chmod 444 mydb*

This will protect the database from being served.


References to Written Documentation:

Progress Database Administration Guide and Reference