Send Notification from SAP MII for SQL DB

[stuti_omer]

Hi All,

Is it possible to send notification through SAP MII if SQL DB is down without using SAP PCO?

Thanks in advance!!

[ankit12]

Hi Stuti,

Could you please give more info like where you want to send the notification and or by notification, you mean to update anyone that SQL database is down?

Regards,
Ankit Gupta

[eli_dealmeida]

Hi,

You can check in the illuminator service, if the database is down.

http://<server>:<port>/XMII/Illuminator?Service=SystemInfo&Mode=Status&Content-Type=text/xml

Like this:

<Row>
<Server_Name>DUMMY_DB</Server_Name>
<Connector_Type>SQL</Connector_Type>
<Connections_Used>0</Connections_Used>
<Available_Connections>5</Available_Connections> <Max_Connections_Used>10</Max_Connections_Used>
<Max_Wait_Time>0</Max_Wait_Time>
</Row>

I did a follow test to check the variable Available_Connections:

1st - In Data Servers, I disabled the the IDBC connector type and Available_Connections change to "0", after that, I restarted and Available_Connections became "5" again

2st- In Data Server Connection, I changed the string connection, to raise error, and the Available_Connections changed to "0", as well.

Might this can be a way.

BR

Eli