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.
|Who would benefit from this IDEA?||DBA team and all our customers using the Db2 managed by DSM.|
|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.|
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.
|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 "firstname.lastname@example.org" 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|