Sybase Adaptive Server Anywhere SNMP Extension Agent manual RdbmsDbParamTable, Rdbms MIB Reference

Page 55

 

 

 

 

 

Chapter 3. RDBMS MIB Reference

 

 

 

 

 

 

 

 

OID

 

Type

 

Name

 

Value returned

 

 

 

 

 

 

 

 

 

 

 

1.3.6.1.2.1.39.1.2.1.3.db

 

Integer

 

rdbmsDbInfoSizeUnits

 

Calculated based on dbInfoSizeAllo-

 

 

 

 

 

 

cated and dbInfoSizeUsed.

 

 

 

 

 

 

♦ 1=bytes

 

 

 

 

 

 

♦ 2=KB

 

 

 

 

 

 

♦ 3=MB

 

 

 

 

 

 

♦ 4=GB

 

 

 

 

 

 

♦ 5=TB

 

 

 

 

 

 

(Each unit is 1024 times the previ-

 

 

 

 

 

 

ous.)

1.3.6.1.2.1.39.1.2.1.4.db

 

Integer

 

rdbmsDbInfoSizeAllo-

 

db_property(‘pagesize’) * db_-

 

 

 

 

cated

 

property(‘filesize’)

1.3.6.1.2.1.39.1.2.1.5.db

 

Integer

 

rdbmsDbInfoSizeUsed

 

db_property(‘pagesize’) * (db_-

 

 

 

 

 

 

property(‘filesize’) - db_-

 

 

 

 

 

 

property(‘freepages’) )

1.3.6.1.2.1.39.1.2.1.6.db

 

String

 

rdbmsDbInfoLast-

 

NULL1

 

 

 

 

Backup

 

 

 

 

 

 

 

 

 

 

 

1This OID is not currently supported by the Adaptive Server Anywhere SNMP Extension Agent.

rdbmsDbParamTable

This table lists the configuration parameters for the databases on the system.

The value db is the database number in the asasnmp.ini file, while n is the index of the option in the asa.2.3 subtree.

OID

Type

Name

Value returned

 

 

 

 

1.3.6.1.2.1.39.1.3.1.1.db

String

rdbmsDbParamName

Option name

1.3.6.1.2.1.39.1.3.1.2.db

Integer

rdbmsDbParamSubIndex

n

1.3.6.1.2.1.39.1.3.1.3.db

OID

rdbmsDbParamID

OID in Adaptive Server

 

 

 

Anywhere MIB correspond-

 

 

 

ing to this option

1.3.6.1.2.1.39.1.3.1.4.db

String

rdbmsDbParamCurrValue

Option value

1.3.6.1.2.1.39.1.3.1.5.db

String

rdbmsDbParamComment

NULL1

43

Image 55
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 Asademo.db Adaptive Server Anywhere sample databaseFinding 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 Files\Sybase\SQL Anywhere 9\snmp\iAnywhere.mib Adaptive Server Anywhere MIBMIB Rdbms MIB Installing Snmp Using the Adaptive Server Anywhere Snmp Extension AgentTo 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’ To configure the Snmp service Using trapsCreating dynamic traps Trap examples Adaptive Server Anywhere Snmp Extension Agent Reference Page Adaptive Server Anywhere MIB Reference Agent Adaptive Server Anywhere MIBAsaMetaData tables AsaSrvMetaData.asaSrvPropMetaDataTable AsaDbMetaData.asaDbPropMetaDataTable AsaDbMetaData.asaDbOptMetaDataTable Server statisticsOID 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 RdbmsDbTable Rdbms MIBRdbmsDbInfoTable Rdbms MIB Reference RdbmsDbParamTableWrite File RdbmsDbLimitedResourceTableRdbmsSrvInfoTable RdbmsSrvTableRdbmsSrvLimitedResourceTable RdbmsSrvParamTableIf this is 0, then it returns prop Page Index Index Cooperativecommittimeout option Index Index Odbcdescribebinaryasvarbinary Pinnedcursorpercentofcache ReadOnly property Truncatetimestampvalues option Installing Snmp Windows XP