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

Db2

Showing 1392

db2expln output with XML format.

The db2expln utility provides a plain text file only. Sometimes, OPTPROFILE can be added to tune some terrible SQL. The OPTPROFILE is XML format, but many users is not used to it. If XML format is supported as an option of db2expln then it would b...
over 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

STANDBY_RECV_REPLAY_GAP to be monitored in DMC which is not available at present

We have Standby log receiving enabled for 30 GB. But we are looking for additional parameter as STANDBY_RECV_REPLAY_GAP which is not getting monitored in DMC . Kindly help to get it enabled.
almost 2 years ago in Db2 / Data Management Console 1 Functionality already exists

SELECT * FROM FINAL TABLE (MERGE ...)

SELECT * FROM FINAL TABLE (MERGE ...) - It would be very usefull to select records that were just merged. The same way like with DELETE / UPDATE and INSTERT: SELECT * FROM FINAL TABLE (DELETE / UPDATE / INSERT)
about 9 years ago in Db2 / Application Development 1 Not under consideration

Avoiding 0C7 on UNLOAD from FIC when structure has changed

Hi all, To explain what the idea I'm going to explain the "issue" In a project, we add to drop a column from a table. To do that on multiple environment we use automation tool. The tool drop/create the object without unloading data. So to correct ...
over 3 years ago in Db2 2 Not under consideration

Avoid the database, configured in HADR, on primary side experience an outage when the database on the standby side experience any problem.

We use Db2 pureScale in many environments using POWER System. For our disaster recovery strategy we use HADR for each database between sites. In a specific situation of when some standbys databases experienced HADR_FLAGS = STANDBY_RECV_BLOCKED, re...
over 5 years ago in Db2 / High Availability and/or Disaster Recovery 1 Not under consideration

User management auditing

Our auditor is asking questions like 'Can we see that user X is locked or removed from DB2 when he left the company'. There is no way to see a lock date or create or remove dates on account that are created through the web console.
over 3 years ago in Db2 / Data Management Console 0 Future consideration

db2pd command to report exact operation that causes HADR replay only window

Currently only "Replay only window is active" is reported in db2diag.log, but not the detailed information about the operation that causes the replay only window, such as exact DDL, reorg, runstats, and etc. statements.
over 7 years ago in Db2 / High Availability and/or Disaster Recovery 0 Not under consideration

Real-time statistics with statistics profile can lead to deadlocks and lock timeouts

DB2 real-time statistics facility honors RUNSTATS options specified in the statistics profile, while performing synchronous statistics collection during statement compilation. If the statistics profile contains ALLOW READ ACCESS option, this can l...
about 9 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Ease use of ROS in high volume transaction system utilizing DGTT on Primary db

Trying to utilize ROS to offload reports and heavy queries from Primary Database. Hence we should be able to scale the workload on the Primary, once these are moved away form here. But does not work out for us. Queries are getting forced off often...
almost 2 years ago in Db2 / High Availability and/or Disaster Recovery 1 Is a defect

IBM.EntityFrameworkCore driver doesn't support GUID and BOOL data types with using db2 i series v7r1 databases

Hi, We are delevoping .Net Core project with EntityFrameworkCore that working with AS 400 i series Db2 V7R1. We use many data types but when we want to use bbolean or Guid field types Db2 says undefined name for boolean(bit) and Guid (uniqueidenti...
over 3 years ago in Db2 / Db2 Connect and Drivers 0 Future consideration