[Problem] - Datasource - WebSphere

[Thiago Pereira]

Hello guys,

I need some help with Zorka.. 

When I run this command:

$ zabbix_get -s 10.150.8.217 -p 10052 -k 'zorka.jmx["pmi", "WebSphere:type=JDBCProvider,name=Microsoft SQL Server JDBC Driver,*", "stats"]'

I got ALL of my Datasources informations.. and its okay.. but, how can I filter this?

Example:

Stats name=jdbc/XXXXXXXXXXXXX, type=connectionPoolModule

name=AllocateCount, ID=3, description=The total number of connections that are allocated., unit=N/A, type=CountStatistic, count=0

name=PoolSize, ID=5, description=The size of the connection pool., unit=N/A, type=BoundedRangeStatistic, lowWaterMark=0, highWaterMark=0, current=0, integral=0.0, lowerBound=0, upperBound=10

name=FreePoolSize, ID=6, description=The number of free connections in the pool., unit=N/A, type=BoundedRangeStatistic, lowWaterMark=0, highWaterMark=0, current=0, integral=0.0, lowerBound=0, upperBound=0


I wanna just the PoolSize, Connection Wait Time.. things that I found in the template - Template_Zorka_WebSphere_JdbcConnections.

--------------------


And for information, my template Template_Zorka_WebSphere_JdbcConnections its okay, but doesnt collect the datasources that I want.. and I dont know why too.

Regards,

[Eve]

Hello,

The command:

zabbix_get -s 10.150.8.217 -p 10052  -k 'zorka.jmx["pmi", "WebSphere:type=JDBCProvider,name=Microsoft SQL Server JDBC Driver,*", "stats", "getConnectionPools()", "0", "PoolSize", "current"]'

will display the PoolSize value of the first datasource (index 0).

zabbix_get -s 10.150.8.217 -p 10052  -k 'zorka.jmx["pmi", "WebSphere:type=JDBCProvider,name=Microsoft SQL Server JDBC Driver,*", "stats", "getConnectionPools()", "1", "PoolSize", "current"]'

displays the PoolSize value for the second one (index 1) etc.

So to collect The PoolSize metric you have to add an item prototype in Template_Zorka_WebSphere_JdbcConnections :

Example for the first datadasource :

<item_prototype>

                            <name>JDBC Connection Pool Size on {#NAME} : first_datasource</name>

                            <type>7</type>

                            <snmp_community/>

                            <multiplier>0</multiplier>

                            <snmp_oid/>

                            <key>zorka.jmx[&quot;pmi&quot;, &quot;WebSphere:type=JDBCProvider,name={#NAME},*&quot;, &quot;stats&quot;, &quot;getConnectionPools()&quot;, &quot;0&quot;, &quot;PoolSize&quot;, &quot;current&quot;]</key>

                            <delay>60</delay>

                            <history>10</history>

                            <trends>365</trends>

                            <status>0</status>

                            <value_type>0</value_type>

                            <allowed_hosts/>

                            <units></units>

                            <delta>0</delta>

                            <snmpv3_contextname/>

                            <snmpv3_securityname/>

                            <snmpv3_securitylevel>0</snmpv3_securitylevel>

                            <snmpv3_authprotocol>0</snmpv3_authprotocol>

                            <snmpv3_authpassphrase/>

                            <snmpv3_privprotocol>0</snmpv3_privprotocol>

                            <snmpv3_privpassphrase/>

                            <formula>1</formula>

                            <delay_flex/>

                            <params/>

                            <ipmi_sensor/>

                            <data_type>0</data_type>

                            <authtype>0</authtype>

                            <username/>

                            <password/>

                            <publickey/>

                            <privatekey/>

                            <port/>

                            <description/>

                            <inventory_link>0</inventory_link>

                            <applications>

                                <application>

                                    <name>WebSphere JDBC Connection Pools</name>

                                </application>

                            </applications>

                            <valuemap/>

                            <logtimefmt/>

                        </item_prototype>

Regards.