Hi all,

we're running SQL anywhere and I would like to write a custom
monitoring service that communicates with the database server via SNMP
and have had zero luck getting any responses from the OID's for either
the generic RDBMS or the specific SQLanywhere stuff. I've tried on
both server2003, xp and vista. I am gathering other SNMP data so I
know that the server is operating properly. Does anybody have any
suggestions on how to get this operational?

Sybase was installed first, then I installed the snmp service and
based on Sybase docs this should work fine. However, i have also
tried restarting the db server to see if that made any difference, but
no joy.

Thanks for any insight.

Cheers!
ken

Can you query OID 1.3.6.1.4.1.897.2.3.1 successfully? It should return
the version number of the SNMP agent - if that works, then it's
installed and running properly. If that works, can you post the contents
of your sasnmp.ini file?

Let me know and we can go from there.

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs


visiperl (AT) gmail (DOT) com wrote:

See that is where I think the problem is. My understanding of the
sasnmp.ini file is you have to specify a database to monitor. I don't
want to monitor a "database"... I want to monitor the entire server
and be able to find out how many databases are running on the server
and get a list of names etc. I can use a program called ServersCheck
MIB Browser and get regular system values properly, but nothing in the
generic rdbms, sqlanywhere or sybase nodes.

Am I completely misunderstand the sasnmp.ini file?

Thanks so much!

Cheers!
ken

You have to monitor a database, not a server, because SQL Anywhere
doesn't have the ability to connect to a server without connecting to a
database. You can't easily do what you want with the SNMP agent.

There are SQL constructs available for you do get the list of databases
running on the server (see the docs on the next_database function), but
to do this, you still have to connect to a database on the server.

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs


visiperl (AT) gmail (DOT) com wrote:

Please note that if you want to monitor server properties and statistics
only, you can point sasnmp.ini at the utility database. You won't be
able to get much information on the databases running on the server, but
for monitoring the server itself, this could be useful.

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs


Graeme Perrow [Sybase iAnywhere] wrote: