SQL Guide : System stored procedures : System stored procedures for advanced replication : SYNC_REGISTER_REPLICA
  
SYNC_REGISTER_REPLICA
The SYNC_REGISTER_REPLICA system stored procedure creates a new catalog and registers the replica with the specified master.
CALL SYNC_REGISTER_REPLICA (
   replica_node_name,       -- WVARCHAR
   replica_catalog_name,    -- WVARCHAR
   master_network_name,     -- WVARCHAR
   master_node_name,        -- WVARCHAR
   user_id,                 -- WVARCHAR
   password                 -- WVARCHAR
)
EXECUTES ON: replica.
You must have administrator or synchronization administrator access rights to execute this stored procedure.
The master_network_name is the connect string of the master database server.
If the specified catalog does not exist, it is created automatically.
If the replica_catalog_name is NULL, the current catalog is used. Also, the master_node_name can be NULL. No other parameter may be NULL.
If registration fails, both master and replica end are reset back to their original status. If any of the parameters have illegal values, an error is returned.
If there are any open transactions that have modified data, an error is returned.
This system procedure does not return a resultset.
RC
Text
Description
13047
No privilege for operation
 
13110
NULL not allowed
Only the catalog name and master node name can be NULL; all other parameters must be non-NULL.
13133
Not a valid license for this product.
 
21xxx
Communication error
Was not able to connect to master. For more details about 21xxx errors, see “solidDB® communication errors” in the solidDB® Administrator Guide.
25005
Message is already active.
 
25031
Transaction is active, operation failed.
The user has made some changes that have not yet been committed.
25035
Message is in use.
 
25051
Unfinished messages found.
 
25052
Failed to set node name to node_name.
The node_name is invalid.
25056
Autocommit not allowed.
You must run this stored procedure with autocommit off.
25057
The replica database has already been registered to a master database.
 
25059
After registration nodename cannot be changed.
 
See also
System stored procedures for advanced replication