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

Search results: Db2 for z/OS

Showing 123 of 1578

Explain STMTCACHE By DSG instead of 1 member

EXPLAIN STMTCACHE ALL will only enter data into the DSN_STATEMENT_CACHE table for the member of the datasharing group on the LPAR which it's running. To get all of the dynamic SQL stats, the EXPLAIN has to run multiple times. Have the ability to e...
over 11 years ago in Db2 for z/OS 1 Not under consideration

Remove some of the restrictions related to SQLCODE -20555

There is currently a restriction on the use of archive-enabled tables and temporal tables in one statement: The execution of this statement leads to SQLCODE -20555: SELECT * FROM DB2.LZTB0586 WHERE VNR IN ( SELECT VNR FROM DB2.LZTB0520) SQLERROR O...
12 months ago in Db2 for z/OS 1 Not under consideration

Altering table with a CLONE disruption

Currently, when altering a table with a CLONE on it, the clone needs to be dropped and to add it back the following procedure must be followed:1) REORG the tablespace 2) run MODIFY RECOVERY TABLESPACE DSNUM ALL DELETE AGE (*) 3) run an image copy ...
about 7 years ago in Db2 for z/OS 0 Not under consideration

Allow for LISTDEF Processing and Template when specifying FROMCOPYDDN on an UNLOAD

Details: 1) Site has multiple tablespaces that use a consistent naming scheme for image copies.2) Manual does not mention use of "template-name" in the FROMCOPYDDN line of the "source-spec" section of the "UNLOAD" page.3) Receive following error w...
over 9 years ago in Db2 for z/OS 1 Not under consideration

Alter (global) VARIABLE command

It is not possible to ALTER a global variable, it is necessary to do DROP + re-CREATE it. And previously we must DROP all the objects that depends on it: PROCEDURE, FUNCTION, TRIGGER, VIEWS ..., and the packages are marked as invalid. After havin...
over 6 years ago in Db2 for z/OS 0 Not under consideration

LISTAGG - Reduce workfile usage of function LISTAGG

The function LISTAGG uses a lot of workfile space. This can lead to abends, especially if there are many groups. This is the specific case where the problem occurred in our company: SELECT A.GES_SL, A.VNR, A.POS_LNR , SUBSTR(LISTAGG(TA_ID,'/') WIT...
over 4 years ago in Db2 for z/OS 2 Delivered

Allow Multiple Dataset Inputs to DSN1PRNT

Allow more than 1 input dataset for use with the DSN1PRNT stand-alone utility. This would function as a concatenated list under the SYSUT1 DD.
almost 7 years ago in Db2 for z/OS 1 Not under consideration

Enhancement of compression algorithm used by DB2

We have noticed that the compression ratio (PAGESAVE) for first partition of a Partitioned TS is 0% after running an IBM Reorg Utility. The reason why PAGESAVE/compression ratio for that first Partition is 0% is caused because many initial rows in...
over 9 years ago in Db2 for z/OS 1 Not under consideration

Db2 zOS: Provide support for period-clause FOR PORTION OF BUSINESS_TIME for update operation within MERGE statement

Idea is to extend functionality of MERGE statement in Db2 z/OS by providing support for the period clause FOR PORTION OF BUSINESS_TIME for an update operation (and delete operation) within the MERGE statement. The statement would look like this: ...
over 2 years ago in Db2 for z/OS 1 Not under consideration

Create an API for IFI reads (306) so Log-Reading Software does NOT need to be APF-Authorized

Like a lot of shops, we replicate a lot of our Enterprise data from our programmatic Db2 for z/OS environment to other Db2s and other off-platform DBMSes for MI and analytics, and for high availability. IIDR now provides the ability to do this via...
almost 6 years ago in Db2 for z/OS 2 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.