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 (

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 ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Data & AI Roadmaps ( - Use this site to view roadmaps for Data & AI products.

IBM Employees should enter Ideas at



Db2 for z/OS

Showing 898


Hi, Please could the DB2 V13 command SET LOG REMOVELOG be updated as follows: 1. An option is provided so the the command either works or fails? We want the option to not have REMOVAL PENDING logs in our BSDS after a SET LOG REMOVELOG command is i...
about 1 month ago in Db2 for z/OS 0 Under review

Allow the SQL ALTER statement to convert SYNONYMS into ALIASES.

We have over 800,000 synonyms across 100+ DB2 subsystems/data sharing groups to convert to aliases. In our production environments, the conversion of synonyms to aliases (DROP SYNONYM/CREATE ALIAS) is going to cause carnage because all of our prod...
about 1 month ago in Db2 for z/OS 0 Under review

Correct wrong data in IFCID0172 QW0172HQ/QW0172Q1 when package changes occur during waiting/deadlocking

The issue is that 1.- Thread 1 and Thread 2 get locks 2.- Thread 1 changes packages 3.- Thread 1 and 2 deadlock 4.- Thread 1 is chosen as blocker and deadlock processing uses user data from Thread 1's waiter, but the package dependent information ...
3 months ago in Db2 for z/OS 0 Under review

DB2 z/OS - Message id - DSNJ110E - Additional alerts for active log monitoring and highlighted new message id when DB2 logging was suspended

We had a major incident due to suspended logging for one of the critical customer. One of the critical production DB2 subsystem logging was suspended , caused by stalled archive log offloading process due to insufficient storage space on archive...
about 1 year ago in Db2 for z/OS 0 Future consideration

Adding userid and timestamp info in Database exception table (DBET)

When an objects goes to a pending status or STOP status due to unplanned / unexpected activity, it is difficult to identify who /when the object went to that restrictive status.Already the DBET will be storing information when an object goes to ST...
3 months ago in Db2 for z/OS 0 Future consideration

Use OPTHINT for package with version

Db2 uses the following PLAN_TABLE columns when matching rows that specify access paths to SQL statements: QUERYNO , APPLNAME , PROGNAME , VERSION , COLLID , OPTHINT If I use PKGVERSION(AUTO) during precompile I need to change my OPTHINT every time...
18 days ago in Db2 for z/OS 0 Under review

DDF Start with TCP/IP should be coordinated between Start Listener and Start DDF

During start of DDF inside DB2, DB2 start the Listener for TCP/IP requests and a small timeframe later the DDF. In this timeframe incoming requests are denied with REASON=00D31032 and follow-on errors. As an bypass we do not start DDF automaticall...
2 months ago in Db2 for z/OS 0 Future consideration

Restart Time of DB2 should not be dependent on SCA size

During restart of DB2, the time difference between DSNR003I and DSNR004I is a function of the SCA size. Case TS009645595 was opened and has all the details. But in summary: this large time differenece of 30 seconds (in our case) is a function of t...
2 months ago in Db2 for z/OS 0 Under review

DB2 Return Code Differentiate for Deadlock and Timeout via Subsys Normal Call Exit

DB2 presents IMS ( via Subsystem Normal Call Exit ) with the same return code (4) for: DB2 resource deadlocks DB2 resource unavailable conditions Example, lock timeouts on object locks, such as are taken by DB2 utilities and those caused b...
over 1 year ago in Db2 for z/OS 6 Not under consideration

Support of static SQL (SQLJ) for IntelliJ regarding Code completion and Error Detection

A lot of customers are using IntelliJ enterprise wide, while still using static sql in Java and therefore have a heavy need for support of the IDE and not just read log output and match it with the code in the editor.
about 2 months ago in Db2 for z/OS 3 Not under consideration