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 1389

"delete cascade" does not work with "not enforced"

The option "not enforced" on a foreign key invalidates an already set "on delete cascade" option, although this is not visible anywhere within the data model or documentation. In my opinion, setting one of these options should prohibit the other o...
over 1 year ago in Db2 / Tables/Index (Range MQ MDC etc.) 0 Not under consideration

More options to generate DDL in DMC

I would like to see more options to include/exclude dependent and ancillary objects when generating DDL for tables. What I need are the Tables, Indexes, History, constraints, and comments, but I don't want views, triggers, stored procedures or oth...
9 months ago in Db2 / Data Management Console 0 Submitted

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...
about 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...
about 3 years ago in Db2 / Other/Unknown 0 Future consideration

DBCFG and DB_GET_CFG to filter updatable parameters only

To mimic the full database configuration, and not only the performance related parms, that db2look would generate update statements for, it would be good to have DBCFG admin view and/or DB_GET_CFG table function to allow selection of the updatable...
about 6 years ago in Db2 / Configuration Parameters 0 Not under 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...
over 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....
over 2 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

STATUS_CHANGE_TIME Colum doesnt exist in in mon_get views

We are currently working to migrate all our SNAP views to MON_GET views/Functions as SNAP views caused a response spike in our PROD environment recently.We are using STATUS_CHANGE_TIME columns of sysibmadm.applications to check lock waits on the d...
over 5 years ago in Db2 / Monitoring 0 Not under consideration

Foreign key with on update "cascade"

As part of the SQL 92 standard, there is a referential action for foreign key that allows to update on cascade. The following link is the SQL 92 standard:http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt In the Section 11.8, there is the f...
over 6 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Preserve table creation timestamp after reorg-finsished using admin_move_table procedure (online table move)

Following Knowledge Center, https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.perf.doc/doc/c0024850.htmlwe perform table reorg using admin_move_table . The issue is, after run admin_move_table command, the original...
over 6 years ago in Db2 / Utilities (Export Import Load db2look etc) 1 Not under consideration