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.
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.
|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.|
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