IBM Data and AI

Welcome to the IBM Data and AI Ideas Portal for Clients!

We welcome and appreciate your feedback on IBM Data and AI Products to help make them even better than they are today!
Before you submit an idea, please perform a search first as a similar idea may have already been reported in the portal. If a related idea is not yet listed, please create a new idea and include with it a description which includes expected behavior as well as why having this feature would improve the service and how it would address your use case.
IBM Employees:
Clients:
  • Our team welcomes any feedback and suggestions you have for improving our offerings / products! This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.

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

Additional Information:
  • The shorter URL for this site is: https://ibm.biz/IBM-Data-and-AI-Ideas

  • 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

  • Please do not use the Ideas Portal for reporting bugs - we ask that you report bugs or issues with the product by contacting IBM support.

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

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jul 24 2020
  • Needs more information
Why is it useful?
Who would benefit from this IDEA?
How should it work?

Idea Priority Medium
Priority Justification
Customer Name
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    02 Aug 05:10

    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 19:21

    Hi Andres,

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

    Thank you!

    Maryia

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