Skip to Main Content
IBM Data Platform Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data Platform 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

Clear

Db2 on-premise

Showing 35 of 18355

Support SQL function to unnest JSON data from arrays

Db2 has native JSON data support. It features functions like JSON_QUERY, JSON_TABLE, and others. However, it is not easy to unnest JSON data stored in arrays. This is required to map nested JSON data to table format. Some other vendors has this ca...
10 days ago in Db2 / Db2 on-premise 0 Submitted

Create TABLESPACE IF NOT EXISTS

Some objects in Db2 LUW can use the IF NOT EXISTS in a CREATE (or IF EXISTS in a DROP), e.g. for TABLE. But the option is not available for Tablespaces. I believe it is available in other RDMS products e.g. SQL Server. Could the option be extended...
2 months ago in Db2 / Db2 on-premise 2 Under review

Add option to add comment on database and query the comment with SQL

Hello,I can add comment on table, comment on column and comments on many more objects, but it seems difficult to add comment on database and impossible to query it. Current work-around is to add comment on database at DBA level. I can SSH to Linux...
8 days ago in Db2 / Db2 on-premise 0 Submitted

Allow binding a tenant into a database alias in the catalog

It would make managing tenancy easier for a dba if the applications could use an alias bame to connect to a certain tenant in a database auyomatically without other changes to the application or uts connection configuration. It could be something ...
about 1 month ago in Db2 / Db2 on-premise 1 Under review

Ability for Reorg Reclaim Extents decrease page count from columnar tables

Currently the Page Count (value seen in column COL_OBJECT_L_PAGES from MON_GET_TABLE) is never reduced even after running Reorg Reclaim Extents.In a columnar table that suffers insert/update/delete we may get into a situation where Db2 will indica...
5 months ago in Db2 / Db2 on-premise 1 Under review

SYSPROC.ENV_GET_SYSTEM_RESOURCES table function should be updated to report Available Memory.

Proposed Enhancement Description (DB2 Virtual Memory usage calculation) DB2 currently calculates VIRTUAL_MEM_IN_USE using the following query: SELECT MEMBER, MEMORY_SWAP_TOTAL, MEMORY_SWAP_FREE, MEMORY_TOTAL, MEMORY_FREE, CAST(( CASE WHEN (MEMORY_...
14 days ago in Db2 / Db2 on-premise 0 Submitted

OpenTelemetry

Please develop an OpenTelemetry Interface for DB2, so that at least on a top level, DB calls can be traced. Ideally, it could be brokwn down to more detail.
about 2 months ago in Db2 / Db2 on-premise 1 Under review

Add REVOKE... ON VIEW for views

Having a view I would like e.g. to remove SELECT privilege on view from MYGROUP. I have executed: REVOKE SELECT ON VIEW USER1.MYTABLE FROM GROUP MYGROUP And I get error:DB21034E The command was processed as an SQL statement because it was not aval...
15 days ago in Db2 / Db2 on-premise 0 Submitted

The basic commands should have an option to output machine processable format like JSON

Using automation tools like Ansible would benefit greatly if commands like db2cm, db2ls, db2 li node/db directory, db2 db/dbm cfg and so on would be able output in JSON format.
3 months ago in Db2 / Db2 on-premise 1 Under review

Make EXPLAIN to work out of the box instead of manually maintaining EXPLAIN tables etc

In PostgreSQL I can just execute: EXPLAIN SELECT * FROM some_table and everything works out of the box, which is very convenient. In IBM Db2 it is required to create EXPLAIN tables, procedures etc basically execute EXPLAIN.DDL script from sqllib/m...
16 days ago in Db2 / Db2 on-premise 0 Submitted