rs_create_repdef

Note: Before you create a new replication definition by using rs_create_repdef, make sure that a replication definition with the same name does not already exist in SAP Replication Server.

Replication Agent is pre-configured to match replication definition datatypes available in SAP Replication Server 15.0 and later. If replication definitions are to be generated against an earlier version of SAP Replication Server, this configuration needs to be changed. Contact SAP Technical Support for assistance in making this adjustment.

If the version of SAP Replication Server that connects to SAP Replication Agent is 15.5 and later, Replication Agent does not add the replicate minimal columns clause when creating replication definitions. You can control minimal columns on DSI by using the SAP Replication Server replicate_minimal_columns parameter. If the version of SAP Replication Server is 15.2 and earlier, Replication Agent adds the replicate minimal columns clause to the replication definitions.

Syntax

rs_create_repdef {all |name} {,display_only}

Parameters

all – A replication definition is created for all tables and procedures that are marked for replication.
name – A replication definition is created for the table or procedure specified by name.
Note: rs_create_repdef always assumes that a database replication definition exists for the primary database.
display_only –
(For Oracle and IBM DB2 UDB only) Shows the proposed Replication Command Language (RCL) or syntax that Replication Agent sends to SAP Replication Server for creating the replication definition.

Usage

The rs_username user must have create object permission before Replication Agent can use it to create replication definitions from SAP Replication Server. You must grant this permission manually from the RSSD.
When a table is marked for replication and the owner mode is set to on, the replication definition created by rs_create_repdef includes the owner name as part of the table name for a table replication definition in the with primary table named clause.
This command always assumes that a database replication definition exists for the primary database. All replication definitions created by rs_create_repdef include the send standby clause, which means the replication definition will only be used by SAP Replication Server if there is already a database level replication definition. The replication definition created by rs_create_repdef cannot be individually subscribed to. If you do not wish to have a database level replication definition, you must use a different tool, or create replication definitions manually, and not use rs_create_repdef.
Use display_only with rs_create_repdef to view the proposed RCL or syntax that Replication Agent sends to SAP Replication Server for creating the replication definition. For example, execute:
```
rs_create_repdef table22, display_only
```
Before creating the replication definition with rs_create_repdef, if table names or column names has special characters “\”, configure the Replication Agent for Oracle to perform reserved word handling:
- Open the RS_repdef_reserved.props file in the $SYBASE/RAX-15_5/config directory.
- Set the RSDEFAULT value to quoted.
  
  This setting enables Replication Agent to create replication definitions using the "quoted" clause on the object name and all column names.
- Save the file.
  
  Note: Make sure the dsi_quoted_identifier is not set to off at the SAP Replication Server. See Configuration Parameters Affecting Physical Database Connections in the SAP Replication Server Administration Guide: Volume1 for more information.
Replication definitions created by rs_create_repdef always define the datatypes using available user defined datatypes that are installed in SAP Replication Server. This means that customers using rs_create_repdef should not set Replication Agent configuration parameter pdb_convert_datetime to true, as doing so converts date and timestamp datatypes to SAP format, instead of UDD format.
Using the Replication Agent configuration parameter pdb_auto_create_repdefs has the same result as executing rs_create_repdef.
When rs_create_repdef is invoked and the parameter “all” or “ALL” is entered, a replication definition is created for all tables or procedures that are marked for replication. If there is a duplication of the replication definition for one or several objects, Replication Agent logs a warning message.
When rs_create_repdef is invoked and the name of a table or procedure that is marked for replication is entered, a replication definition is created only for that table or procedure. If there is a duplication of the replication definition, rs_create_repdef fails and returns an error message.
For each table or procedure for which a replication definition create is attempted, a result set is returned. The result set contains the table or procedure name, replication definition name, and the status of the create replication definition process. If the replication definition is created successfully, the status column display value (created) displays. Otherwise, SAP Replication Server displays an error message.
The character case of the object names in the replication definition will be set according to the ltl_character_case setting.
The naming convention for replication definition is:

ra$<rs_source_ds>_<rs_source_db>_<owner>_<objname>

where:

ra$ is the prefix for all replication definition names.

<rs_source_ds> is the value of the rs_source_ds parameter.

<rs_source_db> is the value of the rs_source_db parameter.

<owner> is the user name of the object owner in primary database.

<objname> is the object name in primary database.

The maximum length of the replication definition name is 255 characters. Replication Agent truncates the name exceeding 255 characters. It also replaces the last n characters of the replication definition name with the object ID in hexadecimal format, where n is the length of the object ID in hexadecimal.
For date columns, the rs_create_repdef command creates a replication definition with a column datatype defined that assumes the Replication Agent pdb_convert_datetime configuration parameter is set to false. If pdb_convert_datetime is set to true, the format of the date value does not match the format expected by SAP Replication Server. To avoid this problem, change the pdb_convert_datetime configuration parameter to false, or manually create the replication definitions (without using the rs_create_repdef command).