Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
kareem15
Contributor III
Contributor III

Bidirectional task Db2 to RDS

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:

  1. Task 1: Full load from DB2 to RDS
  2. Task 2: Bidirectional replication from DB2 to RDS
  3. 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 successfulScreenshot 2025-01-29 at 10.51.53 PM.pngScreenshot 2025-01-29 at 10.49.46 PM.pngScreenshot 2025-01-29 at 10.49.38 PM.png for both source and target 



  • Task 3: The task is not running and displays the following error:

Screenshot 2025-01-29 at 10.55.10 PM.pngScreenshot 2025-01-29 at 10.54.26 PM.pngScreenshot 2025-01-29 at 10.54.08 PM.png

 

Please let me know if any additional information is required . 

Labels (2)
6 Replies
OritA
Support
Support

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

kareem15
Contributor III
Contributor III
Author

Hi

Task 1 issue has been resolved 

can you assist us with task 3 issue 

DesmondWOO
Support
Support

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

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Kareem_Primerica
Contributor
Contributor

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 ) 

Kareem_Primerica
Contributor
Contributor

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

Kareem_Primerica
Contributor
Contributor

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.