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
Applications or plans should be able to reference a particular page in a PAW book
When adding an asset to an application or plan, there is no ability to select an individual tab in a book. The default behavior is to select the first tab in the book. Often books have multiple tabs in them, and these may be used in different appl...
Use RACF resource to control access to DVM JDBC Gateway Server databases
Currently USERID and PASSWORD info needs to be updated and maintained in the DVM AVZDRATH job in order for DVM users to access different DRDA databases. The AVZDRATH job needs to be updated monthly whenever a user’s password changes or when a user...
Rotate an archive-enabled PBR tablespace without causing a deadlock
When we try to rotate partitions of an archive-enabled PBR tablespace, Db2 requires us to disable archiving before the rotate then re-enable archiving after the rotate. However, when we re-enable archiving we cause a deadlock with CICS and the onl...
DB2 profiles - register START PROFILE and STOP PROFILE commands
Summary: Log all -START PROFILE and -STOP PROFILE commands in a DB2 table, ready to be used for queries onto the history tables. Details: When DB2 profiles are being enabled (SYSIBM.DSN_PROFILE_TABLE.PROFILE_ENABLED='Y'), the next -START PROFILE c...
SQLTrace offers the DBA the tooling required to monitor a user session. However its difficult to monitor heavily used systems. For example one needs to have a buffer large enough to store 90 seconds of SQL queries (small lookup SQL's consume the b...
In PMR 89848.077.724 you see an example that the DB2 optimizer is not able to push out local predicates that are specified in the correlated subquery to the parent query block. The predicates AND "AVADMIN"."TLORM_DBFE"."MANDANT" = ? AND "AVADMIN"....
Enhance automatic SORTHEAP management by fixing the defined base value as the minimum for STMM
As we had an issue with STMM reducing the SORTHEAP too much during lower load on the database, we would like to see the defined base value for the sortheap treated as the minimum value, that STMM would not reduce the sortheap below that value if t...
Do not place IBM confidential, company confidential, or personal information into any field.