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

Q Replication for Z

Showing 56 of 14438

Ignore log records for a dedicated subscription in IGNORETRANS

In very rare cases Db2 cannot provide log records for Q Capture, e.g. in case of a version mismatch, a compression dictionary error, etc. Removing the subscription and reloading the target is a practical approach. But in some situations (e.g., non...
over 3 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Not under consideration

SQLREP Capture and Apply

#1. SQLREP Capture Program problem There is no way to replay a single registration from DB2 log. Currently it is all or nothing when it comes to starting Capture from a synch point. This is a problem because customers want to have the ability for ...
almost 4 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Not under consideration

Q Replication to Kafka Targets

Kafka evolves as a platform for real time data streaming, analytics, and event processing. For enterprise customers the challenge is to let data originating on IBM z flow to Kafka. Popular options are Kafka APIs, MQ, data replication. Only data re...
almost 4 years ago in Replication: Q-Replication & Availability / Q Replication for Z 3 Not under consideration

Prompt customer need to reduce prune interval

In a busy Q Rep env with many bi-di Q subs, there may lots of P2PNORECAPTURE signal insert into IBMQREP_SIGNAL control table by Q Apply program. As per design, Q Capture delete up to 10000 rows at a time for one prune interval. When the average P2...
about 4 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Is a defect

Reduce the number of Db2 threads when replicating table with XML column

When a table with a XML column is replicated, we observed a high number of SMF Db2 accounting records, one for each row that a have a XML column. The records are due to Db2 threads created by the replication process. As the Db2 SMF records are g...
about 4 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Not under consideration

ASNCLP to support a VALIDATE(NO) option

When creating new replication configurations ASNCLP checks the existence of MQ Queues, qmaps, tables, etc. When deploying to production, we need to have pre-prepared and tested the implementation scripts. However, because ASNCLP validates that the...
over 4 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Planned for future release

Db2 LUW - SQL replication should optionally use TRUNCATE when performing a Full Refresh of large tables

Db2 LUW SQL Replication (10.2.1) When you run a Full Refresh of a subscription set, the asnapply utility issues a DELETE FROM <target table> prior to the refresh of the data. For large tables this has a significant and unnecessary overhead...
almost 5 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Planned for future release

Document process for publication as opposed to subscription migration

The manuals document the process to migrate ALL *subscriptions* to a new Q capture task. Our scenario involved migrating single publications one-by-one (by sendq) to an existing actively used Q capture task. Please update the replication guide for...
almost 5 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Functionality already exists

Display of replication throughput per subscription

Today Q Apply stores detailed performance statistics on queue level. This idea raises the request to store certain Q Apply throuput statistics (like rows_processed) on subscription level. Background: Today it is very difficult / sometime impossibl...
almost 5 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Not under consideration

The Q-Replication apply programm shall be able to call the Db2 High Performance Unload (HPU) utility by the HPU stored procedure

Hello, in enterprise warehouse and OLTP areas of DB2 installations exist often very big databases with several tera bytes (often 100 of TBs) of data. For example we have several OLTP databases with more than 20TB and tables with billion of recor...
about 5 years ago in Replication: Q-Replication & Availability / Q Replication for Z 0 Not under consideration