Skip to Main Content
IBM Data and AI Ideas Portal for Customers


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 updates on 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,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


ADD A NEW IDEA

BLU Acceleration

Showing 33 of 15581

Option to avoid sampling for the distribution statistics without creating an index

Because of a misleading distribution statistic the Db2 optimizer can in some situations choose a very bad execution plan.The reason for this is, that Db2 internally samples data to faster create his distribution statistics. To create an index to a...
about 1 month ago in Db2 / BLU Acceleration 0 Submitted

Allow EBCDIC collation for column organize tables

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 ...
over 1 year ago in Db2 / BLU Acceleration 0 Future consideration

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...
over 1 year ago in Db2 / BLU Acceleration 0 Future consideration

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...
over 1 year ago in Db2 / BLU Acceleration 0 Future consideration

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...
over 1 year ago in Db2 / BLU Acceleration 1 Functionality already exists

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...
about 2 years ago in Db2 / BLU Acceleration 3 Not under consideration

Add REORG LONGLOBDATA for columnar tables

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: db2 "...
about 2 years ago in Db2 / BLU Acceleration 0 Future consideration

Do not truncate trailing blanks in columnar Group By

BLU columnar engine does not carry trailing blanks in varchar columns during GROUP BY processing. It does not bring non-normalized variant through the grouping operation
over 4 years ago in Db2 / BLU Acceleration 0 Not under consideration

Avoid SQL0955C Sort memory cannot be allocated to process the statement. Reason code = 3

It would avoid Db2 errors and interruptions. Every customer using Db2 BLU who ran (or will run) into SQL0955 RC3 errors would benefit.
over 4 years ago in Db2 / BLU Acceleration 0 Not under consideration

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...
almost 5 years ago in Db2 / BLU Acceleration 0 Not under consideration