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
Application status change time is not available in any mon_get_* table functions
In snap admin views, users could see STATUS_CHANGE_TIME column for the application which was helpful in determining when exactly the application changed it status when investigating performance issues. This would help users to estimate or know how...
Warning error code for Db2 tablespace architecture limit
If Db2 tablespace reaches architecture limit of 90%, then there should be a Warning Message write into db2diag.log, so that before it is reaching 100% of Db2 tablespace architecture limit, this can be fixed.
Now we are monitoring through a S...
reduce I/O activity to /etc/services upon each connect
Using filemon, we see 191 accesses to /etc/services for each Connect statement. It seems this file should only be accessed once or twice. This has been verified by IBM personnel with ticket TS001677150.
event monitor tables (activity/actitivtystmt/activitymetrics) should support range partitioning
event monitor tables do not support range partitioning. In addition, you can not create expression based indexes on them. This makes them more difficult to manage and query. create event monitor wlm_activity_mon for activitieswrite to table activi...
Display row stats ( rows_read, rows_written, tq_rows_sent, tq_rows_recv) for each sub-section in MON_GET_AGENT
Currently, there is no equivalent of getting row level information ( TQ_ROWS_SENT/RECV, Rows Read, Rows written ) for each agent running within a sub-section which was readily available in snap_get_subsection or db2 get snapshot for application ag...
In the case of a hang, we only have the material for root-cause analysis if we were able to collect db2fodc information before the system became fully unusable. A small moving window of such information written out to disk on a regular basis would...
Enhancement regarding the .ftok file and the DB2 instance.
I will suggest the following:1. Let Db2 log a simple message 'The .ftok file is missing, last seen ' when the instance started.2. Also, suggest to execute ~/sqllib/bin/db2ftok or go ahead and execute it
MON_GET_CONNECTION is lacking CODEPAGE of connection
A 3rd party application connects to Db2 and we get SQL0302. The 3rd party vendor figures out, it is a double conversion to UTF-8One of the most valuable debugging informations was the codepage of the connection to the database, which is available ...
Do not place IBM confidential, company confidential, or personal information into any field.