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 191

Db2Z INSERT with VALUES should allow multiple rows

Db2 LUW and many other RDMS allow one INSERT with VALUES to insert multiple rows at once. Db2 Z does not allow that syntax. Db2 Z INSERT with VALUES only allows one row at a time So if you have multiple rows you want to insert with the INSERT usin...
over 1 year ago in Db2 for z/OS 3 Delivered

Instrument workfile high-watermarks in ACCTG

This would be useful to all business users that seek to tune their installation for best performance; specifically in the area of MAXTEMPS. Instrument IFCID 0003 and IFCID 0148 counter(s) to show the maximum amount of Workfile used by a thread (4K...
11 months ago in Db2 for z/OS 1 Delivered

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...
over 2 years ago in Db2 for z/OS 0 Delivered

NEW SCALAR function for DB2 SQL – HEX2BIGINT

NEW SCALAR function for DB2 SQL – HEX2BIGINT I would like to see IBM provide a specific function for converting a HEX to BIGINT. I think this would be useful for many/most/all users of Db2! Why? The IBM LOAD utility will report that when input dat...
over 1 year ago in Db2 for z/OS 2 Delivered

DSNT376I message don't supply total information to solve the problem analisys

I found that as soon as the DB2 Lock Escalation message occurred (DSNI031I), DB2 seems to begin rejecting the ESS SQL calls against this tablespace, *immediately* without waiting the DB2 lock timeout interval. This probably explains why there is n...
over 5 years ago in Db2 for z/OS 10 Delivered

Reduce messages DSNI070I -FAST INDEX TRAVERSAL

The new Db2 v12 feature Fast Index Traversal advice at MSTR every 2 minutes about Memory used and indexes applied. This is quite uncomfortable when studing or trying to find something inside MSTR. Example: during 23 days, one Member of a Db2-Produ...
over 4 years ago in Db2 for z/OS 3 Delivered

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 ...
about 2 years ago in Db2 for z/OS 3 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...
about 4 years ago in Db2 for z/OS 2 Delivered

Improve installation CLIST

I have just suffered over two days of Db2 Install Clist and can heartily recommend no-one use it to do a clean Install. The problems are myriad but the absolute number one is when it dies/crashes/abends all input data, apart from two or three rand...
5 months ago in Db2 for z/OS 4 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.
over 7 years ago in Db2 for z/OS 1 Delivered