Unique Index Replication

Replication Server supports replication of index-related DDL commands to the SAP HANA database with the control of a new configuration parameter, applied_ddl_index_support.

The following DDL commands are supported:

create unique index
drop index

To enable the replication of these DDL commands, turn on the new configuration parameter applied_ddl_index_support for the connections at both the connection level and the server level. The default value is off.

At the connection level, use the alter connection command to set the configuration for the primary database connection. Use the admin config, 'connection' command to check the configuration results.

At the server level, use the configure replication server command to set the configuration for all connections in the server. Use the admin config command to check the configuration results.

Also see Unique Index Replication in the SAP Replication Server Options New Features Guide for more details.

Note

Restart the connection to the primary database to enable the configuration.
After you turn on this configuration parameter, you cannot change the Replication Server back to versions before 15.7.1 SP204 without purging stable queues if the stable queues contain the index commands in the new format.
This configuration only applies to DDL replication during continuous replication. Creating an index is not supported during materialization for initializing the replicate table, except for the materialization for the SAP Business Suite.
To replicate the index commands, you must use the same Replication Server to manage the connections to both the primary database and the replicate database.