Suggest an Idea

[Cristhian_Herrera]

• 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

[Nulee_Massaro]

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

[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.