IBM Data Platform Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data Platform 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 58 of 686

Set object status to prohibit data access

Before we drop a Db2 table we need to make sure that noone use the object in any way. We solve this now by stopping the tablespace and keeping it stopped for about six months. This means that noone can access the data and noone can run a utility a...
about 2 years ago in Db2 for z/OS 0 Future 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...
almost 5 years ago in Db2 for z/OS 2 Delivered

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...
about 6 years ago in Db2 for z/OS 2 Not under consideration

-MODIFY GBPOOL command - Allow Db2 sysadmins to manage GBP CF structures without permitting access to MVS SETXCF

The Challenge Currently, the Data-Sharing Planning and Administration Guide states that SETXCF commands are necessary for the administration of Db2 Group Bufferpools, particularly functions such as: Re-sizing group bufferpools Rebuilding group...
over 6 years ago in Db2 for z/OS 0 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...
over 1 year ago in Db2 for z/OS 1 Not under consideration

DB2 should optimize queries adequately when are missing or out of date

In V12 it was intended to extend the NPGTHRSH to empty tables and to tables with missing stats. The idea was to pick up the appropriate index which means: if a sort can be avoided choose this one, otherwise pick up the index, which has the most ma...
about 8 years ago in Db2 for z/OS 1 Not under consideration

Instrument workfile high-watermarks in ACCTG

Instrument IFCID 0003 and IFCID 0148 counter(s) to show the maximum amount of Workfile used by a thread (4K blocks total, or separate by tables/indexes, or separate by 4K/32K Workfiles -- implementation choice.) It is difficult to manage Workfile ...
over 13 years ago in Db2 for z/OS 1 Not under consideration

Lock hashing algorithms of DB2 and XES are incompatible. Leads to excessive False Contention and high IRLM CPU for GLM xfer

There is an anomaly between DB2 and XES hashing algorithms which means that a 4-byte DB2 (unique) lock hash value passed to XES may not be hashed to a unique value by XES unless the LTE size is set excessively high (1G). I understand that DB2 hash...
over 9 years ago in Db2 for z/OS 1 Not under consideration

QW148TTK unreliable when thread is in-doubt

IFCID 0148 Monitor Detail Record 2 field QW148TTK is incorrect when the thread being reported is in-doubt and as evidenced by cross-checking with DB2 -DISPLAY THREAD output. Requesting either a correct QW148TTK for in-doubt threads or a means to d...
about 8 years ago in Db2 for z/OS 1 Not under consideration

Would like means of collecting Maxdbat information by AUTHID

We are in the process of providing max thread limits via the Db2 Profile tables AUTHID entries for our applications. We would like to use a AUTHID=* entry to provide a default thread limit and use AUTHID=xxx values for applications which may need ...
about 6 years ago in Db2 for z/OS 1 Delivered

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.