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 1400 of 15460

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

Create User Temporary Tables in round robin

Assuming that there is more than one temp tablespace with the same page size and 'IN TABLESPACE' clause is not specified in the DECLARE GLOBAL TEMPORARY TABLE command, then DB2 optimizer should allocate the temp tables across all temporary tablesp...
almost 6 years ago in Db2 / BLU Acceleration 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...
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

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

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...
9 months ago in Db2 / Db2 Connect and Drivers 0 Submitted

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

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

SSL encryption enablement with data direct ODBC driver for DB2 Federation Server to SAP HANA

We need SSL encryption enabled with data direct ODBC driver for DB2 Federation Server to SAP HANA. This is the response from IBM Support team. Federation server doesn't support SSL with SAP HANA ODBC drivers. To connect to SAP HANA, customer has t...
about 3 years ago in Db2 0 Planned for future release