Extend DDL change Processing and Data capture to db2 z/OS system catalog tables when Z/os is defined as a source endpoint
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
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.