Skip to Content

SLT replication into DB2 (z/OS) possible?


in our scenario we would like to replicate data from HANA to DB2 (z/OS). Is this scenario also supported? Do you know which authorizations are necessary on DB2 side to replicate into DB2?

Kind Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 11, 2018 at 03:15 PM

    Dear Ertugrul

    Yes. But supported DB2 versions are 8,9 and 10.

    While establishing a secondary database connection from an SAP LT Replication Server to an DB2 source system, you need the database user data (USERNAME and PASSWORD) with respective privileges to:

    1. to establish a connection to the database.
    2. to connect to a specific schema from the database.
    3. to properly replicate and initially load for a specific table from a given schema, the database user that you have used for establishing connection to the database must have permission to:
    – Select from the specific table
    – Create a table in the given schema (in order to successfully create the logging table)
    – Select from the logging table
    – Delete the logging table
    – Create synonyms and views for the specific table
    – Delete the synonyms and the views

    Kindly refer the note “1778975 – SAP LT Replication Server: Using DB2 as non-SAP source” for complete details.



    Add comment
    10|10000 characters needed characters exceeded