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.