IBM Data and AI Ideas Portal for Customers
Hide about this portal


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

Search results: Db2 for z/OS

Showing 127 of 1654

Adding new values to CHECK Constraints should not put Table in CHECK PENDING

There are many instances today when existing CHECK Constraints have to be modified to add additional values. Currently, making any modifications to CHECK Constraints to add or remove values requires that the Constraint be dropped and re-created. T...
almost 2 years ago in Db2 for z/OS 1 Not under consideration

UNION should automatically be rewritten to "UNION ALL" when it is logically equivalent

In the following query, the developer coded "UNION". Because it is part of a "WHERE EXISTS" subselect, replacing the UNION with "UNION ALL" will perform much better and deliver the same results: SELECT * FROM PDBR111.VCLI095_SELECT V01WHERE V01.AR...
about 6 years ago in Db2 for z/OS 1 Not under consideration

New message reporting tha...

RTS Temporal tables are defined as UTS/PBG/MAXPART 1. Please provide a message if e.g. 80% of available space is reached and a second message if e.g. 90% are reached. The message should be written once if the threshold is reached. It might be help...
over 8 years ago in Db2 for z/OS 0 Future consideration

V12-CERT-2017 Refresh VIEW / CREATE OR REPLACE VIEW / VIEW VERSIONING.

While tables can be altered online; views need to be dropped and recreated, resulting in business impact or planned downtimes (our environment is making extensive use of the ANSI SPARC three level architecture, with many views and views on views)....
over 8 years ago in Db2 for z/OS 1 Not under consideration
5 MERGED

DB2 to provide a way to override MAXPARTITIONS and LOCKSIZE defaults

QMF Product Development is opening this work item in response to DeveloperWorks Request id 59512 (PMR: 46297,442,000) (RTC ID 41210). Please review that work item to see the customers pain points. We have had additional discussions with the custom...
almost 11 years ago in Db2 for z/OS 1 Future consideration

Backout also if system errors occours using 'load resume yes backout yes'

Load resume yes backout yes should perform the backout process also when some system error occurs (ie.: space constraints on utility datasets), primarily in case of DISCARDS 1 specification.With this choice the customer wish to prefer the preserva...
over 6 years ago in Db2 for z/OS 1 Not under consideration

Populate correct proggname on DSN_QUERYINFO_TABLE when accelerating queries using IBM DSM

We need to correct identify the progname column on the DSN_QUERYINFO_TABLE. While doing the acceleration task on IBM DSM, instead of populating the column with the value of the package, the accelerator populates de column with the value 'SYSLH200'...
over 2 years ago in Db2 for z/OS 1 Not under consideration

Regular Expressions (regex) scalar function

The XMLQUERY function allows the user to use the 'fn:matches' XQuery function, which is great. Please see example UDF which does this... ~~~~~~~~~~--#SET TERMINATOR ! CREATE FUNCTION "UDF_STRING_REGEX_MATCH" ( SEARCHSTRING VARCHAR (50) ) RETURNS S...
over 9 years ago in Db2 for z/OS 0 Not under consideration

Control Connections Via Profiles Using Client Properties

We would like more granular control over connections. Currently, the only way to do this is via a profile using an IP address. Unfortunately, the IP address is the static IP of a client. That client may house multiple webservices. If only 1 of tho...
over 7 years ago in Db2 for z/OS 1 Delivered

Zero Downtime during Online CRM Application Migration

Problem Statement : Transaction 1 (T1) is intended to delete and subsequently insert few records to a table TB1. The business logic is like, this T1 should be open and not to commit as well until the end of delete followed by insert operation. ...
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.