Sybase Adaptive Server Anywhere SNMP Extension Agent manual

Page 26

names the connection so it can be identified

prevents the database from being shut down when the Adaptive Server Anywhere SNMP Extension Agent disconnects

If you specify any of these values in the connection string in the asasnmp.ini file, the values in the asasnmp.ini file will override the default settings.

UtilDbPwd When setting asa.agent.asaStarted to start a database, the Adaptive Server Anywhere SNMP Extension Agent attempts to connect to the database with the DBF parameter, which tells the database server where to find the database file. However, if the permission required to start the database is DBA (the default for the network server, which can also be set using the -gd dba option for both the personal and network servers), then the server will not allow the connection.

To start a database on such a server, the Adaptive Server Anywhere SNMP Extension Agent must connect as a user with DBA authority to a database already running on the same server. This can be done by connecting to the utility database. If you specify the utility database password (contained in the server’s util_db.ini file) in the asasnmp.ini file, then to start a database, the Adaptive Server Anywhere Extension Agent connects to the utility database on the same server, executes the START DATABASE statement, and then disconnects. This field is optional.

CacheTime When data is retrieved from the database, it can be cached inside the Adaptive Server Anywhere SNMP Extension Agent, so that subsequent retrievals of the same type of data (for example, server properties or database statistics) do not require communication with the database. While caching the data means that you can obtain the data more quickly on subsequent retrievals, the data may be out of date. The CacheTime field can be used to change the cache time, or disable the cache by setting the value to

0.By default, the cache time is 30 seconds. When the CacheTime parameter is set to 0, the data retrieved is always be up-to-date because data is retrieved from the database for every request. This field is optional.

DBSpaceCacheTime The rdbmsDbLimitedResourceTable in the RDBMS MIB contains information about dbspaces. When this information is retrieved from the database, it can also be cached inside the Adaptive Server Anywhere Extension Agent. The default cache time for dbspace information is 600 seconds (10 minutes). This field can be used to change the cache time (or disable the cache by setting the value to 0). This field is optional.

For more information about the rdbmsDbLimitedResourceTable table, see “rdbmsDbLimitedResourceTable” on page 44 .

Trapt Creates a dynamic trap. The value t must be a positive integer

14

Image 26
Contents Adaptive Server Anywhere Snmp Extension Agent User’s Guide Page Contents Page About This Manual SQL Anywhere Studio documentation Page Page Documentation conventions Following icons are used in this documentation Adaptive Server Anywhere sample database Asademo.dbFinding out more and providing feedback Using the Adaptive Server Anywhere Snmp Extension Agent Page Adaptive Server Anywhere Snmp Extension Agent Agent are included in your SQL Anywhere Studio installation Adaptive Server Anywhere Snmp Extension Agent Understanding Snmp Adaptive Server Anywhere MIB Files\Sybase\SQL Anywhere 9\snmp\iAnywhere.mibMIB Rdbms MIB Using the Adaptive Server Anywhere Snmp Extension Agent Installing SnmpTo restart the Snmp service Control Panel Configuring the Adaptive Server Anywhere Snmp Extension Agent To restart the Adaptive Server Anywhere Snmp Extension Agent Page ASAAgent DB1 Software SET Option PUBLIC.opt = ’value’ Using traps To configure the Snmp serviceCreating dynamic traps Trap examples Adaptive Server Anywhere Snmp Extension Agent Reference Page Adaptive Server Anywhere MIB Reference AsaMetaData tables Adaptive Server Anywhere MIBAgent AsaSrvMetaData.asaSrvPropMetaDataTable AsaDbMetaData.asaDbPropMetaDataTable Server statistics AsaDbMetaData.asaDbOptMetaDataTableOID Server properties OID Database statistics OID Database properties OID Adaptive Server Anywhere MIB Reference Database options Adaptive Server Anywhere MIB Reference OID Adaptive Server Anywhere MIB Reference OID Rdbms MIB Reference RdbmsDbInfoTable Rdbms MIBRdbmsDbTable RdbmsDbParamTable Rdbms MIB ReferenceRdbmsDbLimitedResourceTable Write FileRdbmsSrvTable RdbmsSrvInfoTableRdbmsSrvParamTable RdbmsSrvLimitedResourceTableIf this is 0, then it returns prop Page Index Index Cooperativecommittimeout option Index Index Odbcdescribebinaryasvarbinary Pinnedcursorpercentofcache ReadOnly property Truncatetimestampvalues option Installing Snmp Windows XP