Show TOC

Changes to create subscriptionLocate this document in the navigation structure

In this release, you can create a database subscription with materialization of the whole database or a subset of the tables.

Syntax
create subscription <subname>
for database replication definition <repdefname>
with primary at <pdsname.pdbname>
with replicate at <rdsname.rdbname
>
{with materialization 
[[init replicate table with {create | create_or_truncate | truncate | recreate} 
[user <username> password <password>]]
| without materialization}

setname  ::= {tables | transactions}
                setcont  ::= [[in] ([owner1.]name1[, [owner2.]name2 [, ... ]])]
Usage

  • If you use create subscription with the with materialization option, before the materialization process begins, SAP Replication Server automatically marks the primary table replicable with owner on.

    If the table is already marked as replicable with owner on, the materialization continues. If the table is already marked as replicable with owner off, the materialization process stops and reports an error.

  • To perform database materialization for tables with timestamp columns, enable the send_timestamp_to_standby configuration parameter for the direct load connection to the primary Replication Agent, and for the connection to the replicate database.