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
Index reorg information in a SNAP* view or a MON_GET* table function
Please make index reorganization progress (not table reorganization) accessible via a MON_GET* table function. Right now, it is only available via db2pd -d dbname -reorg -indexes and that is nearly impossible to parse via script.
Add support to update "Last Login Time" of Linux OS for Db2 LUW
Db2 LUW on Linux OS only use auth and password module of PAM to validate and change password, but it didn't record the "Last Login Time" for the users on the Linux OS, so we don't know if the users are actually using the Db2 for data query. And th...
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...
Monitoring table function to display details on the application and its temp space usage
Often times, users would like to get a single view report on the application handles/ids, the corresponding process id and application usage of sys or user temp spaces and db2 does not have one monitoring table function to accomplish this. Users n...
Please add Firstlsn to the MON_GET_CONNECTION table function
The firstLSN is only available using db2pd. It is the ninth column reported from: db2pd -transactions It does not appear to be anywhere else. I would like to be able to query it using the MON_GET* table functions.
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...
Expand db2pd -reorgs index to cover index rebuilds
Currently, there is no way to monitor index rebuild progress using db2pd. It will be useful for customers to be able to monitor index rebuild progress as they do for index reorgs (db2pd -reorgs index).
Do not place IBM confidential, company confidential, or personal information into any field.