Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

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

hickandre
Contributor II
Contributor II

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 

Thanks  to consider this enhancement.

Tags (2)
2 Comments
Meghann_MacDonald

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.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived