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.

Provide ability to monitor health of DSM

Our current setup:

We setup DSM to monitor our production DB2's. We have over 100 databases configured for the DSM.

All our DB2 have HA failover setup with Tivoli. This is our business requirement.

We also have DSM setup with HA failover. Currently DSM can only failover when the host or the network has failed. (Not when DSM has internal problems.)

Scenario: The following scenario happened to us more than 1 time.

Our team received a ticket from our customer, complaining a DB2 database performance/inaccessible and upon checking DSM is HUNG.

After we received the ticket, we notice DSM is HUNG. But we need to first fix the Db2’s issue – without DSM.

We opened tickets to IBM regarding the HUNG issue. We got feedback that we should remove some work folder as workaround and restart DSM.

The workaround will only help with current situation, but it will not help us in the future; because DSM is not able to give us the Db2 Alert notification when it is HUNG. We are stung by this bad situation.

This happened to us two times over the weekend, and no pager notification when some Db2 is having problems. We are only finding it out on Monday when ticket is raised.

We are moving away from BMC Patrol and replacing it with DSM. We expect DSM to work as a warning system and give us Alert notifications. Our enterprise depends on the warning system to work.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Aug 16 2019
  • Needs more information
Why is it useful?
Who would benefit from this IDEA? DBA team and all our customers using the Db2 managed by DSM.
How should it work?

DSM should be able to self-diagnose.

Provide API, scripts or log trace to warn major error is about to happen.

Our team can intervene before DSM is having major problem.

And Tivoli should be able to use the information DSM provided to failover to standby DSM before major problem occurs.

For example Db2 error are collected by db2haicu  where Tivoli will proactively act on it whether to failover to other node or not.

Idea Priority
Priority Justification Currently, we face issues with DSM, and we need to wait for some humans to detect the problem before it can be rectified. We have Tivoli to avoid human monitoring as availability requirement. We need DSM to work well with Tivoli.
Customer Name UPS
  • Attach files
  • Admin
    Maryia Rakina commented
    31 Jul 15:30

    Hello, we can provide an API in the new Db2 Data Management Console which would allow to monitor the health of DMC. This API would reflect the console status and you will be able to call it in your enterprise IT monitoring system.

    Please let me know if this solution would work for you.

    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