SYNC_SETUP_CATALOG

The SYNC_SETUP_CATALOG system stored procedure creates a catalog, assigns it a node name, and sets the role of the catalog to be master, replica, or both.

CALL SYNC_SETUP_CATALOG (
  catalog_name, -- WVARCHAR
  node_name, -- WVARCHAR
  is_master, -- INTEGER
  is_replica -- INTEGER
)

You must have administrator or synchronization administrator access rights to execute this stored procedure.

If the catalog_name parameter is NULL, the current catalog is assigned the specified node name and role(s).

For is_master and is_replica, a value of 0 means “no”; any other value means “yes”. At least one of these should be non-zero. Because a single catalog can be both a replica and a master, you can set both is_master and is_replica to non-zero values.

RC	Text	Description
13047	No privilege for operation
13110	NULL not allowed	Only the catalog name can be NULL; all other parameters must be non-NULL.
13133	Not a valid license for this product.
25031	Transaction is active, operation failed.	The user has made some changes that have not yet been committed.
25052	Failed to set node name to node_name.	The node_name is invalid.
25059	After registration nodename cannot be changed.	Catalog has a name already and has one or more replicas.