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
Allow native support of user-defined collation such as EBCDIC in CREATE DATABASE command
This will allow easy creation of databases on LUW supporting EBCDIC collations which will in-turn allow easy migration for Db2 on z/OS to Db2 LUW. Currently, this is only supported via the user-defined option of sqlecrea() api and a C program has ...
When new table is created, some migration is performed and similar it is pretty important info when object was last accessed. Db2 has LASTUSED, e.g SYSCAT.TABLES.LASTUSED column, but the data in this column can be according to documentation up to ...
db2start of a running instance should reload/restart configuration without interruption of current sessions
Sometimes dbm configuration changes are not active immediately and require a full instance restart. E.g. adding an SSL port and config updates of the db catalog changes in SYS*_GROUP ... It would be great, if a db2start command is issued while the...
Save and (restore) access plan for dynamic and Statis SQL
Sometime after maintenance, or index/stats change, certain SQL can pick a bad access path. It would be nice to be able to save access path and force db2 to pick old access path. We just had very painful process after V11 migration. When access pat...
Add table function to "pretty print" explained statement
Db2 allows to install the EXPLAIN TABLES using a procedure (https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.explain.doc/doc/t0059594.html)
There are different ways to generate an access plan, i.e., to explain a...
Poor performance on DB2 V11.1 due to changes in build process
Some customers are noticing performance degradations moving from v105 ESE to v111 ESE on the same hardware.These degradations are most pronounced in OLTP workloads, with an emphasis on INSERT and UPDATE operations. Db2 Support has confirmed that t...
ADM7007E - Logging The Process holding the database port when this error is logged in the diag could help us better for RCA
Part of critical Protection mode Restart, TSAMP has issued ipclean where the instance restart was not clean due to the below message in the logs. MESSAGE : ADM7007E The SVCENAME DBM configuration parameter, "50000", is configured with a port or a ...
We cannot view the subordinate logs from parallel container while analyzing the logs in AdminConsole Web-Log-Viewer. (See Case TS000078576) There is no possibility to open this subordinated Log, as the Filename is not clicable. We need it fixed, a...
Do not place IBM confidential, company confidential, or personal information into any field.