solidDB Help : solidDB reference : SQL: System stored procedures : System stored procedures for Advanced Replication : SYNC_SETUP_CATALOG
  
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
)
EXECUTES ON: master or replica.
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.
The possible return codes are listed in the following table:
 
Code
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.
Go up to
System stored procedures for Advanced Replication