Skip to Main Content
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,

  1. Post an idea

  2. Upvote ideas that matter most to you

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


ADD A NEW IDEA

Replication: Q-Replication & Availability

Showing 70

No Expression Procession for CAST_TO_VARCHAR2

z/OS has 65536 code page for Chinese character. CAST_TO_VARCHAR2 does not make any change in character. But the expression with Chinese character causes performance problem. For character in RAW to VARCHAR2, Qrep should ignore the expression CAST_...
over 6 years ago in Replication: Q-Replication & Availability / Q Replication for Z 2 Not under consideration

QRep Automatic Refresh with ICU Decoding

ICBC load existing data from z/OS db2 to Oracle: z/OS exported file -> UDS (ICBC application) decoding -> SQL Loader import to Oracle DB. For QREP automatic Refresh, decoding with customized decoding rule is required. It should be:z/OS expor...
over 6 years ago in Replication: Q-Replication & Availability / Q Replication for Z 1 Planned for future release

QREP supports LOB replication in A-A 2.0

Our customer is adopting QREP for data replication under proxy mode. And they find that QREP couldn't support LOB replication when QCAP runs in proxy DB2 Data Sharing Group. However, our customers have some table defined with LOB columns. So they ...
over 6 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Not under consideration

LOAD should not be restarted when Apply fails during SET INTEGRITY

When setting up Replication for a DB2 Table for the first time Apply will use a LOAD FROM Cursor to do an initial copy of the tables data. If there are constraints or generated columns defined for that table Apply will issue a SET INTEGRITY comman...
over 6 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Planned for future release

Alternative of Updating All or Changed Fields for SQL Update

When replication of SQL Update, only changed fields are updated now. The data consistency cannot be guaranteed if any changes are happened during the period of no replication is executed. All fields updating is required for SQL Update data replica...
over 6 years ago in Replication: Q-Replication & Availability / Q Replication for Z 1 Planned for future release

Automate restart of IIDR tasks when RRS terminates

We had issues with RRS recently which were solved via a maintenance cycle. During those issues, our IIDR Capture and Apply tasks failed and required manual restart. We have the option TERM=N enabled yet the Capture/Apply tasks were not restarted w...
over 6 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Is a defect

Leverage "FOR EACH ROW ON UPDATE" functionality to maintain Peer to Peer Version Columns, instead of triggers

Current implementation of Peer to Peer Version Columns (IBMQREPVERTIME and IBMQREPVERNODE) depend on BEFORE INSERT and BEFORE UPDATE triggers to maintain transaction information for conflict_action of V (last transaction wins). The use of these tr...
over 6 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Not under consideration

ALTER table DATA CAPTURE NONE not detected by IIDR QREP or CDC

If 'ALTER table DATA CAPTURE NONE' is executed against a table that is actively replicating, any changes made to the source data will not be captured or replicated until ‘ALTER table DATA CAPTURE CHANGES' is executed. This would cause the target...
almost 7 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Planned for future release

QREP DDL replication, add UNICODE factor for column length

When replicating from non-unicode to unicode, the legth of char/varchar target columns needs to be extended. Example: create all CHAR/VARCHAR columns at the target with source_length*2 and implemented an additional life belt with OKSQLSTATES = 220...
almost 7 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Planned for future release

zIIP Eligible Q-APPLY

QREP is increasingly become to a key infrastructure component for customers z Systems platform resilience. However, the QREP did need quite a lot MIPS to support. This requirement is for QREP to change some part to be zIIP eligible, specifically f...
almost 7 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Not under consideration