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


199 VOTE
Status Not under consideration
Workspace Db2
Created by Guest
Created on Oct 11, 2019

Reduce Time Required for Online(Inplace) Reorg for huge tables

1) Inplace reorg will take time more for the tables with huge data say for example 1 TB

2) To Reduce the time for this we want to avoid full table scan hence we need to look in portions of the data in a table where it is getting fragmented

3) Hence for this if we have special pages on a disk which stores this data that are fragmented on a table where huge transactions are on

4) These special pages should be as part of the table or index object

5) Reorgchk command should be inherent with the capability of displaying the tables that needs Reorg and also portions of it where it has got fragmented

6) If this feature is enabled we can overcome the disadvantage of the extra space needed by the admin_move_table which uses the concept of Load from cursor inside it


Needed by Date Oct 14, 2020
  • Guest
    Reply
    |
    Jul 6, 2022

    This will be very good feature to add as in some environments table can be huge like I had in one of the projects . 1 table was more than 1 tb of size and we never did reorg on that. Just runstats with sampling option. So if we have reorg on fragmented area then it will be good for performance.

  • Guest
    Reply
    |
    Jun 6, 2021

    Very much needed feature. I can relate it to an issue we have at present where we are not getting downtime from customer as the table is huge and is pending for very long time resulting in performance issues. It wil be very beneficial for both, us and the customer.

  • Guest
    Reply
    |
    Jun 4, 2021

    Good idea

  • Guest
    Reply
    |
    Jun 2, 2021

    There are customer who does not use online reorg because it takes a long time for huge table, reducing time will help them to save down time for offline reorg. Good idea!

  • Guest
    Reply
    |
    Jun 2, 2021

    Good idea!! The customer will save lot of down time for the Offline Reorg , if this idea gets implemented in Inplace Reorg and also the execution time improves. It will say save lot of time and cost for the customers!

  • Guest
    Reply
    |
    May 30, 2021

    To me this seems a key improvement feature for DB2 which makes the DB2 experience for our clients more valuable.

  • Guest
    Reply
    |
    May 28, 2021

    Let me add, this idea would be very beneficial to many customers. TIme and resource saving are critical and this feature would appeal to many customers.


  • Guest
    Reply
    |
    May 28, 2021

    I like this idea

  • Guest
    Reply
    |
    May 25, 2021

    It a good alternative to minimaze downtime for customers in a days downtime is becoming more and more unacceptable and high availability is crucial for clients

  • Guest
    Reply
    |
    May 25, 2021

    As this procedure is critical to keep the database performance and healthy , reduce this time will help customers to not have a huge maintenance window to execute the procedure and keep the environment up and running in its best way.

  • Guest
    Reply
    |
    May 25, 2021

    I like the idea , I remember when I was working with Commerce on Cloud, we used a tool called db2collect. Have you heard? So through db2 collect I understood what tables should run reorg. The procedure was very critical, imagine a Transactional table for an e-commerce site. The maintenance window was not large. So this idea matches a lot the requirements related to an e-commerce workload.

  • Guest
    Reply
    |
    May 24, 2021

    This feature could be beneficial, especially if you can reorg within a data partition

  • Guest
    Reply
    |
    May 20, 2021

    It will a good feature to add.

  • Guest
    Reply
    |
    May 20, 2021

    Good Idea it's really useful.

  • Guest
    Reply
    |
    May 20, 2021

    It is a great idea!

  • Guest
    Reply
    |
    May 19, 2021

    It is a great idea, we have faced a lot of times with the extra fs problem from OS point of view, it is required an extra prepare task for example requests of extra disks for the LUN if there is no free capacity in the vg, another benefit, if we are in the special case and we have to perform online reorg during daytime, this solution help to us to reduce the time of the performance related problems during the reorg is running when the customer is using the database.

  • Guest
    Reply
    |
    May 18, 2021

    The idea of only doing a reorg of "sparse" pages or pages with a large % of overflow records as an added option to inplace reorg seems like a good idea and could potentially reap a large time savings compared to a full scan reorg while still providing needed I/O efficiency to SQLs that scan large numbers of pages.

  • Guest
    Reply
    |
    May 18, 2021

    Its a Nice idea.

  • Guest
    Reply
    |
    May 17, 2021

    Awesome Idea.


  • Guest
    Reply
    |
    May 17, 2021

    It is really a Great Idea, many customers, like SCOR, has rised their interest in a such feature.

  • Load older comments