Individual applications such as IBM Connections, IBM Traveler, IBM Sametime, etc.. are using mainly DB2 Databases in the back-end. Therefore it is pretty important to monitor the connectivity against these Databases o a regular basis.
The following example demonstrates how you can achieve a simple DB2 connectivity check with GreenLight.
For this configuration we are going to use our Linux Shell Script Sensor. This Sensor provides the maximum flexibility.
- Before you can perform this DB2 connectivity check you need to request the following files from panagenda support. At the moment these files are not part of the appliance. In addition to that the customer has to upload the right DB2 jdbc driver to the virtual appliance box.
db2jcc4.jar --> jdbc driver for your DB2 version
- open/modify the db2connect.sh file
enter the password for the db2 database next to "password= "
DB2Result=`java -Dgl.jdbc.url="jdbc:db2://"$1":"$3"/"$4":user="$5";password=mypassword;" -c
- upload these files to your GreenLight appliance
create a folder db2 underneath of /opt/panagenda/share
* upload the db2jcc4.jar AND ramkin-connectors-1.0.jar into that folder
* upload DB2Connect.sh to /opt/panagenda/scripts/gl_sensors
- create a Linux Shell Script Action (GreenLight Frontend)
in this example we want to check the database connectivity against the homepage db of IBM Connections
on the Targets Tab please add your DB2 server
Make sure that you use the FQDN of the DB2 server
Whenever the measurement was successful you get the value 1
if it was not successful you get a 0 back
So you could use this information then for an action
As you already know from other example, you could even depict this information on the Health Grid Level
This is just a simple example how you can perform a connectivity test against a DB2 Database our of GreenLight