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
IFCID 105 contains information needed to map DBID/OBID values to object names. This information is produced on the STATS interval and contains mapping for EVERY object currently open to DB2. On large systems, thousands of IFCID 105 records may be ...
Reduce message flooding on system console using Db2 System Profile Monitoring for security profiles when detecting non-secure connections and WARNING_DIAGLEVEL3
This Aha idea is being opened on behalf of Commerzbank (Ute Kleyensteuber). Security profiles are used with System Profile Monitoring filter LOCATION=*, ATTR1=WARNING_ DIAGLEVEL3, ATTR3=1 (TLS required) to discover all incoming non-secure connecti...
about 2 months ago
in Db2 for z/OS
Not under consideration
Identify when all members of a Data Sharing Group are up and operational
After a crash or hard down, Db2 will perform its recovery processing including GRECP and LPL processing. There are external systems (e.g. CICS, MQ, etc.) that are dependent on all members in the data-sharing group to be fully up and operational an...
Profiles ; time between DSNT771/2I messages made variable
Currently when a Profile is triggered (warning or exception) DSNT771/2I are issued every 5 minutes as long as exceptions/warnings are met in the timeframe. When an exception is triggered (maximum connections from IP for instance) the issue will oc...
Supply RACF Exit IRREVX01 to fail commands against Db2 classes that don't have the proper syntax.
As encountered in Case TS013914362, invalid profiles would not be created that could leave unused records in the RACF data base and also confuse Db2 when RACF notifies Db2 to refresh the cached profiles. All Db2 for z/OS users utilizing RACF could...
Adding new values to CHECK Constraints should not put Table in CHECK PENDING
There are many instances today when existing CHECK Constraints have to be modified to add additional values. Currently, making any modifications to CHECK Constraints to add or remove values requires that the Constraint be dropped and re-created. T...
Allow customers to specify a name for SYSINSTL ID instead of forcing "SYSINSTL"
Currently, IBM allows customers to install Db2 for z/OS under Install SYSOPR authority. This requires that the customer specify "SYSINSTL" as the installer ID in several key steps of the DB2 Install CLIST. "SYSINSTL" is then used for definition of...
Have new authority for REFRESH of MQT that does not require high privilege levels
We historically have an application batch userid that has DBADM authority. We are limiting all access to this ID to the minimally required authority it requires such as load, imagecopy and runstats at the DB level. When we started converting our t...
Allow Secondary AUTHID and Patterns in AUTHID column of the RLF tables
In order to make administration of the RLF tables easier, we would like to be able to enter a Secondary Authid or an ID Pattern. Secondary AUTHIDs would allow us to use definitions in the Security Manager to accommodate resource limits for many ID...
We use a lot of XML tables today on our environment. We need to alter the limitkey defined for partitions in DB2. According to the manual, the DB2 correct behavior is to return sqlcode -109 when alter table partition (XML TABLE) is executed.
Do not place IBM confidential, company confidential, or personal information into any field.