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
As mentioned in Case TS004024647 there are some situations where inserts in lob structures do not provide the expected performance. Instead they cause massive CPU consumption in the Coupling Facility for the spacemap search. The problem is excessi...
Allow statement level hints on SQL in stored procedure packages
It is a huge pain to hint specific statements contained within stored procedure packages. Currently you will get this message if trying to bind query for a statement level hint on a procedure package: DSNT281I -DBP1 BIND QUERY FOR QUERYNO = 59988 ...
KEY LABEL will likely be implemented at the application area, which means that there could be hundreds/thousands of objects impacted. The current solution presented is:
User objects - Set a key label using SQL interfaces (V12R1M502)
• ALTER / CRE...
Hello Db2 for Z/OS Development. Apar PM89016 was created several years ago to implement the lock avoidance for singleton SELECTs with ISO(CS) and CD(YES) when R-scan is used, or the index that is chosen has matching predicates on all columns of th...
Standardize and allow LISTDEF PARTEVEL syntax for MODIFY STATISTICS utility
Currently MODIFY STATISTICS utility does not support LISTDEF with PARTLEVEL and throws an error like in example: LISTDEF DB2RK INCLUDE TABLESPACE DS0HUZX.S0HU37P PARTLEVEL(20) TEMPLATE COPYIC DSN(&SS..ICR.&DB..&TS..P&PA..&UQ.) ...
Removal of an unnecesary system crash due to must-complete or latch holding agent - RC 00F3040A
Today, there is an intentional system crash designed and exploited with an abend code 00F3040A when an agent abending in system is in so called must-complete state or is holding a latch. We have been running a case TS006198341 where our system cra...
Looking at DB2 log when a SQLCODE -803 duplicate key condition occurs in an INSERT often leads to a rollback of the change already made to the tablespace and/or in the non unique indexes defined against the affected table. Would it be possible to ...
Modify the DSNJU003 utility to allow it to define anything stored in the Db2 BSDS
When creating and new Db2 member, we must bring it all the way up before we can create the bufferpools, size them, and set the thresholds. We would like the ability to defined them prior to starting the Db2 member/subsystem. When creating an alias...
Do not place IBM confidential, company confidential, or personal information into any field.