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 985 of 15597

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...
5 months ago in Db2 for z/OS 1 Future consideration

Convert LRSN to TIMESTAMP

We use CDC replication. When the replication stops for any reason there is a bookmark in the form of an LRSN. We need a way to convert that LRSN to a TIMESTAMP. We need this conversion to see if the LRSN is too old, so we do not have Arhive Logs t...
2 months ago in Db2 for z/OS 2 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

Enhance LOAD to support Load on DATABASE level

We suppose to enhance LOAD utility to allow LOAD DATABASE, intended to create the possibility of loading several or all tables of a database in one step using only one SYSREC file. Background: In the past, using segmented tablespaces, we had the o...
about 1 month 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

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

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.
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...
2 months ago in Db2 for z/OS 0 Under review

Display IAG2 on object level

Sometimes IAG2 will be disabled, in some situations this is clear and ok, in some situations it is strange and not expected. To implement reliable automation we need e.g. an enhancement to DISPLAY DATABASE SPACENAM with IAG, which shows which inse...
over 1 year ago in Db2 for z/OS 0 Future consideration

Blocking Db2 connections to reduce the DSNL030I message flooding.

Often times, an invalid password or a revoked ID results in DSNL030I message. Some web based applications does not have error handling for this message and keeps on trying to connect to Db2 sometimes at a rate of hundreds per second. This flood of...
over 2 years ago in Db2 for z/OS 6