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

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

remove all world writable permissions on files and directorys see also 79173

Our Security does not want to see files and directorys which have the world writeable permission set se also fea 79173 PMR is case TS000140222
over 6 years ago in Db2 / Security 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

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

Make DB2 federation option DB2_TWO_PHASE_COMMIT compatible with HOST and PORT options

The new Db2 11.5 HOST and PORT options (see https://www.ibm.com/docs/en/db2/11.5?topic=options-database) remove the need to catalog federated source Db2 databases for standard connections. This simplifies configuration. However, for two phase comm...
9 months ago in Db2 / Federation 0

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

When using SSL to connect to DB2 on z/OS. Add the OCSP feature in the SSL handshake.

One of the new audit requirements in our organization is that OCSP or CRL should be used when SSL is used for communication. If i'm good informed currently this option isn't available in the SSL communication between DB2 on z/OS and it's DB2 conne...
10 months ago in Db2 / Db2 Connect and Drivers 0 Submitted

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