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 1388 of 15171

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

Platform switch Windows-Linux using OFFLINE database backup image

A platform switch from Windows to Linux (or Linux to Windows), would be much easier if one can use the DB2 backup image itself. Not necessary between two different DB2 versions, and it doesn't have to be an online backup, and of course platforms a...
over 8 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 0 Not under consideration

Include a comment in the backup

It will be great to include a comment each time a backup is executed. The comment value is included in the history file, it only needs to be used by the backup command.
about 7 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 3 Not under 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

adjust card estimates on predicates using both COL = '?' and COL > <value> similar to accounting for NUMNULLS

Component: DB2 optimizer When a column is NULLable, a predicate COL = ? will account for numnulls to estimate cardinality. The problem comes when column is NOT NULL, and "the NULL value" is a real value. Peoplesoft has been designed to use a major...
over 1 year ago in Db2 / Other/Unknown 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

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...
almost 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...
about 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