IBM Data and AI Ideas Portal for Customers


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:

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

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Additional Information

To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

IBM Employees:

The correct URL for entering your ideas is: https://hybridcloudunit-internal.ideas.aha.io


Status Planned for future release
Created by Guest
Created on Jul 24, 2020

dmctop should provide an option to monitor the load and table move

The dmctop could include a tool to see the progress of:

  • loads

  • admin move table

  • roll forward

  • reorg

Needed by Date Dec 31, 2020
  • Guest
    Aug 30, 2021

    So far in dmctop we have delivered the following:

    • Monitoring Table movement (under "Other Table Movement" tab)

    • Monitoring Reorg (under "Other - REORG" tab)

    We'll try to address "Roll Forward" in dmctop 1.0.4

  • Guest
    Oct 5, 2020

    Hi Andres,

    Thanks a lot for the info - I reviewed this with the engineering team. We understand the request and will consider it for one of the upcoming releases of dmctop.

    Best reagards,

    Maryia

  • Guest
    Aug 2, 2020

    Hi Maryia,

    I propose something to monitor the progress of tools in Db2. For example, to monitor a LOAD, one run LOAD QUERY TABLE to see which phase is running, or how many rows have been inserted. However, to see the progress once uses the watch command from linux, and that could be easily integrated into another tool.

    A similar thing happens with tables being moved, to see which phase (Init, Copy, Replay, Swap,Cleanup) they currently are one run several time a query like this:
    SELECT VARCHAR(TABSCHEMA,12) SCHEMA, VARCHAR(TABNAME,48) TABLE, KEY, VARCHAR(SUBSTR(VALUE, 1, 50), 50) VALUE FROM SYSTOOLS.ADMIN_MOVE_TABLE WHERE (KEY = 'STATUS' AND VALUE <> 'COMPLETE') OR (KEY = 'LOCK') ORDER BY SCHEMA, TABLE

    Or

    SELECT SEM_NAME, VALUE, varchar(TABSCHEMA, 12) SCHEMA, varchar(TABNAME, 48) TABLE from SYSTOOLS.OTM_SEMAPHORE_TABLE"

    (Taken from my blog - https://angocadb2.blogspot.com/2014/06/monitor-adminmovetable.html)

    The progress of a roll forward the command is ROLLFORWARD QUERY STATUS, and it is executed consecutively to see the progress.

    Similar thing for the reorg.

    If the dmctop integrates these monitors, it is easily to see what is happening in a database.

    I will add another one, when logs are retrieved one has to check the db2diag to see which file is looking for, and check the VENDOR tool to see if the "tape" is mounted. Instead, by viewing a the queue of requested logs, one can see how files will be retrieved, and see the progress.

  • Guest
    Jul 31, 2020

    Hi Andres,

    Can you please provide more details on the use cases for these requirements?

    Thank you!

    Maryia