Sybase Adaptive Server Anywhere SNMP Extension Agent manual Oid

Page 46

can be retrieved using the Adaptive Server Anywhere SNMP Extension Agent.

Writable properties are marked with an asterisk (*). The value n is the database number in the asasnmp.ini file.

OID

Type

Name

Property

 

 

 

 

1.3.6.1.4.1.897.2.2.2.1.n

String

dbPropAlias

Alias

1.3.6.1.4.1.897.2.2.2.2.n

String

dbPropAuditingTypes

AuditingTypes

1.3.6.1.4.1.897.2.2.2.3.n

String

dbPropBlankPadding

BlankPadding

1.3.6.1.4.1.897.2.2.2.4.n

String

dbPropBlobArenas

BlobArenas

1.3.6.1.4.1.897.2.2.2.5.n

String

dbPropCapabilities

Capabilities

1.3.6.1.4.1.897.2.2.2.6.n

String

dbPropCaseSensitive

CaseSensitive

1.3.6.1.4.1.897.2.2.2.7.n

String

dbPropCaseSensitivePasswords

CaseSensitivePasswords

1.3.6.1.4.1.897.2.2.2.8.n

String

dbPropCharSet

CharSet

1.3.6.1.4.1.897.2.2.2.9.n

String

dbPropChecksum

Checksum

1.3.6.1.4.1.897.2.2.2.10.n

String

dbPropClusteredIndexes

ClusteredIndexes

1.3.6.1.4.1.897.2.2.2.11.n

String

dbPropCollation

Collation

1.3.6.1.4.1.897.2.2.2.12.n

String

dbPropCompressedBTrees

CompressedBTrees

1.3.6.1.4.1.897.2.2.2.13.n

String

dbPropCompression

Compression

1.3.6.1.4.1.897.2.2.2.14.n

String

dbPropCurrentRedoPos

CurrentRedoPos

1.3.6.1.4.1.897.2.2.2.15.n

String

dbPropDBFileFragments

DBFileFragments

1.3.6.1.4.1.897.2.2.2.16.n

String

dbPropDriveType

DriveType

1.3.6.1.4.1.897.2.2.2.17.n

String

dbPropEncryption

Encryption

1.3.6.1.4.1.897.2.2.2.18.n

String

dbPropFile

File

1.3.6.1.4.1.897.2.2.2.19.n

String

dbPropFileSize

FileSize

1.3.6.1.4.1.897.2.2.2.20.n

String

dbPropFileVersion

FileVersion

1.3.6.1.4.1.897.2.2.2.21.n

String

dbPropFreePageBitMaps

FreePageBitMaps

1.3.6.1.4.1.897.2.2.2.22.n

String

dbPropFreePages

FreePages

1.3.6.1.4.1.897.2.2.2.23.n

String

dbPropGlobalDBId

GlobalDBId

1.3.6.1.4.1.897.2.2.2.24.n

String

dbPropHistogramHashFix

HistogramHashFix

 

 

 

 

34

Image 46
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 Agent Adaptive Server Anywhere MIBAsaMetaData tables 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 RdbmsDbTable Rdbms MIBRdbmsDbInfoTable 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