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 956

DB2 Support for imbedded SQL comments in DBRMs and SYSIBM.SYSPACKSTMT

Full support of imbedded SQL comments in DB2 DBRMs and SYSIBM.SYSPACKSTMT
over 9 years ago in Db2 for z/OS 0 Not under consideration

DB2 DSNTIJPM catmaint update

The pre migration job DSNTIJPM should check for catalog integrity As far as i can count we have got 11 special catmaint update PTF's with hold data in V 10 the DSNTIJPM job should check if all this special caytmaint updates have been solved before...
over 9 years ago in Db2 for z/OS 1 Not under consideration

Implicit cast of decimal/exp notation format comparator to valid decimal value when DSNHDECM DECIMAL=COMMA

When the subsystem decimal point is a period, the following comparisons are treated as valid: WHERE = dddd.ddWHERE = 0.ddddddEnn When the subsystem decimal point is a comma, comparisons in dynamic SQL of the form: WHERE = dddd.ddWHERE = dddd,ddWHE...
over 9 years ago in Db2 for z/OS 0 Not under consideration

Native SQL Stored Procedure Call Statement Does Not Support Using A Host Variable For The Procedure Name

For DB2 V10 and V11. The CALL SQL statement inside a NSP only supports:CALL procedure-name it does not support: CALL host-variable like the CALL SQL statement outside a NSP does. DB2 needs to be changed so that the CALL SQL statement inside a NSP ...
over 9 years ago in Db2 for z/OS 0 Not under consideration

Deployment Of Native SQL Stored Procedures With Validate(Bind) Is Call Order Dependent

For DB2 V10 and V11. When NSPs are created with Validate(Bind), they have to be deployed in reverse call order or the the bind deploys will fail with a procedure not found error. If NSPs are created with Vaildate(Run) to get around this limitation...
over 9 years ago in Db2 for z/OS 1 Not under consideration

Native SQL Stored Procedure Maintenance Is Invalidating Dependent Packages

For DB2 V10 and V11. When any of following 3 things are done against a NSP (Native SQL Stored Procedure)1. Alter to Activate a version2. Bind Deploy Action(Replace)3. Alter RegenerateAll the packages dependent on the NSP are being invalidated and ...
over 9 years ago in Db2 for z/OS 1 Not under consideration

FR583: Enhance IFCID 316 to capture stats of UDFs as well

When the following dynamic SQL query is issued, processing the query involves processing a UDF. This works fine. However, when looking at SQL dynamic statements stats in a DB2 monitor, which retrieves IFCID 316 data from DB2, the data provided is ...
over 9 years ago in Db2 for z/OS 0 Not under consideration

FR581: Enable pushdown and transitive closure for LIKE with parameter markers to table expressions

As part of SAP Core Data Services (CDS), SAP supports 'type as you search' capability when entering values in panels. As part of this processing, they issue the following query on a view which includes a UNION clause. The access path with DB2 is n...
over 9 years ago in Db2 for z/OS 2 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

Avoid CHECK PENDING when adding column with constraint

The ability to add a column to a table and at the same time specifying a check constraint, without having to run check data.The constraint should be "simple", i.e. only referencing the new column.The default value should off course satisfy the con...
over 9 years ago in Db2 for z/OS 1 Not under consideration