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 230

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

DMC Reports vs DSM Reports in Email

1) DSM we are getting an email with the database report attached through email , which was easy for us to SAVE / download directly without logging into DSM console . 2) DMC we are getting an email with the link to DMC console where we need to clic...
about 3 years ago in Db2 / Data Management Console 0 Future consideration

Add Transaction Application lock types to the DBMS_LOCK package

We understand that there is an implementation of a version of the Oracle DBMS_LOCK package (minus transaction type and various modes) available on Db2 for LUW. While we can make some use of the session application lock type, we also have a need fo...
over 2 years ago in Db2 / Application Development 0 Future consideration

Copy and use full distributed stats available for federation from DB2 LUW to DB2 LUW

We use federation to check audit records on db2 blu and match then to financial record on Peoplesoft. All treatments are executed from financial DB (row organized), and pb is that nicknames do not take into account distributed stats nor colum grou...
over 2 years ago in Db2 / Federation 0 Future consideration

Enabling readonly mode for database or user. (DB2 LUW)

Would like to see a db level and a user level parameter to enable readonly mode at database level or user level. Currently need to run set of statements to achieve this, which makes management difficult. A single statement to enable readonly mode ...
over 3 years ago in Db2 / Statements (DDL and DML) 0 Future consideration

Get sequence's NEXTCACHEREFRESHVALUE from cache.

Please see the attached word document and as our development teams are trying to retrieve the NEXTCACHEREFESHVALUE value after ALTER SEQUENCE ..RESTART and before invoking NEXT VALUE but could not able to find the way to get the value of NEXT CACH...
over 1 year ago in Db2 / Other/Unknown 0 Future consideration

AUDIT to track view access

We would like to get a mechanism to AUDIT the access of views. We already use EXECUTE category but at table level. We do not use EXECUTE category at database level because it could impact the database performance. We tested all AUDIT categories ti...
over 3 years ago in Db2 / Db2 Warehouse on Cloud 0 Future consideration

Expand DB CFG ddl_compression_def with adaptive option

The adaptive DB CFG extension would give us the opportunity to activate adaptive compression by default. At the moment it is only possible to activate the static camprosseion. Our idea is to set DDL_COMPRESSION_DEF to one of 3 possibilities: 1. NO...
10 months ago in Db2 / Configuration Parameters 0 Future consideration

make FS/Db2 generate some good remote execution plans against big Mongo collections

Problem statement/pain points - refer to what elaborated in TS012101437 for details *for multi-way joins (>2), FS/Db2 currently always generate bad remote SQL execution plans involving full scan of some large collections w/ no filters pushed do...
over 1 year ago in Db2 / NoSQL 0 Future consideration