LOCK FEATURE feature-name { ON | OFF } 

feature-name :
synchronization schema
| all

You cannot lock a feature more than once for the same connection. If you attempt to unlock a feature that is not locked by the current connection and you do not specify all as the feature name, an error is returned. When a feature is locked by two or more connections, the feature must be unlocked by all connections before it can be used by other connections. Feature locks created by a connection are removed when the connection is dropped. Feature locks are removed when the database server is shut down.

When the synchronization schema feature is locked, the following statements cannot be executed by other connections:

• START SYNCHRONIZATION SCHEMA CHANGE
• CREATE SYNCHRONIZATION SUBSCRIPTION
• DROP SYNCHRONIZATION SUBSCRIPTION
• ALTER SYNCHRONIZATION SUBSCRIPTION
• ALTER PUBLICATION

DBA authority

None

• LOCK TABLE statement

The following statement prevents other connections from using the synchronization schema feature:

LOCK FEATURE 'synchronization schema' ON;