#4264 [HHQ-4166] DB2 plugin errors when monitoring DB2 9.1

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-4166


When monitoring DB2 9.1 errors are returned when collecting DB2 JDBC Database Manager 9.x metrics. These use the SNAP_GET_DBM function.

{code}


...


2010-07-13 15:36:16,387 DEBUG [Thread-0] [DBManagerMeasurement] [executeQuery] query='SELECT * FROM TABLE(SNAP_GET_DBM(-2))'


...


com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: END-OF-STATEMENT;LE(SNAP_GET_DBM(-2));<correlation_name>


at com.ibm.db2.jcc.c.rh.c(rh.java:1701)


at com.ibm.db2.jcc.c.rh.d(rh.java:1678)


at com.ibm.db2.jcc.c.rh.a(rh.java:1235)


at com.ibm.db2.jcc.a.db.g(db.java:139)


at com.ibm.db2.jcc.a.db.a(db.java:39)


at com.ibm.db2.jcc.a.t.a(t.java:34)


at com.ibm.db2.jcc.a.sb.f(sb.java:142)


at com.ibm.db2.jcc.c.rh.m(rh.java:1206)


at com.ibm.db2.jcc.c.sh.db(sh.java:1947)


at com.ibm.db2.jcc.c.sh.d(sh.java:2387)


at com.ibm.db2.jcc.c.sh.T(sh.java:426)


at com.ibm.db2.jcc.c.sh.executeQuery(sh.java:409)


at org.hyperic.hq.plugin.db2jdbc.CachedJDBCMeasurement.executeQuery(CachedJDBCMeasurement.java:122)


at org.hyperic.hq.plugin.db2jdbc.CachedJDBCMeasurement.getValue(CachedJDBCMeasurement.java:43)


at org.hyperic.hq.product.MeasurementPluginManager.getPluginValue(MeasurementPluginManager.java:176)


at org.hyperic.hq.product.MeasurementPluginManager.getValue(MeasurementPluginManager.java:274)


at org.hyperic.hq.product.MeasurementPluginManager.getValue(MeasurementPluginManager.java:135)


at org.hyperic.hq.product.MeasurementPluginManager.getValue(MeasurementPluginManager.java:127)


at org.hyperic.hq.measurement.agent.server.MeasurementCommandsService.getMeasurements(MeasurementCommandsService.java:201)


at org.hyperic.hq.measurement.agent.server.MeasurementCommandsServer.dispatchCommand(MeasurementCommandsServer.java:168)


at org.hyperic.hq.agent.server.CommandDispatcher.processRequest(CommandDispatcher.java:112)


at org.hyperic.hq.agent.server.CommandListener.listenLoop(CommandListener.java:191)


at org.hyperic.hq.agent.server.AgentDaemon.start(AgentDaemon.java:844)


at org.hyperic.hq.agent.server.AgentDaemon$RunnableAgent.run(AgentDaemon.java:926)


at java.lang.Thread.run(Unknown Source)


{code}