For more information regarding the security incident at F5, the actions we are taking to address it, and our ongoing efforts to protect our customers, click here.

Forum Discussion

TNY_122436's avatar
TNY_122436
Icon for Nimbostratus rankNimbostratus
May 15, 2014

EAV monitor file for DB2

Does anyone know how I can create an EAV file to monitor DB2 databases base on this argument:   Select count(*) from SYSIBMADM.SNAPHADR where HADR_ROLE = 'PRIMARY'   If it returns 1, it's the p...
Patrik_Jonsson's avatar
Patrik_Jonsson
Icon for MVP rankMVP
May 16, 2014

Hi!

Lacking experience with DB2, but don't you need some kind of authentication before sending queries to the DB? Otherwise you could try a normal TCP monitor with a send and receive string?

Send string:

Select count(*) from SYSIBMADM.SNAPHADR where HADR_ROLE = 'PRIMARY'\r\n

Receive string:

1

If this doesn't work I bet Kevin will come soon and save the day. 🙂

/Patrik