idea Re: Allow Qlik Replicate to Select and replicate Db2 Aliases - Status changed to: Open - On Roadmap in Suggest an Idea

Allow Qlik Replicate to Select and replicate Db2 Aliases

Cristhian_Herrera — Tue, 13 Dec 2022 20:22:38 GMT

In DB2, tables have members – a way of partitioning data. When Replicate copies data from DB2 tables that contains members, only the first member gets copied/replicated. According to our DB2 experts, this is a limitation of DB2 SQL. However, there is a way of replicating data for all members: creating DB2 aliases.
DB2 aliases allow us to create a table – alias – that specifically points to a given member. Here is an example of how to create an alias on DB2 for a given member (MBR2) of a table (MYFILE):

CREATE ALIAS MYLIB.MYMBR2_ALIAS FOR MYLIB.MYFILE (MBR2)

Where MYMBR2_ALIAS is the name of the new table containing data for member MBR2.

In Replicate, we cannot see these aliases when we search for tables in the Replicate task.
We need to be able to replicate ALL data for all members of a table. This can be done by replicating table aliases. We need Replicate to read and add aliases into the Replicate task when selecting Tables.
We have a support ticket for this: Support Ticket 00061231

Re: Allow Qlik Replicate to Select and replicate Db2 Aliases - Status changed to: Open - On Roadmap

Nulee_Massaro — Tue, 18 Apr 2023 18:25:54 GMT

Thank you for your suggestion. We have added this to our roadmap.

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

Meghann_MacDonald — Wed, 02 Aug 2023 15:02:38 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: Allow Qlik Replicate to Select and replicate Db2 Aliases - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:02:40 GMT