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

Reduce the number of reasons that require a DB2 member be bought down in order to update the bootstrap dataset using the DSNJ

Reduce the number of reasons that require a DB2 member be bought down in order to update the bootstrap dataset using the DSNJU003 utility.
over 12 years ago in Db2 for z/OS 1 Delivered

Choose statement concentration in JDBC on a per-statement level

Statement concentration is a good thing if you have software that is not well written and uses literals where it should use parameter markers. However, there are cases where using a literal helps the optimizer make a better decision. Statement con...
over 4 years ago in Db2 for z/OS 2 Delivered

Allow application to decide whether lock escalation should occur

Db2 for LUW has an instance-wide configuration parameter DB2_AVOID_LOCK_ESCALATION that controls whether lock escalations occur or applications receive an SQL error. It would be good to have a similar feature in Db2 for z/OS -- of course, not subs...
almost 5 years ago in Db2 for z/OS 2 Delivered

REXX WLM SPAS ddname ZPMDFLTS should not point to sdsnsamp

REXX WLM SPAS has a ddname ZPMDFLTS that points directly atthe customized SDSNSAMP(DSNADMZW) member. This member may not exist if the clist is rerun and the sdsnsamp is reused. DSNADMZW should not be places in SDSNSAMP, and the ZPMDFLTS DD stateme...
over 9 years ago in Db2 for z/OS 1 Delivered

Accurately Report DB2 Real Storage Usage in IFCID 225 When KEEPREAL=YES Is Used

We need additional information to be included in DB2 IFCID 225 (or corrections made to the existing fields) so that we can see the actual current real memory required for a DB2 member instance. This would be true even if the DB2 is running with PM...
almost 10 years ago in Db2 for z/OS 1 Delivered

Caching of plan authorization

When using Db2 external security using SAF (RACF), Db2 does not cache authorization information for plans. This is a different behaviour than for packages and routines, that have their authorization information cached. 
about 5 years ago in Db2 for z/OS 0 Delivered

Additional DB2 MQListener Enhancements

We are about to see a ramp-up in the use of the DB2 MQListener in our production environments serving key application/business channels. We are requesting several enhancements that will improve usability and availability to the business process se...
over 10 years ago in Db2 for z/OS 1 Delivered

Make parent business temporal table updatable

Business temporal tables that are parent table in referential integrity relationship cannot be updated in a way that reflects the time dimension of the data. As described in the attached document there is no way to change any column value from a s...
over 5 years ago in Db2 for z/OS 2 Delivered

Ability to set number of locks before a SQL gets a 00C90096

DB2 currently allows the following LOCKMAX settings.LOCKMAX - 0, , SYSTEM.0 - Lock escalation is disable. or SYSTEM - DB2 escalates the lock after or NUMLKUS is reached.When LOCKMAX is set to 0, an application receives 00C90096 after NUMLKUS is re...
about 11 years ago in Db2 for z/OS 1 Delivered

Capture Connection Security Type in SMF accounting data

This would allow to determine the security type (i.g., Kerberos or not) and track Kerberos adoption based on individual transactions. Unfortunately, the IFCID 319 data cannot be correlated with the specific transactions.
almost 6 years ago in Db2 for z/OS 0 Delivered