idea Extend DDL change Processing and Data capture to db2 z/OS system catalog tables when Z/os is defined as a source endpoint in Suggest an Idea

Extend DDL change Processing and Data capture to db2 z/OS system catalog tables when Z/os is defined as a source endpoint

hickandre — Fri, 30 Sep 2022 13:40:50 GMT

Qlik replicate for normal DB2 tables is able to parse the log and get changes correctly based on IFI log format.
For Z/os db2 catalog table, the format in IFI log is different, especially around the metadata of catalog tables which are of different from the normal tables, there are hidden columns for the catalog tables, and the format of the log record seems to even change at times. IBM does not document the content of these log records.

There is an additional challenge that IBM can, and sometimes cause which is changing the format of these log records even within a single version of DB2, making it even more difficult to correctly parse these log records.
To sum up, the parsing logic Replicate uses for normal table does not work for catalog tables.

So we d'like to get the same functionalities (extract DML and capturing DDL changes ) for db2 catalog tables

Thanks to consider this enhancement.

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 15:29:30 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Extend DDL change Processing and Data capture to db2 z/OS system catalog tables when Z/os is defined as a source endpoint - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:29:32 GMT