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 1341

Provide a documented and supported procedure to generate ddl (db2look as SP - like db2lk_generate_ddl)

db2lk_generate_ddl is a stored procedure that provides functionality to generate DDL via SQL (similar to db2look which is a tool as db2llok cannot be executed througha SQL client tool. This function already exists but is not documented and I am no...
almost 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 2 Not under consideration

Enhance MON_GET_TRANSACTION_LOG to return Transaction Log number of OLDEST_TX_LSN and the Transaction log number of the minbuflsn recovery information returned by db2pd -dirtypages

Enhance MON_GET_TRANSACTION_LOG to return Transaction Log number of OLDEST_TX_LSN and the Transaction log number of the minbuflsn recovery information returned by db2pd -dirtypages. For example when trying to identify the reason for the First Acti...
9 months ago in Db2 / Backup/Restore/ Rollforward/ Recover / Monitoring 0 Future consideration

Table partitioning for column-organized tables

Column-organized tables are currently not supported for table partitioning (e.g. PARTITION BY RANGE)..At the same time, table partitioning is used by many data warehouse customers to speed up ETL activities - e.g.:(a) load new data into a separate...
almost 7 years ago in Db2 / BLU Acceleration 0 Future consideration

Decouple archive log purging from BACKUP utility

For databases using AUTO_DEL_REC_OBJ, at the end of the BACKUP utility there is a synchronous process which purges any history records and their associated archive logs. This can take a very long time on busy systems. It is necessary to decouple t...
over 6 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 1 Not under consideration

Increase the db2 licence limit for the DMC repository db.

16 VPC is a 2 VP value based on my server.(2core) I have more than 15 DBs to monitor, but the licence limit makes it difficult to increase the CPU. I apologize for the lack of clarity in my explanation. The bundled DB2 license for the DMC repos...
about 1 year ago in Db2 / Data Management Console 2 Not under consideration

When setting 'DB2_COMPATIBILITY_VECTOR=ORA' in non-ora DB, the resulting string length is different.

when it's going to setup "db2set DB2_COMPATIBILITY_VECTOR=ORA"~ $ db2set DB2_COMPATIBILITY_VECTOR=ORA$ db2stop force03/27/2023 18:05:52 0 0 SQL1064N DB2STOP processing was successful.SQL1064N DB2STOP processing was successful.$ db2start03/27/2023 ...
about 1 year ago in Db2 / Application Development 4 Not under consideration

Change replace System-defined in db2 luw to consider NLS characters in search.

Wrong result when executing the replace function with certain characters in the codeset euc-kr DB. (It comes out fine for utf-8 DB, but not for euc-kr.) Case No : TS012082536 *L3 team comment* ##################################################### ...
about 1 year ago in Db2 / Application Development 0 Not under consideration

A DB cfg parameter to set the default tablespace to prevent objects ending up in the wrong TS

When not explicitly set in the CREATE TABLE statement, a newly created table will end up in the last created tablespace. A lot of customers have problems with this for several reasons. They have no control over table placement when using a framewo...
almost 3 years ago in Db2 / Configuration Parameters 0 Future consideration

Allow CREATE/REPLACE for users other than owner

Currently on Db2 LUW CREATE OR REPLACE is only allowed for the owner of a database object. CREATE OR REPLACE authorization should be opened up to allow create/replace by anyone who has the ability to drop the object and to create the object with a...
over 5 years ago in Db2 / Statements (DDL and DML) 3 Not under consideration

Bitemporal tables and missing highest quantiles

If a user issues FOR BUSINESS_TIME AS OF clause against a bitemporal table, DB2 translates it to a where clause with two range predicates against business_time columns. In our system following situation occurs quite frequently: 1) At all time...
almost 2 years ago in Db2 / BLU Acceleration 0 Future consideration