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
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.
Enhancement of View syscat.bufferpools to show alos stmm bufferpool sizes
When a bufferpool size is set to AUTOMATIC, -2 is being retrieved fromsyscat.bufferpools. But customer wants the current number of pages ofautomatic settings also displayed in syscat.bufferpools. Also a new column insyscat.bufferpools should indic...
Adjusting column status in syscat.tables by synchronizing with column AVAILABLE SYSIBMADM.ADMINTABINFO
Customer mentions that tables which are delivering aSQL1477N should have an inoperative status. But theyhave status 'N' (for normal) insyscat.tables. The only way to retrieve the status of anSQL1477N is to select the column AVAILABLE inSYSIBMADM.A...
Ref TS000003442, PMR 68950,664,706Ref PMR 67845,664,706In case a deadlock occurs on MDC tables on BID index, diagnostic from Locking Event Monitor is not sufficient to understand deadlock. We need to understand data in conflict pages to check acce...
In DPF env Robust single result set for the ALL SQL statistics categories
Memory metrics got introduced in V9.7 and got strong in 10.5. But in DPF there is none of metrics that can report similar to â€œget snapshot for application agentid globalâ€ which returns a single value for all necessary statistics reported in sn...
Do not place IBM confidential, company confidential, or personal information into any field.