SAP Knowledge Base Article - Preview

2774943 - Adding a new table with replicate SQLDML to database replication definition does not take effect - SAP SRS

Symptom

  • To replicate SQL statements in an MSA environment, adding a new table with the replicate SQLDML clause by alter database replication definition command may not take effect.
  • For example, a database replication definition is created with only the replicate tables clause on a table 'TABLE01' first. Then, the database replication definition is altered with the replicate SQLDML clause on tables 'TABLE01' and 'TABLE02'. However, Replication Server does not replicate the added table 'TABLE02'.

// Create a database replication definion
create database replication definition dbrepdef
with primary at PDS.PDB_MSA
replicate tables in (TABLE01)

// Alter the database replication definition
alter database replication definition dbrepdef
with primary at PDS.PDB_MSA
replicate SQLDML in (TABLE01, TABLE02)


Read more...

Environment

  • SAP Replication Server(SRS) 16.0
  • SAP Replication Server(SRS) 15.7.1

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

database replication definition, alter, SQLDML   , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.