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 777

Enhance Db2 FTB analytics function Db2 V12

Started last weeks activating FTB in development systems by using ZPARM DSN6SPRM.INDEX_MEMORY_CONTROL. Tried to get information using -DISPLAY STATS(INDEXMEMORYUSAGE) LIMIT(*) -DISPLAY STATS(INDEXTRAVERSECOUNT). i thought i will get deeper to it b...
12 months ago in Db2 for z/OS 1 Not under 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...
12 months ago in Db2 for z/OS 4 Not under consideration

to determine that the element following the current element is an element in the tables being accessed and not a ‘rename’ and generate an error message

Currently, when compiling a Cobol program if a comma is missing from the second to last field in a SELECT the DB2 pre-compiler will not give an error because it treats the second table element as a 'rename' this creates problems because no error i...
almost 1 year ago in Db2 for z/OS 1 Not under consideration

Enhance the DISPLAY LOG COMMAND to show if a specific active log dataset belonging to one member of a data sharing group is allocated to 1 or more other members in the data sharing group.

This command would be useful to allow DB2 SYSPROGS/DBAs to see if a specific active log dataset belonging to one member of a data sharing group is allocated to 1 or more other members in the data sharing group. This would allow the REMOVAL PENDING...
almost 1 year ago in Db2 for z/OS 1 Not under consideration

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 year ago in Db2 for z/OS 1 Not under consideration

ADMIN_UTL_MODIFY Enhancement

Enhance ADMIN_UTL_MODIFY to cleanup INPROGRESS entries that didn't complete in their timeframe. Or have the ADMIN_UTL_EXECUTE process cleanup INPROGRESS entries that didn't previous complete.
about 1 year ago in Db2 for z/OS 2 Not under consideration

Customer would like to know if there is a plan to include ZIIP processing for DB2 using Batch and CICS in future releases of DB2.

Customer would like to know if there is a plan to include ZIIP processing for DB2 using Batch and CICS. This would be beneficial to us and our CPU consumption and costs. Has a request been made already to allow ZIIP processing for DB2 via Batch? H...
about 1 year ago in Db2 for z/OS 1 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 1 year ago in Db2 for z/OS 3 Not under consideration

Add option to DCLGEN utility to support conditional compilation based on whether the SQL option is used

Some non-Db2 programs use the member created by the DCLGEN utility as a copy member because they are processing a file with the same layout as the COBOL portion of the DCLGEN member. The DCLGEN generated member contains a DECLARE TABLE statement, ...
about 1 year ago in Db2 for z/OS 1 Not under 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...
about 1 year ago in Db2 for z/OS 1 Not under consideration