topic Re: Bidirectional task Db2 to RDS in Qlik Replicate

Bidirectional task Db2 to RDS

kareem15 — Thu, 30 Jan 2025 03:56:23 GMT

Hi Team,

I am in the process of setting up a bidirectional replication task from Db2 (IBM DB2 for z/OS) to RDS (IBM DB2 for LUW) as per the documentation available here: Setting up Bi-Directional Replication.

I have created three tasks:

Task 1: Full load from DB2 to RDS
Task 2: Bidirectional replication from DB2 to RDS
Task 3: Bidirectional replication from RDS to DB2

Here are the issues I am encountering:

Task 1: When performing the full load, it copies the schema but not the data. After applying a filter condition, it only loads a single row.

Test connection is successful for both source and target
Task 3: The task is not running and displays the following error:

Please let me know if any additional information is required .

Re: Bidirectional task Db2 to RDS

OritA — Thu, 30 Jan 2025 08:59:46 GMT

Hi,

In genreal if when performing the full load task only one row is loaded instead of all the table this means that you have a problem probably related to the task setting. In order to troubleshoot it and also further refer to the other issues you are facing , please open a case to support and add to the case the diagnostic packages of all 3 tasks and the description of the problems so we can better understand the scenario and the settings.

Thanks & Regards,

Orit

Re: Bidirectional task Db2 to RDS

kareem15 — Tue, 04 Feb 2025 02:31:09 GMT

Task 1 issue has been resolved

can you assist us with task 3 issue

Re: Bidirectional task Db2 to RDS

DesmondWOO — Tue, 04 Feb 2025 10:21:26 GMT

Hi @kareem15 ,

The SQL30081N error may be related to TCP/IP v6. Please check with DBA or IBM engineer. I recommend creating a full load task from RDS to DB2 to ensure that the connection and permissions are correctly configured.

Regards,
Desmond

Re: Bidirectional task Db2 to RDS

Kareem_Primerica — Tue, 04 Feb 2025 17:13:58 GMT

I Tried a full load from RDS to DB2 and connection is successful and also data got transferred . I guess issue is with CDC (bidirectional task )

Re: Bidirectional task Db2 to RDS

Kareem_Primerica — Tue, 04 Feb 2025 18:31:52 GMT

Is there any Documentation to give qlik access to RDS database logs ?

Re: Bidirectional task Db2 to RDS

Kareem_Primerica — Tue, 04 Feb 2025 18:34:36 GMT

I beleive Qlik is not able to access RDS logs when RDS is source

below is the RDS db2diag.log error :

ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.