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 tha...
Add support for static SQL queries text storage in CQM_SUMM_TEXT
There is currently no support for the static SQL in CQM when one wants to store the SQLTEXT for such queries. Only dynamic SQL is supported. It is currently possible to see in the ISPF interface the static sql, but it is gone after a rollup of the...
Provide option to offload VSAM files in DSNTIAUL format
We run query monitor across 4 plexes and 9 LPARS and many DB2 systems. We do 'not' load the QM performance data to each system, rather we offload the data from each LPAR, then consolidate the load of the data to one of our non-prod performance war...
Query Monitor should display information about index traversal usage
Application DBA's and developers use performance metrics, acess paths, object definitions and Real Time Statistics (RTS) when analyzing application perfomance. FTB count should be displayed on objects (indexes) in Query Monitor, but also on SQL st...
Report all SQL calls in native stored procedures in Query Monitor
See case# TS003954339. Sometimes Query monitor doesn't capture the SQL statement but gives the message: CQM145I - SQL TEXT NOT AVAILABLE, instead. IBM case states that these are internal SQL calls in native stored procedures. In my case they were ...
search for strings within the SQL Statements in the SQL Text Column
For us, the web UI is the main interface to interact with Db2 Query Monitor.
A functionality should be implemented that makes it possible to search for character strings in the list of displayed sql queries (e.g. search for the table name). The ...
HOST Variable and SQL Text features cannot be used as the granularity is ON/OFF where what we need is granularity by application on a DB2 subsystem.
Sensitive data is not always masked so teams cannot view the data, this includes DBAs. Since bot...
Increase Numeric Precision of Values used in Anomaly Detection
As explained in Support Case TS004193711, in many cases when exceptions and/or Alerts are triggered for CPU anomaly exceptions, the CPU Factor is displayed as "N/A". Also the "RollAv CPU", "ECPU RollLm" and ACPU Rollm" columns are all always zero....
Do not place IBM confidential, company confidential, or personal information into any field.