IBM Data and AI Ideas Portal for Customers
This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).
Shape the future of IBM!
We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:
Search existing ideas
Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,
Post your ideas
Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.
IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.
ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.
IBM Employees should enter Ideas at https://ideas.ibm.com
Latest discussion with Serge suggests there is a workaround and this idea could be rejected.
Adding histroy from RFE-32425:
4.Davendra PaltooDec 1, 2017 6:32 AMJennifer:
－－之前serge和陶谦应该是指出可以将源端设置65535改成在目标段设置1386，避免主键索引字段引用cast_to_varchar2的做法，功能我验过，计划下周搭环境验证性能。
Serge and Tao Qian suggested that change 65535 in Source with 1386 in Target to prevent cast_to_varchar2 with primary fields. ICBC has tested with the suggestion. The fuction is OK. ICBC plans to set up environment to test performance in next week.
3.Davendra PaltooDec 1, 2017 6:30 AMSerge:
We still need to better understand this issue. We would like to fully understand why the customer needs expression on the replication key and unique indexes. Have they tried defining the subs without those expressions? Is the data coming from the mainframe already in the target Oracle codepage? Are they using codepage_override for both cases?
Today, Q Apply must evaluate the expressions BEFORE it can do dependency analysis on the replication key and other unique indexes. We could consider not evaluating the expression only if and when the expression is a CAST_TO_VARCHAR2 and the source is for BIT DATA (and codepage_override to no conversion). Would that work? For this case, I wonder why there is the expression in the first place.
Unfortunately, removing the expression evaluation before dependency analysis has several implications on Q Apply design and is not entirely trivial. We will need to further assess if it really needed, before we accept this requirement.
2.Davendra PaltooOct 19, 2017 7:47 AMHe Fang to help with the clarification on what is being requested.
1.Davendra PaltooOct 19, 2017 7:42 AMSerge to follow up with client.