We are currently using SiteScope 11.22 installed on RHEL.
I am currently trying to configure the database so that SIteScope is able to retrieve the counters.
In the "Monitor Reference" document, it says that this monitor uses the Snapshot mirroring functionality supported by DB2.
And that I must enable the Snapshot Mirror on the DB2 instance in order to retrieve the counters.
Not sure if this is the right place to ask this question, but does anyone know how to enable the Snapshot mirroring functionality or at least know how to check to see if it is enabled or not?
The current status when I run the tool for the DB2 monitor is as follows:
Step 1:Attempting to Locate Driver Class... Driver Class: com.ibm.db2.jcc.DB2Driver LOCATED SUCCESSFULLY!
Step 2:Attempting to Load Driver Class... Driver Class: LOADED SUCCESSFULLY!
Step 3: Attempting to Connect to Database... ***ERROR***: ***ERROR***: Exception Message: [jcc][t4][3.64.106] Exception java.net.ConnectException: Error opening socket to server xxxxxxxxx/xx.xx.xx.xxx on port 50,000 with message: Connection refused. ERRORCODE=-4499, SQLSTATE=08001
Can you confirm which port the DB is listening on? I'm not too familiar with DB2, but I assume it probably has something similar to Oracle's TNS Listener that binds to a specific port.
If it's definitely port 50000, then it might be a firewall issue between your Sitescope server and the DB2 server. If it's another port though, you may need to change your connection string in the monitor's properties.
What does your current connection string look like more or less, is it something similar to "jdbc:db2://sysmvs1.stl.ibm.com:5021"?
If it does, you should be able to just specify a different port (the ":5021" portion) and try that.