Skip to Content
0

SLT replication into DB2 (z/OS) possible?

Apr 11 at 08:59 AM

11

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lingarajkumar Nadagoudara Apr 11 at 03:15 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded