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
Db2 does not support anh collation other than IDENTITY or IDENTITY_16BIT per this link - https://www.ibm.com/docs/en/db2/11.5?topic=to-restrictions-limitations-unsupported-database-configurations-column-organized-tables. Customers who are wanting ...
Db2 TOTAL_CPU_TIME monitoring metric on AIX should reflect "wall" CPU time and not use PURR-scaled time reported currently by thread_cputime AIX API
Db2 monitoring interfaces report "CPU time" metric (TOTAL_CPU_TIME), which accounts the time that given activity/request (and all higher level aggregated interfaces) spent actively "on CPU" whilst executing the query. On AIX this information is ob...
Rebuild BLU columnar dictionaries and recompress data in BLU columnar tables
An engineered capability is required to automatically rebuild an optimal BLU columnar compression dictionary and recompress BLU columnar tables. A technique is needed to easily rebuild and recompress columnar tables like we have for adaptive compr...
Estimate the optimal BLU columnar compression rate by sampling data
A technique is needed to determine optimal data compression rates for BLU columnar tables. Such a utility should estimate the optimal compression rate without and with the new string compression enhancements delivered in Db2 11.5 code stream. In e...
Include CTQ reason / details in db2exfmt advanced diagnostics
We need an "Extended Diagnostic Information" in Explain (db2exfmt) that details if and why the column organized tables had been (early) converted to the row format for processing it in the row engine. This is important to detect performance issues...
Currently we can create columnar tables with CLOB/LOB columns in it. What we can't do is reclaim the allocated diskspace of the CLOB/LOB columns (LOB_OBJECT_P_SIZE) in columnar tables
To get an idea about how many diskspace is allocated:
If a user issues FOR BUSINESS_TIME AS OF clause against a bitemporal table, DB2 translates it to a where clause with two range predicates against business_time columns.
In our system following situation occurs quite frequently:
1) At all time...
using none unique index to accelerate update and delete on column-organized
there is a limitation (https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.admin.perf.doc/doc/r0061828.html) Update and delete operations that use an index scan on a column-organized table are not supported by the FETCH opera...
Do not place IBM confidential, company confidential, or personal information into any field.