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
Temporal table support for column-organized tables
Currently, a column-organized table cannot be a temporal table because a PERIOD SYSTEM_TIME or PERIOD BUSINESS_TIME declaration is not supported in column-organized tables. This prohibits temporal data management with BLU. We request that column-o...
In current design, when SQL statement accesses a table, the compression and expansion dictionaries of that table will be read into DBHEAP and kept there until database deactivation. For column-based table, the memory consumption may up to 100MB. i...
As of DB2 for LUW Version 10.5 Fixpack 7, DB2 BLU still doesn't support non-unicode database, e.g. GBK. We need DB2 BLU to support database in codepage GBK, so that Chinese characters can be internally stored in double-byte, otherwise a data page ...
Currently BLU CDE tables only have the RECLAIM EXTENTS option of REORG enabled. This does not physically move rows and therefore REORG cannot reclaim extents unless 100% of the rows in an extent have been deleted (via deletes or BLU updates). Also...
Improve performance of DB2 BLU SQL with the GROUP BY subquery
Our customer newly built the DWH system using DB2 BLU.But certain SQL's performance is extremely bad.Problem SQLs are with the GROUP BY subquery and the SET clause subselect.STSC says itâ€˜s a matter of architecture, not a problem and they offered...
BLU should tolerate Tools and Applications which are currently not BLU-aware
We currently employ with the introduction of db2 v10.5 BLU for our DWH. Our plan is to store almost all data in columns store. Just in exceptional cases tables should be stored row oriented. That's why we have set the registry variable DB2_WORKLOA...
Support XA transactions on column-organized tables
We have a main DW database on DB2 for z/OS and a Datamart on DB2 for LUW. Some tables on both z/OS and LUW are populated using Cobol programs which are submitted from the mainframe. We want to convert the Datamart on DB2 LUW to BLU, but the Cobol ...
Do not place IBM confidential, company confidential, or personal information into any field.