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
We use dynamic sql now in nearly all of our applications. It is essential for our shop that the access paths for dynamic sql are as stable as possible. So we will use the new V12 feature "dynamic plan stability". If you look into the manuals and i...
Dynamic Plan Stability - Capture statements from explain
If we want to capture a certain dynamic statement for dynamic plan stability, the statement has to reside in the dynamic statement cache. Than you have to search for the statement id and with the statement íd you're able to capture a certain state...
Db2 AI should discover and prevent deadlocks, for example in situations where programs that previously have been in deadlock situations are expected to deadlock again.
In deadlock situations, one of the involved programs will be rolled back, resources have been unnecessarily used and DBA’s must spend time investigating deadlocks. In transaction intensive systems deadlocks also may cause response time delays or o...
System Assessment-Hide/Unhide metrics features based on user role
Currently, each user is able to Hide/Unhide Metrics under the Db2zAI dashboard for their own view. It would be very helpful if the Db2 AI administrator could choose which metrics would be available to show. For example, there are metrics that we o...
Customers would benefit if ZAI/Spark residual directory and temporary file cleanup process go after the directory specified in TMPDIR environment variable instead of arbitrarily going to $ZAIHOME/tmp directory.
Our installation ran into an issue with the temprary files created by ZAI filling up /tmp directory. All users of ZAI would benefit from this flexibility to specify our own location in TMPDIR environment variable for the cleanup process.
Db2Z INSERT with VALUES should allow multiple rows
Db2 LUW and many other RDMS allow one INSERT with VALUES to insert multiple rows at once. Db2 Z does not allow that syntax. Db2 Z INSERT with VALUES only allows one row at a time So if you have multiple rows you want to insert with the INSERT usin...
Currently the DB2ZAI use privileges are done by DB2 grants and each features (DCC, SA, SQLOPT) usage can be restricted by TSO ID/RACF group privileges Suggest there should be role and the duty segregation within the db2zAI tools. (such as Administ...
Enhancement suggestion for Critical Only email escalation under system assessment
Critical warning email escalation should be more descriptive (suggested to include Metric name) Instead of just number of Critical warning. It should be a list list of critical exception description Administrator should have ability to setup the e...
Currently customer from RBC setup email escalation based on the Critical alerts under the system assessment for example Subject: Db2ZAI System Assessment for Connection DB2ZAIGCCDB01 Completed with Status of SUCCESS. Critical Exceptions Found. Db2...
Do not place IBM confidential, company confidential, or personal information into any field.