We have some DB2 servers in a cluster running with HADR. The secondary server shall only count 100 PVU, no matter how many cores there is in the server.
Does anybody have experience how to handle this in BigFix Inventory?
Hi Tinna,
At the moment such functionality is not present. You can raise an RFE: http://www-01.ibm.com/support/docview.wss?uid=swg21626077 - specifying - add functionality to add a certain PVU value on top of measured PVU for HADR consumption. If you phrase it similarly it is possible to be implemented.
At the moment you can mimic the missing behavior in following way. You can add Management/Metric Custom Fields, then New button and and add a Field with name comment and type String. In all HADR warm standby this comment would be “Add 100 PVU on top of measurements”.
Another possibility is to create a 1 core vmware guest that will mock 100PVU db2 requirement. DB2 swidtag may be copied there to allow discovery.
In each case you exclude HADR warm standby from being presented on reports. https://www.ibm.com/support/knowledgecenter/en/SS8JFY_9.2.0/com.ibm.lmt.doc/Inventory/softinv/t_sc_excluding_software_instances.html
Regards,
Andrzej
1 Like
Thanks, Andrzej, I wil open a RFE, and perhaps try your workaround.
Do you know if it is possible to detect something on the server with DB2 to recognize the usage of HADR? In this case I needed to ask our DB2 team to confirm if it was installed on the server. And unfortunately it was the customer who asked me to check it.
Hi Tinna,
You can issue following command as db2 user (typically it is db2inst1).
db2 get snapshot for database on [DATABASE_NAME]
on mine db that is not part of HADR there is no section HADR status as presented here: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.5.0/com.ibm.db2.luw.admin.ha.doc/doc/t0051361.html
Regards,
Andrzej
Hi Andrzej,
I am sorry not to be specific: I want BigFix to do this automatically and report it in BigFix Inventory; in our company that kind of stuff is normally done of our DB2 team (they know all about it - I don’t).
Is that a possibility?
Best regards,
Tinna
Hi Tinna,
Nothing I am aware that would be available out of the box. Possible approach can be custom fixlet and/or analyses.
Regards,
Andrzej
Thanx - our tool team will have a look at it. I wish you a Happy Christmas!
Merry Christmas and a Happy New Year.