Skip to Main Content
IBM Data and AI Ideas Portal for Customers
Hide about this portal


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 201

Improve performance in queries with IN predicate

Hello! We had problems with CPU in Production environment several months ago with a simple query with IN predicate. The CPU reached 100%! Particularly, this query has many literals within IN predicate and the IN predicate can't be matching. After ...
over 2 years ago in Db2 for z/OS 3 Delivered

Provide a ZPARM to prevent creating new non UTS-tablespaces

I have converted all single table tablespaces to UTS, but some days later new non UTS-tablespaces were created, which I again converted. And again new ones were created, so this process could go for ever.
almost 8 years ago in Db2 for z/OS 1 Delivered

UTS PBG, SINGLETON SELECT and Lock Avoidance.

Hello Db2 for Z/OS Development. Apar PM89016 was created several years ago to implement the lock avoidance for singleton SELECTs with ISO(CS) and CD(YES) when R-scan is used, or the index that is chosen has matching predicates on all columns of th...
over 4 years ago in Db2 for z/OS 2 Delivered

Profile Table Enhancement for local applications

Profile Tables today support only remote connections and no support for local/batch applications. When PT is used to set certain registers, it only works for remote applications and local apps needs to be changed to add certain SET commands.
over 4 years ago in Db2 for z/OS 0 Delivered

Migration of multi-table tablespaces to UTS PBG

Difficulties to migrate from old tablespace types to UTS.DB2 V10 gives us the opportunity to use the ALTER-syntax to change tablespace type from SIMPLE or SEGMENTED to UTS PBG without (almost) any outage. Unfortunately there is a limitation which ...
over 12 years ago in Db2 for z/OS 0 Delivered

DECFLOAT support for COBOL and PLI with DCLGEN

When we run DCLGEN on an object with a DECFLOAT column, we get the following error: DSNE958I DCLGEN DOES NOT SUPPORT THE SQL DATA TYPE DECFLOAT (SQLTYPE 996) FOR THE PLI LANGUAGE DSNE905I EXECUTION COMPLETE, MEMBER ... ADDED The created DECLARE an...
almost 3 years ago in Db2 for z/OS 2 Delivered

Full package support for Restful services

A restful service contains one and only one SQL statement and is, simply put, a mini-static package. It was delivered with a couple of problems. Firstly, the only way to tell if this static package is a restful service is to look at the HOSTLANG c...
almost 3 years ago in Db2 for z/OS 5 Delivered

Eliminate IN list limitation of 32767.

Our organization has a major customer that has run up against this limitation. They have migrated from DB2 LUW and they did not have this limitation. They have IN lists that exceed 100k at times.
over 3 years ago in Db2 for z/OS 3 Delivered

Console message for inoperative packages

MR0125102752 GGDB209021
over 12 years ago in Db2 for z/OS 1 Delivered

Improve the usability of the masking function

According to the manual, column masking has incompatibility with some SQL functions that we use a lot. In our environment, we have many abends with SQLCODE = -20478, example: SELECT CASE WHEN ST_EMAIL LIKE 'MARIA%' THEN 'OK' ELSE 'NOT OK' ENDFROM ...
over 1 year ago in Db2 for z/OS 5 Delivered