Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere MIB Reference » The SQL Anywhere MIB

SQL Anywhere MIB database statistics Next Page

SQL Anywhere MIB database properties


The following table lists the OIDs and names of the database properties that can be retrieved using the SQL Anywhere SNMP Extension Agent.

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

For more information about the database properties, see Database-level properties.

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 dbPropInternal Internal
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 dbPropInternal Internal
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 dbPropInternal Internal
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 dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.13.n String dbPropInternal Internal
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 dbPropInterna Internal
1.3.6.1.4.1.897.2.2.2.21.n String dbPropInternal Internal
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 dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.25.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.26.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.27.n String dbPropIQStore IQStore
1.3.6.1.4.1.897.2.2.2.28.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.29.n String dbPropLanguage Language
1.3.6.1.4.1.897.2.2.2.30.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.31.n String dbPropLogFileFragments LogFileFragments
1.3.6.1.4.1.897.2.2.2.32.n String dbPropLogMirrorName LogMirrorName
1.3.6.1.4.1.897.2.2.2.33.n String dbPropLogName LogName
1.3.6.1.4.1.897.2.2.2.34.n String dbPropLTMGeneration LTMGeneration
1.3.6.1.4.1.897.2.2.2.35.n String dbPropLTMTrunc LTMTrunc
1.3.6.1.4.1.897.2.2.2.36.n String dbPropMultiByteCharSet MultiByteCharSet
1.3.6.1.4.1.897.2.2.2.37.n String dbPropName Name
1.3.6.1.4.1.897.2.2.2.38.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.39.n String dbPropPageSize PageSize
1.3.6.1.4.1.897.2.2.2.40.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.41.n String dbPropProcedureProfiling* ProcedureProfiling
1.3.6.1.4.1.897.2.2.2.42.n String dbPropReadOnly ReadOnly
1.3.6.1.4.1.897.2.2.2.43.n String dbPropRemoteTrunc RemoteTrunc
1.3.6.1.4.1.897.2.2.2.44.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.45.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.46.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.47.n String dbPropSyncTrunc SyncTrunc
1.3.6.1.4.1.897.2.2.2.48.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.49.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.50.n String dbPropTempFileName TempFileName
1.3.6.1.4.1.897.2.2.2.51.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.52.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.53.nStringdbPropInternalInternal
1.3.6.1.4.1.897.2.2.2.54.nStringdbPropNextScheduleTimeNextScheduleTime
1.3.6.1.4.1.897.2.2.2.55.nStringdbPropIdentitySignatureIdentitySignature
1.3.6.1.4.1.897.2.2.2.56.nStringdbPropInternalInternal
1.3.6.1.4.1.897.2.2.2.57.nStringdbPropSnapshotIsolationStateSnapshotIsolationState
1.3.6.1.4.1.897.2.2.2.58.nStringdbPropConnsDisabledConnsDisabled
1.3.6.1.4.1.897.2.2.2.59.nStringdbPropPartnerStatePartnerState
1.3.6.1.4.1.897.2.2.2.60.n StringdbPropArbiterStateArbiterState
1.3.6.1.4.1.897.2.2.2.61.nStringdbPropMirrorStateMirrorState
1.3.6.1.4.1.897.2.2.2.62.nStringdbPropAlternateServerNameAlternateServerName
1.3.6.1.4.1.897.2.2.2.63.nStringdbPropEncryptionScopeEncryptionScope
1.3.6.1.4.1.897.2.2.2.64.nStringdbPropNcharCharSetNcharCharSet
1.3.6.1.4.1.897.2.2.2.65.nStringdbPropNcharCollationNcharCollation
1.3.6.1.4.1.897.2.2.2.66.nStringdbPropAccentSensitiveAccentSensitive
1.3.6.1.4.1.897.2.2.2.67.nStringdbPropSendingTracingToSendingTracingTo
1.3.6.1.4.1.897.2.2.2.68.nStringdbPropReceivingTracingFromReceivingTracingFrom
1.3.6.1.4.1.897.2.2.2.69.nStringdbPropIOParallelismIOParallelism
1.3.6.1.4.1.897.2.2.2.70.nStringdbPropJavaVM JavaVM
1.3.6.1.4.1.897.2.2.2.71.nStringdbPropDatabaseCleaner DatabaseCleaner
1.3.6.1.4.1.897.2.2.2.72.nStringdbPropHasCollationTailoring HasCollationTailoring
1.3.6.1.4.1.897.2.2.2.73.nStringdbPropCatalogCollationCatalogCollation