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!