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 955

A new command "REBIND QUERY" should be made available.

When packages become invalid due to maintenance activities, they may be rebound when needed. But, when a hint is established by running a "BIND QUERY" command, that bound query may become invalid by these same events. Restoration of that bound que...
about 4 years ago in Db2 for z/OS 1 Not under consideration

Add new parameter for REORG to designate different access behavior when REORG is in LOG/SWITCH phase

Let's say we have zparm IRLMRWT=15, and we have large tablespace REORG with SHRLEVEL(CHANGE) or (REFERENCE), the elapse time of LOG/SWITCH phase is greater than 15 seconds, this causes a lot of online workload timeout with -911. At that time the t...
about 4 years ago in Db2 for z/OS 1 Not under consideration

Index on expression should be used when outer join is rewritten (by the optimizer) as an inner join

When coding the following query (or, generalized query), an index on expression for UPPER(RTRIM(TABB.COLA)) is not used: SELECT ... FROM .... TABA LEFT JOIN TABB ON .... WHERE UPPER(RTRIM(TABB.COLA)) = ? In the above query, it is (originally) writ...
about 6 years ago in Db2 for z/OS 1 Not under consideration

Provide an easy way to de-allocate the underlying Linear dataset when needed without dropping and recreating table spaces and index spaces.

Component: DDL? Data Definition Language? There are cases when a table has change its usage and may remain empty for a very long time or not use anymore but still required to be defined in Db2. In this case, it would be good to have a better way o...
about 2 years ago in Db2 for z/OS 1 Not under consideration

Expand RETPD in template to 5 digits

RETPD parm in the template should allow 5 digits with a value up to 93000
over 6 years ago in Db2 for z/OS 0 Not under consideration

DSNRLMTxx resource limit tables need column for WLM Reporting Group

The DSNRLMTxx resource limit tables aremissing column for WLM Reporting Group. This would allow for resource consumption to be managed at the WLM Reporting Group level (rather than at the userid level, for instance. As WLM is the best method of ma...
about 4 years ago in Db2 for z/OS 1 Not under consideration

Row Change Timesatmp with Precision 12 and Timezone

Row change timestamp is sensitive to changing from daylight savings time to standard time since it doesn't support TIMESTAMP WITH TIMEZONE and other precisions than 6.Applications have two requirements that could be combined and solved by the row ...
over 10 years ago in Db2 for z/OS 1 Not under consideration

Query Nodes - Allow Certain Members of a DB2 Group to Process Queries Against OLTP Data Without Interfering with OLTP

In a DB2 for z/OS data-sharing group, allow customers to designate certain DB2 members as "query-only" subsystems. A "query-only" subsystem, or "query node" would process queries for analytics and business intelligence against the same databases a...
over 6 years ago in Db2 for z/OS 1 Not under consideration

Regular Expressions (regex) scalar function

The XMLQUERY function allows the user to use the 'fn:matches' XQuery function, which is great. Please see example UDF which does this... ~~~~~~~~~~--#SET TERMINATOR ! CREATE FUNCTION "UDF_STRING_REGEX_MATCH" ( SEARCHSTRING VARCHAR (50) ) RETURNS S...
over 8 years ago in Db2 for z/OS 0 Not under consideration

Avoid Db2 failure even if it got BSDS access initialization failure (BSDS timestamp mismatch)

[Background]- Customer's GRSRNL specifies SYSVSAM in systems exclusion list because they need to share CATALOGs. [Description]Our customer got BSDS Access initialization failure and starting Db2 was failed. Please refer to PMR#55237,615,760.They c...
over 6 years ago in Db2 for z/OS 0 Functionality already exists