article Qlik Replicate: R4Z DB2z No CDC coming through in Official Support Articles

Qlik Replicate: R4Z DB2z No CDC coming through

Barb_Fill21 — Mon, 13 Jun 2022 08:37:38 GMT

R4Z Db2 mainframe install is completed but no Changes are coming through.

Resolution

Check that the Tables you wish to be performing CDC replication upon, have been "turned on" for capturing the changes from the DB2 z/OS Logs.

Do this by using the following command. This can be performed by the DB2 Database Administrator.

Option 1: Make sure the Table has been altered for CDC:

ALTER TABLE schema.table DATA CAPTURE CHANGES

Option 2: If the UserId has the permissions it can be configured on the Db2z Endpoint in the Advanced tab.

Change Data Capture to: Automatically enable Data Capture Changes (requires admin privileges)

Environment

Re: Qlik Replicate: R4Z DB2z No CDC coming through

fio_carpi — Thu, 15 Aug 2024 09:11:47 GMT

I'm facing the same issue right now but, in my case, the involved tables have already the CAPTURE DATA CHANGES set. Any idea of what can be the cause?

Re: Qlik Replicate: R4Z DB2z No CDC coming through

john_wang — Thu, 15 Aug 2024 09:19:12 GMT

Hello @fio_carpi ,

Welcome to Qlik Community forum and thanks for reaching out here!

I'd like suggest you opening a support ticket with below information:

1. The source table creation DDL include PK/Unique index information

2. Make sure the CAPTURE DATA CHANGES set to this table

3. Set SOURCE_CAPTURE to Verbose, reproduce the behavior, then attach the Diagnostics Package to the support ticket

4. Please decrypt the task log files and attach it to support ticket too

Our support team will be more than happy to assist you.

Thanks,

John.