Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.

In some situations (i.e. to prevent schema corruption) you may want to enable a lock mechanism for a Management Service schema. This lock mechanism prevents concurrent access to a Management Service schema - i.e. only one single user can work on the target Management Service schema (with whatever tool is accessing the schema) at any one time.

To enable the Management Service schema locking mechanism, run the following SQL script against the Management Service schema, changing <MNGT> to the name of the Management Service schema you want to lock:

Code Block
set search_path=<MNGT>;
select <MNGT>.sys_set_option('Enable CMS Lock Management', 'yes')