Show TOC

Enhancements to the Commands for Database Replication Definition and SubscriptionLocate this document in the navigation structure

The enhancements to the create database replication definition, check subscription and check database subscription commands are as follows:

  • Get detailed information about subscription using the with statistics parameter:

    In the check subscription and check database subscription commands, a new parameter (with statistics) has been introduced that provides detailed information about table and database subscriptions.

    For example, number of select threads used in materialization, Initial Load Data, Catchup Data and so on.

  • Materialization in user-specified order: For the create database replication definition command, a new parameter (in order) has been introduced that sets the order in which tables within a file will be materialized. A user-specified file lists the tables to be materialized.

    In the following example, the file <reptablelist.txt> provides the order of table materialization:

    create database replication definition <db_repdef>
    with primary at <ds1>.<pdb1>
    replicate tables in files (‘/sap/user/<reptablelist.txt>’)in order
  • Database materialization with multiple select: In the same file, you can also specify the number of select threads for each table using the additional format - <S:number>.
    Note

    To check the number of select threads used for materialization, execute the check database subscription command using the <with statistics> option.