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 777

DB2 Multi-Row Fetch/Insert - COBOL Programming Modell

Customer addressed to IBM that the use of DB2 Multi-Row Fetch/Insert is not well accepted by the developers since it increases the programming complexity a lot and is not ease to use in COBOL. Initial discussions pointed to the already addressed "...
about 12 years ago in Db2 for z/OS 0 Not under consideration

LOAD utility by pass checking pending status for empty tables

When LOAD utility is run on a referentially integrated table (child table) while both parent and child tables are empty (no rows) let DB2 refer to RTS data and decide NOT to put the table in CHECK PENDING status.
over 2 years ago in Db2 for z/OS 1 Not under consideration

Create zparm item to change "VOLATILE" table default for implicit create table

Due to our huge DW/Analytics environment in DB2 z we have a lot of tables created by users without details about tablespace and database, so these tables are created with default values of DB2. However, the NOT VOLATILE is default value and can no...
about 4 years ago in Db2 for z/OS 1 Not under consideration

assigning Queryno in Native SP SQLs

Hi,Native Stored Procedure SQLs have no Queryno assigned in Plan_table. All SQLs appear as queryno 1 , no matter how many of them specified in SP. It creates inconvenience in researching access path for SQL statement , as well as impossible to ass...
over 5 years ago in Db2 for z/OS 0 Not under consideration

Fix timeout errors during pending alter materialization reorgs

We're using DB2 z/OS V10 and tried using pending alter for making online schema change on an SAP table to increase a PBG table's DSSIZE from 4 GB to 64 GB. When we ran the SHRLEVEL CHANGE reorg to implement the pending alter, the reorg caused SAP ...
almost 11 years ago in Db2 for z/OS 1 Not under consideration

New DSNACCOX tablespace reorg threshold

Stored procedure DSNACCOX has thresholds for tablespace unclustered inserts (RRTUnclustInsPct) and page splits from updates (RRTIndRefLimit). These both cause fragmentation. However, there is no threshold for the sum of these two, even though many...
over 9 years ago in Db2 for z/OS 1 Not under consideration

Push up of local predicat...

In PMR 89848.077.724 you see an example that the DB2 optimizer is not able to push out local predicates that are specified in the correlated subquery to the parent query block. The predicates AND "AVADMIN"."TLORM_DBFE"."MANDANT" = ? AND "AVADMIN"....
almost 7 years ago in Db2 for z/OS 5 Not under consideration

Change DSNARNMG to have a user define task name

Currently there's a hard coded name in module DSNARNMG. That program always tries to start a task called: DB2UDSMD. That is unacceptable for some installations where they have job and task name standards. This RFE is to add a new ZPARM to allow th...
about 11 years ago in Db2 for z/OS 1 Not under consideration

Allow threads which use the accelerator (IDAA) to go inactive

Today, once a distributed thread has had a query offloaded to IDAA, that thread can never go inactive again. The desired behavior change is to allow distributed threads which utilize the accelerator to follow the same rules for going inactive as a...
about 11 years ago in Db2 for z/OS 1 Not under consideration

JSON support using built in functions instead of UDF

JSON functions in DB2 are implemented as UDF functions and it is understood from IBM that there are performance implications for large volume processing using JSON UDF functions. We would like to request IBM to support JSON functions as Db2 built ...
over 5 years ago in Db2 for z/OS 1 Not under consideration