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 763

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...
11 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...
11 months 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...
11 months 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...
11 months 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.
12 months ago in Db2 for z/OS 2 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.
12 months 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, ...
12 months ago in Db2 for z/OS 1 Not under consideration

Add wildcard support to all system profile tables filtering criteria categories

Using system profile tables to control workloads is a very useful feature and hence it is more and more used.During our tests, we found out that we have the need to use wildcards within the DSN_PROFILE_TABLE filtering categories of a PROFILEID. In...
about 1 year ago in Db2 for z/OS 1 Not under consideration

Enhance system profile table usage by allowing combination of filtering categories

Using system profile tables to control remote connections/threads is a very useful feature and hence it is more and more used.During our tests, we found out that we have the need to combine DSN_PROFILE_TABLE filtering categories. Currently, for ex...
about 1 year ago in Db2 for z/OS 1 Not under consideration

SQLCODE -413: Add an ID of Column/Host-Variable

Currently SQLCODE -413 looks like this: DSNT408I SQLCODE = -413, ERROR: OVERFLOW OR UNDERFLOW OCCURRED DURING NUMERIC DATA TYPE CONVERSIONDSNT418I SQLSTATE = 22003 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNTZEXE SQL PROCEDURE DETECTING ERROR This...
about 1 year ago in Db2 for z/OS 0 Not under consideration