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
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).
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...
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!
Do not place IBM confidential, company confidential, or personal information into any field.