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
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...
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...
Lower WLM capture Threashhold for elapstime to be under 10s
We use WLM to capture long running SQLs. The lowest threashhold for elapstime is set to 10s. This is too high for OLTP, we cannot afford to capture every SQL. But it would be nice to lower the 10s to 1 or 2s.
With introduction of APARs PH08708 and PH08431, messages DSNT376I are suppressed. These are the sentences: PH08708 -> When Timeout Exit is called, IRLM may flag that no DSNT376I message should be issued. In this situation IFCID 196 records will...
QM provides exceptions to collect certain details when we hit those thresholds. In my customer circle none of the customers are monitoring the system without multiple profiles. They simply define multiple lines to active profile with different fil...
Do not place IBM confidential, company confidential, or personal information into any field.