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
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:
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...
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...
Hello! We had problems with CPU in Production environment several months ago with a simple query with IN predicate. The CPU reached 100%! Particularly, this query has many literals within IN predicate and the IN predicate can't be matching. After ...
Enhance DSNT375I deadlock message to include DRP global variable use
Following the introduction of the CURRENT LOCK TIMEOUT (CLT) special register and DEADLOCK_RESOLUTION_PRIORITY (DRP) global variable with EPIC 8876, the DSNT376I timeout message has been enhanced to show the timeout values used for both requester ...
Indicate whether the fallback SPE for Db2 13 migration is installed
As a user planning to migrate to Db2 13 I already activated V12R1M510 on my Db2 12 subsystem. However, I also want to make sure that I have the fallback SPE PH37108 https://www.ibm.com/support/pages/apar/PH37108 installed. Could this information b...
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 = ...
Provide ROWID addition for PBG to PBR conversion in V13 ALTER statement.
In V13m we get to convert PBG tablespace to PBR by a simple ALTER statement. However, we will be forced to look for a partitioning key by working with application team. In the mean time, in V12 we have a feature called "Hidden ROWID support for pa...
Enable use of DSN_PROFILE* tables global variables for local workload
At the following link, we see global variables can be used with profile tables. https://www.ibm.com/docs/en/db2-for-zos/12?topic=connections-setting-built-in-global-variables-profile-tables However, there is a sentence that mentions the following:...
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 ...
Do not place IBM confidential, company confidential, or personal information into any field.