Skip to Main Content
IBM Data and AI Ideas Portal for Customers

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 (

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 ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - 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

Status Not under consideration
Created by Guest
Created on Jun 21, 2023

QM allow filter for SQL that changed data in CAE webfilter (and ISPF)

I would like the Query Monitor web-interface to have a filter or control that allows me to filter on SQL that actually changed data.

For example, I might zoom into an object and see lots of SQL operated on it. But all I want to see are the SQL that actually did change (ins/upd/del/merge).

  1. this is useful for me when I know many applications or userids SELECT on a table but I want to find the actual SQL and application or userid who actually changes the data. This will help me confirm who changes data...
  2. likewise, I might know a userid or application uses SQL on many tables (and maybe different schemas) ... but I want to quickly get an idea of how the application or userid is changing db2 data.

Ideally the filter would know from Db2 how many rows changed... the filter could be based upon that metric

  • a filter on SQL type of INS/UPD/DEL/MERGE is complicated in case the SQL statement is actually SELECT from final table.. because then it looks like SELECT....
  • a filter on SQL type is also complicated because even if I know it is INSERT statement... maybe it inserted zero rows and is not interesting
  • but Query Monitor knowing rows_changed is hard then just scan the SQL and try to figure if it ins/upd/del/merge... that is good enough.

And yes. I do know I can use the QM perf db (somehow with some SQL and thought).

but I would prefer to use the web-interface. because it would be easier and quicker for me AND easier for the ad-hoc or occasional users of Query Monitor (who do not use the QM perf db)

If you want. you could implement the same filter functionality in the ISPF panels for QM but I do not use them much anymore. the webinterface is much better!

Needed By Not sure -- Just thought it was cool
  • Guest
    Dec 12, 2023

    I am disapointed that this idea is not under consideration. I feel that it would be very valuable. Can I discuss it with sosmeone to explain why it is important?

  • Admin
    Chris Pomasl
    Aug 22, 2023

    Thank you for submitting this enhancement request.

    While we view all the enhancement requests we receive as valuable and we would like to implement all of them, in an effort to have maximum transparency we are closing the ones that don’t currently appear on our two-year product roadmap. This is not to say that these enhancements may not still be implemented at some point in the future, as we constantly evaluate our requirements on the basis of customer demand and technical impact and try to deliver maximum value to our customers.

    We appreciate your feedback and would be happy to discuss your enhancement requests further.