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,
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
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
See this idea on ideas.ibm.com
The db2 list utilties and db2 list utilities show detail command will not display the Reorg utility progress.
1) The command will display the Runstats progress details for the table
2) The command will display the Load progress details for the table
3) The command will display the Backup progress details for the database
4) The command will display the Restore details for the database
So it is good even if it displays the Reorg progress details with different phases it is operating . It should display the clear phases with which it is operating both offline Reorg and Inplace Reorg.
Monitoring reorgs of large tables is done by most customers. When maintenance windows are tight it is imperitive to have a good estimate of progress.
This helps in making decisions to continue or abort a reorg based on time constraints. Updating users with an accurate estimate as to when the table will be avaialble again or at least the current progress will also be very welcome
Needed by Date | Mar 31, 2020 |
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.
I think it would be wonderful if, like on DB2 for Z/Os platform with the command -DIS UTIL(*), will be introduced a single command (db2 list utilities) able to show progress of all utilities. For the moment, reorg isn't included in the utilities managed by db2 list utilities command and adding it will be a great feature.
Well this is something all DB2 DBA's miss I believe. Reorg is one of the most crucial utility and most important as it affects performance of database. so knowing about reorg progress phase wise could let DBA to decide and plan ahead of time, in crucial time bound environments.
Having details about progress is quite crucial to make proper decisions, we have the details on z/OS but of course presentation could be improved as well ;-)
yes this is one of the necessary monitoring indicator on db2 list utilities the progress and status should be shown details @partition level. also it should be shown for all types of tables wherever REORG applicable. the progress should details like type of reorg (offline / online) , stages of the Reorg , table partition , percentage of completion, status@table partition level and operations start & end timelines. currently we are able to provide the ETA for reorg operation. Basically enough details should be displayed to arrive the ETA for reorg operation.
This a great idea and this is very much indeed required for the DBA's to watch the progression and make appropriate decisions.
It's very good idea ..we have to found the status of reorgs in db2top and and db2pd also. but If its show's utilities we can observe how much % of completed work, so it will help to plan for further plans for next activities and also useful to share ETA to app team.
Progress indicator is crucial for all tools. Good idea!
Good idea it is very useful
Any database, no matter whether DB2 or not, should provide mechanisms to track processes and sessions that are performing some activity within the database. Mainly a reorg activity that requires an exclusive lock on the table as soon as it finishes, as well as aborting the process when it's ending after hours running with high system resources costs. This option/feature is optimal and mandatory.
Apart from db2 list utilities will show active backup,restore,import.
I would suggest to use db2top -d <dbname> to check the percentange for reorgs.
This is a good idea and something that we've been able to do when reorging on z/OS for a long time.
Good idea! It would be very useful to monitor the reorg progress through this option.
Certainly will be very helpful ! Great idea
Good idea. It´s very useful to monitor reorg process.
Good idea! It will give the client the security that the reorg process is not hitting an issues and if it does, react immediately.
This is a key requirement to ensure necessary reorgs can be executed and monitored within customer agreed maintenance windows to avoid critical business system impact for the client.
Good Idea! I very helpful for users!
thats helps a lot, i'd like expected a percentage progress detail, i'd help even more