IBM Data and AI Ideas Portal for Clients

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

If you have not registered on this portal please register at http://ibm.biz/IBM-Data-and-AI-Portal-Register . To complete registration you will need to open the email you will receive from Aha to confirm your identity.

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 offering manager 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

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

  • Guest
  • Jul 24 2020
  • Planned for future release
Idea Priority Medium
  • Attach files
  • Admin
    Maryia Rakina commented
    5 Oct, 2020 04:12pm

    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 commented
    2 Aug, 2020 05:10am

    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.

  • Admin
    Maryia Rakina commented
    31 Jul, 2020 07:21pm

    Hi Andres,

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

    Thank you!

    Maryia


IBM's success depends on gathering feedback from customers like yourself. Aha Ideas Portal is the third party tool through which IBM Offering Managers gather feedback from customers such as yourself.
IBM is a global organization with business processes, management structures, technical systems and service provider networks that cross borders. As such, the information collected through Aha Ideas Portal (Customer Name, Customer Email Address) will be stored by them in the United States, and handled only as per IBM's instructions and policies. Your data (Name and Email Address) will NOT be shared with other IBM customers.
In order to safeguard your information in Aha, do not leave your workstation unattended while using this application, log off after using it, and print only if necessary. If you need to make a hardcopy, remember to pick up the print-out immediately, keep it under lock, and destroy it immediately when no longer needed.
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions