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 1386

Case TS000932532 - Load should be able to bypass a GENERATED-ALWAYS-from-variable column

ProblemA load on a table containing a certain type of GENERATED ALWAYS column fails with the very odd message "Unexpected load gencol section".Research pointed out that LOAD cannot handle in any way a GENERATED ALWAYS column getting its informatio...
over 6 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

LOAD should allow collecting STATISTICS without USE PROFILE option for row based tables

LOAD collects "default" statistics like auto-runstats when loading into BLU (RUNSTATS ... WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL).I assume this got not changed because the fear of incompatibility with existing behavior. Therefore pleas...
over 6 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

ALTER TABLE LOCKSIZE TABLE for BLU tables

ALTER TABLE LOCKSIZE TABLE is an easy way to save lock list and lock acquire for tables that just get accessed by a single application at a given time.
over 6 years ago in Db2 / BLU Acceleration 0 Not under consideration

Add Estimated Percentage Complete for database restore in db2 list utilities show detail

When backup is executing and in another session "list utilities show detail" is executed there is e.g. "Estimated Percentage Complete = 30" displayed. But when restore is performed this estimated percentage is missing. Please add this info for res...
about 2 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 0 Future consideration

Add support for database SINGLE_USER mode access

Time to time there is requirement to be the only user on the database like drop and create database, but there are also users with system authorizations connected to database. Or there is product (even from IBM) like Maximo: https://www.ibm.com/su...
about 2 years ago in Db2 / Security 0 Not under consideration

Add support for INFORMATION_SCHEMA views

In our company we are using PostgreSQL, SQL Server, MySQL and DB2. All of database except Db2 support INFORMATION_SCHEMA views. There is pretty easy to write at least basic cross-database SQL to get info from database catalog tables except in Db2....
about 2 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Rewind the current database from logs

Opposite to roll forward, it will be great to have the possibility to perform a rewind of a database (in roll-forward state or normal one), to a previous state with the logs. It will be like uncommit, or a general rollback.
about 4 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 0 Not under consideration

Add flag into db2advis to ignore existing indexes

When troubleshooting performance issues on tables with a high number of indexes, the db2advis tool kind of falls flat. What we have done to get around this is to restore a backup of the database in question, drop all indexes, and then run the db2a...
over 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

Please add a built-in function to reverse a string

Currently to reverse a string, we have to create a udf. The syntax for a simple one was easily available on the SQLTips4Db2 blog .... which IBM has removed. I think Db2 on z has this, and some other variants of SQL out there include it. This is th...
almost 3 years ago in Db2 / Other/Unknown 0 Future consideration

Please add a built-in function for pi

Currently there is no built-in function for pi. It can be calculated using math on trigonometric functions, but this is mildly annoying. Pi is frequently used when working with different random variate distributions and other functions that are in...
almost 3 years ago in Db2 / Other/Unknown 0 Future consideration