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 updateson 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,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
ALTER TABLE ALTER COLUMN job should be able to break-in RTS process. Currently, the deadlock may happen between ALTER TABLE ALTER COLUMN job and CORRELATION-ID=014.RTSTST00. We open CASE TS011962039 for the deadlock. From user point of view, the f...
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:
We sometimes get clobbered with processes that generate lots of Db2 accounting records to the point where SMF is overwhelmed in collecting/offloading them. We are able to identify the offending authid with our online monitor, but until we can cont...
Configure a user-defined value for disabling all IFI request and MONITOR trace processing after a number of abends
When a certain number of abends occurs, while processing IFI requests, processing of all IFI request and MONITOR trace is disabled, requiring an action from Db2 operator/system administrator to be resumed. Today this number of abends, that disable...
When running some utilities Db2 can choose to use zSort. In Utilities History (SYSIBM.SYSUTILITIES). there is a column SORTNAME where you can see if DSSORT or DB2SORT has been used. The information if zSort has been used or not is vital as it can ...
A track that is not fully formatted is not eligible for sync i/o (zHyperLink). With the existing code, DB2 sends sync i/o request to all tracks, even ones that are not fully formatted. These i/o get rejected and retried as transport mode. I'd like...
Add another counter to indicate that access was allowed due to install SYSADM authority rather than modifying the existing PKG-AUTH UNSUCC-CACHE counter behavior
If Installation SYSADM is used for EXECUTE authority on a package, the entry is not cached in the CACHEPAC area. However, the PKG-AUTH UNSUCC-CACHE count will be incremented even though the Installation SYSADM ID is not being cached in the CACHEPA...
Enhance command -DISPLAY PROFILE with keyword DETAIL
The -DISPLAY PROFILE command allows to determine if profiling is active or inactive on a specific DB2 member. The command returns output similar to:
DSNT753I +DB2A DSNT1DSP DISPLAY PROFILE REPORT FOLLOWS: STATUS = ON TIMESTAMP = ...
Although DB2 profile history tables are available, they cannot currently provide a complete history of enabled and disabled profiles. Actually, a DB2 profile is registered in the history tables only for START PROFILE commands, and only if the prof...
Do not place IBM confidential, company confidential, or personal information into any field.