IBM Data and AI Ideas Portal for Customers
Hide about this portal


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 Subscribe
Status Under review
Workspace Db2
Created by Guest
Created on Nov 29, 2016

RELATED IDEAS

Excessive DBHEAP by BLU compression dictionaries

See this idea on ideas.ibm.com

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. it's worse in DPF + BLU environment due to every related database partition need keep such info in its DBHEAP. So for a system with many tables, the customer either allocates huge memory for DBHEAP, or hits error and restart DB2 database.
Hope to change the DBHEAP management method, let the DBHEAP memory could be reused.
  • Admin
    Siji Daniel
    Reply
    |     Mar 21, 2025

    We are reassessing feasibility of the Idea. We are discussing this internally. We will provide an update within 90 days.
    Thank you.

  • Guest
    Reply
    |     Feb 20, 2025

    How do we vote for this?  Other than hitting the like button?

  • Guest
    Reply
    |     Feb 17, 2025

    TS018186678: Customer has over 13,000 tables in IDAA (DPF+BLU) database.  So, including synopsis tables, the number of tables is about 26,000.  We observed that DBHEAP continues to increase as more and more tables are being accessed over time, eventually leading to application failure with "DIA8302C No memory available in the database heap", and they had to recycle the database to bring the DBHEAP usage back lower.  

    Here is an idea suggested from the case ticket.  

    Can we have some regvar or add a statement such as: "FLUSH HEAP CACHE FOR <SchemaName>" to manually flush the heap cache for tables? Or better, add some LRU algorithm to clean up the unused table from heap cache automatically?

  • Guest
    Reply
    |     Mar 19, 2024

    There will be problems if the original design is used on a large scale.

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.