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 781

Update statistics profile from SYSIBM.SYSFEEDBACK by demand.

We are running under DB2 v12 level 501 Data Sharing 17-way and he is using statistics feedback with profile, but since it is an autonomic process for all objects there are some package access path becoming worst after run utilities with RUNSTATS U...
over 4 years ago in Db2 for z/OS 1 Not under consideration

Support DECFLOAT in COBOL

DECFLOAT was introduced in DB2 9 and has just recently been enhanced to be usable in indexes. However the datatype is not supported in COBOL and FORTRAN and only "tolerated" in REXX (as a DOUBLE and then without NAN, SNAN or INFINITY). As a mainfr...
almost 5 years ago in Db2 for z/OS 3 Not under consideration

new DB2 SQL/DDL > DECLARE (GLOBAL) TEMPORARY VARIABLE

Db2 v11 introduced CREATE VARIABLE. pretty handy... but it must be created in advance. How about a dynamic SQL/DDL equivalent? DECLARE TEMPORARY VARIABLE xyx OR DECLARE GLOBAL TEMPORARY VARIABLE xyz It would be useful for anyone (ie. ...
about 5 years ago in Db2 for z/OS 1 Not under consideration

Bypass Package BIND/REBIND Locks for EXPLAIN(ONLY)

We have an analysis tool that we use to analyze potential changes in access paths. For timeliness of analysis our need is to use this tool during the business day. The tool uses EXPLAIN(ONLY) as a BIND parameter. Based on system workload, we exper...
about 5 years ago in Db2 for z/OS 2 Not under consideration

Data-partitioned secondary index (dpsi) support for row change timestamp columns

To identify which rows of a table have changed in specified time interval we are using timestamp columns. The values of these columns are set via the "GENERATED BY DEFAULT FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP" clause. To optimize query p...
about 5 years ago in Db2 for z/OS 1 Not under consideration

Allow BIND EXPLAIN(ONLY) use virtual indexes

It would be very helpful if Db2 allowed (optionally) to use virtual indexes when BIND with EXPLAIN(ONLY) is performed. This can be an additional BIND parameter on whether or not use virtual indexes. This option will eliminate/reduce a need in thir...
over 5 years ago in Db2 for z/OS 6 Not under consideration

Remove the OBID limitations in the workfile database

Aapplication threads that perform OPEN / FETCH / CLOSE many many times in a loop without performing a COMMIT can exhaust the OBID limit and suffer SQLCODE -497 From a recent SR....... We see in the dump a SELECT statement using insensitive scrolla...
over 5 years ago in Db2 for z/OS 0 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

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

Provide DSKEYLBL option in TEMPLATE utility

Currently there is no DSKEYLBL option in TEMPLATE utility, so if we want to encrypt the output dataset, we can not influence the allocation thru TEMPLATE.
over 5 years ago in Db2 for z/OS 1 Not under consideration

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.