SLT replication into DB2 (z/OS) possible?

[lumirion]

Hello,

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
Ertugrul

[former_member313124]

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.

Thanks

Lingaraj