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 for Me (Login required).

Search for additional results

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