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
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...
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...
Column-organized tables are currently not supported for table partitioning (e.g. PARTITION BY RANGE)..At the same time, table partitioning is used by many data warehouse customers to speed up ETL activities - e.g.:(a) load new data into a separate...
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...
Db2 Warehouse Need support for columnar tables when case insensitivity is configured
System: IBM Integrated Analytics SystemActor: Customer requiring capability My customer is migrating from Teradata to Db2 Warehouse (IIAS appliance). The appliance has been configured for Row-organized tables because case insensitivity is required...
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:
Today SORTHEAP and SHEAPTHRES_SHR need to be set to a fixed value to run BLU.The STMM tuned adjustment don't need to be highly sophisticated. E.g. keeping 60/40 ratio for bufferpool/sheapthres_shr and adjust sortheap as ratio taking the amount of ...
Do not place IBM confidential, company confidential, or personal information into any field.