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
Usually section actuals after being prepared with explain_from_activity and db2exfmt has a section called “Runtime statistics for objects Used in Access Plan”. This section has valuable information for the problem analysis. If a Statement uses Cre...
Kindly help build Db2 native and/or Sql based exporter. This exporter should be developed in such a way that It should be non-intrusive & no performance impact to the databases which are being monitored, Similar to nosql db metrics exporter av...
As Db2 system / instance administrator, I need to retrieve instance data without connecting to a regular (tenant) database
Several of the in-memory monitoring table functions and views return data which is instance-related. Still, a database connection is needed just for the purpose of having authentication / authorization / connection handle. This requires administra...
As Db2 system / instance administrator, I need to retrieve the list of active databases using SQL
Coming from snapshot monitoring, the goal is to use in-memory monitoring and SQL in the least intrusive way to monitor the health of a Db2 instance and its databases. Right now, this is done by connecting to a non-tenant dummy database and running...
SNAP_GET_APPL_V95 got introduced with Db2 9.5 but is deprecated in actual versions/releases. MON_GET_CONNECTION is declared as the replacement for this ‘old’ procedure, but the scope of the replacement procedure is different! Thus MON_GET_CONNECTI...
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...
Protect against DOS when user has password expired
Hi team, recently we had open a support case TS004670019 on https://www.ibm.com/mysupport/s/case/5003p00002TrWNRAA3/1222wd-db2-taking-too-long-to-login We had a situation with an automatic process that got it's password expired and begun failing t...
DB2 listener not activated after DB process killed by OS and restarted automatically by TSA in HADR environment
We had DB2 HADR primary/standby configuration. Due to one application job,DB2 consumes all memory and OS killed db2sysc process. db2 restarted automatically by TSA but listener wasn't activated . There was no evidence in logs which process was usi...
Event monitor creation, write to table option should allow to specify a tabkespace into which ALL the new tables should be created in
Create event monitor write to table option will create new tables.All the new tables are defined in a tablespace which db2 chooses. I want an option to specify a tablesapce name, in which ALL the new tables should get created in.
Reorg Utility Progress data is missing in db2 list utilities and db2 list utilities show detail command
The db2 list utilties and db2 list utilities show detail command will not display the Reorg utility progress. 1) The command will display the Runstats progress details for the table 2) The command will display the Load progress details for the tab...
Do not place IBM confidential, company confidential, or personal information into any field.