Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Here are the issues I am encountering:
Please let me know if any additional information is required .
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
Hi
Task 1 issue has been resolved
can you assist us with task 3 issue
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
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 )
Is there any Documentation to give qlik access to RDS database logs ?
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.