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 for z/OS

Showing 982 of 15493

Violation of referential integrity - enrich the inaccurate messagetext DSNT408I for sqlcode -530 with parent <> child information

If the insert in a child table is not successful because the foreign key value does not match with a primary key value for a given relationship DB2 sends DSNT408I. Looking into this messagetext you will find only the name of the relationship. That...
4 months ago in Db2 for z/OS 1 Future consideration

Availability of DROP SYSTEM PERIOD for System temporal tables.

When a table is defined as a system temporal and the changes need to be reverted for any specific reason - A drop of system period would be needed. This functionality is available in Db2 LUW. Without this, the table has to be dropped and recreated.
about 2 months ago in Db2 for z/OS 0 Under review

Remove the limit on the number of secondary IDs

The documentation states: If RACF is active and the “list of groups” option is active, the routine sets the list of Db2 secondary IDs to the list of group names to which the RACF user ID is connected. The maximum number of groups is 1012. Since RA...
about 2 months ago in Db2 for z/OS 0 Under review

Write Current Compression Dictionary to Log

Write compression dictionary to the Log upon its creation. This would enable true independence of data capture from actual table space availability and/or status. By implication, this might eliminate the need to write the old dictionary to the log...
27 days ago in Db2 for z/OS 0 Under review

When DB2 writes a message to the DB2 Log, DB2 could also optionally write the contents of the message to a new IBM Catalog Table SYSIBM.DB2_Messages or a user defined table.

WHY THIS IS A GOOD IDEA Many of our DB2 subsystems and members remain active for several months or more. Searching for a DB2 Message can take a long time in SDSF when analysing and diagnosing problems. Having all of the DB2 Messages in a Table mak...
6 months ago in Db2 for z/OS 1 Not under consideration

Add global variable support for hopped stored procedures with LOB return parameter

Currently it is not possible to change the value of global variables when an external stored procedure is hopped (for instance called with 3-part-name) and returns LOB data. Please find additional information in the corresponding support case. Som...
about 1 month ago in Db2 for z/OS 0 Under review

Add LOB Support for db2 autonomous storedprocedures

Currently it is not possible to use lob attributes in autonomous procedures. To insert large data into db2 outside the "normal" transaction of work it would be usefull to have autonomous procedures which supports lob data
about 1 month ago in Db2 for z/OS 0 Under review

Stop package invalidation after ALTER MAXPARTITIONS

These days in an agile world we have to ALTER PBG spaces on-the-fly to raise the MAXPARTITIONS value. Sadly this ALTER, even though it is an immediate ALTER, sets all dependent packages to VALID = 'N' which is, of course, a disaster.
about 5 years ago in Db2 for z/OS 8 Not under consideration

Status change or pending DDL when adding a KEY LABEL to an existing table

When an existing table is altered to add a KEY LABEL to enable encryption on the table, the encryption only takes effect post a Reorg (effectively post a redefinition of the underlying VSAM datasets). So the alter is effectively incomplete until s...
2 months ago in Db2 for z/OS 0 Under review

API to write dictionary to log

A number of our common customers run DB2 utilities from third party vendors and IBM replication solutions. They are requesting that our LOAD and REORG utilities write the old dictionary pages to the log for later retrieval by a replication product...
about 5 years ago in Db2 for z/OS 3 Not under consideration