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 228

Improve precision for CURRENT_TIMESTAMP on windows

when asking for the CURRENT_TIMESTAMP on Unix systems, we have 6 decimal precisions for the timestamp value. yyyy-mm-dd HH.mm.ss.nnnnnn - TIMESTAMP(6) but for windows, current_Timestamp just provides a milisecond precision yyyy-mm-dd HH.mm.ss.nnn ...
over 2 years ago in Db2 2 Future consideration

User ID metrics Consistency across several monitor interfaces

User Id identification metrics are not consistent across different monitoring interfaces. Db2 offers different metrics to identify the end user. CLIENT_USERID SYSTEM_AUTH_ID SESSION_AUTH_ID The same 3 metrics should be available in ALL places wher...
over 2 years ago in Db2 / Data Management Console 0 Future consideration

IBM should consider releasing Db2 database software as an RPM

We currently create our own RPMs from the database software downloaded from Passport Advantage. This is time consuming and can be eliminated by having IBM package and distribute their software as an RPM for easier consumption like other DBMS vendo...
almost 3 years ago in Db2 2 Future consideration

new aggregated WLM threshold for LOCKLIST at workload/service class level

We have MAXLOCK db-cfg parameter which can be used to avoid a single connection (UOW) to consume the LOCKLIST space. But this parameter some times it not enough. I have seen LOCK escalation cases happening (which locked system tables, causing huge...
over 3 years ago in Db2 0 Future consideration

schema-privilege for USAGE ON SEQUENCE

To GRANT USAGE ON SEQUENCE there is only the old method with db2 grant usage on sequence sq_test to role <rolename> But i want to use schema-privileges, but there is not the function GRANT USAGEIN ON SCHEMA MYSCHEMA TO ROLE <rolename> ...
over 3 years ago in Db2 0 Future consideration

BACKUP INCLUDE LOGS should add logs to backup image as soon as they are closed

Today the log files get added to backup image at end of backup, which could easily cause that log files need to be retrieved from archive that they can be added to backup image. Adding the log files as soon as possible would avoid time consuming a...
over 3 years ago in Db2 0 Future consideration

Allow fixed MAXLOCKS value even if LOCKLIST is AUTOMATIC

When LOCKLIST is set to AUTOMATIC, the MAXLOCKS setting cannot be set. https://www.ibm.com/support/pages/locklist-and-maxlocks-database-configuration-parameters-and-lock-escalations In general this follows the concept of LOCKLIST AUTOMATIC, but th...
about 4 years ago in Db2 0 Future consideration

Add "IF EXISTS" syntax to all DROP statements

More and more SQL is stored in repositories and needs to be applied in odd places and orders. One syntax element that supports this is the "IF EXISTS" on a drop statement. This causes a statement to not count as a failure if it finds no object to ...
about 3 years ago in Db2 0 Future consideration

HADR: Ability to take incremental backups on either host and maintain the incremental chain for restore

In an HADR environment it is not possible to restore / recover the database with backups which are taken from both sites of the HADR cluster (after takeovers). You have to use the backups from the one site or from the other site. You can't mix the...
over 3 years ago in Db2 0 Future consideration

Provide pre and post upgrade dbm and db checks of Db2 parameters and highlight any deltas

It is currently a best practice that we recommend customers do pre and post upgrade dbm and db checks manually. The request is that this should be performed automatically as part of the Db2 upgrade script itself. Comparing before and after parame...
over 2 years ago in Db2 0 Future consideration