Introduction

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.

Configuration

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.

 
 ramkin-connectors
 db2connect.sh   
 db2jcc4.jar                --> jdbc driver for your DB2 version

•   open/modify the db2connect.sh file

        enter the password for the db2 database next to "password= "

            e.g.
                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
            ==> /opt/panagenda/share/db2

        * 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
  

Filename:      DB2Connect

        Parameters:    
                Portnumber
                db name
                username

            e.g.
                50000
                homepage
                lcuser       

        on the Targets Tab  please add your DB2 server
        Make sure that you use the FQDN of the DB2 server
            e.g

Result:

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
        e,g.,

copy/paste:        ${result.details['greenlight.shell.script.db2.check.successful']!=1}

As you already know from other example, you could even depict this information on the Health Grid Level

Conclusion

This is just a simple example how you can perform a connectivity test against a DB2 Database our of GreenLight