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:

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