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 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 dbPropInternal 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.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.54.n String dbPropNextScheduleTime NextScheduleTime
1.3.6.1.4.1.897.2.2.2.55.n String dbPropIdentitySignature IdentitySignature
1.3.6.1.4.1.897.2.2.2.56.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.57.n String dbPropSnapshotIsolationState SnapshotIsolationState
1.3.6.1.4.1.897.2.2.2.58.n String dbPropConnsDisabled ConnsDisabled
1.3.6.1.4.1.897.2.2.2.59.n String dbPropPartnerState PartnerState
1.3.6.1.4.1.897.2.2.2.60.n String dbPropArbiterState ArbiterState
1.3.6.1.4.1.897.2.2.2.61.n String dbPropMirrorState MirrorState
1.3.6.1.4.1.897.2.2.2.62.n String dbPropAlternateServerName AlternateServerName
1.3.6.1.4.1.897.2.2.2.63.n String dbPropEncryptionScope EncryptionScope
1.3.6.1.4.1.897.2.2.2.64.n String dbPropNcharCharSet NcharCharSet
1.3.6.1.4.1.897.2.2.2.65.n String dbPropNcharCollation NcharCollation
1.3.6.1.4.1.897.2.2.2.66.n String dbPropAccentSensitive AccentSensitive
1.3.6.1.4.1.897.2.2.2.67.n String dbPropSendingTracingTo SendingTracingTo
1.3.6.1.4.1.897.2.2.2.68.n String dbPropReceivingTracingFrom ReceivingTracingFrom
1.3.6.1.4.1.897.2.2.2.69.n String dbPropIOParallelism IOParallelism
1.3.6.1.4.1.897.2.2.2.70.n String dbPropJavaVM JavaVM
1.3.6.1.4.1.897.2.2.2.71.n String dbPropDatabaseCleaner DatabaseCleaner
1.3.6.1.4.1.897.2.2.2.72.n String dbPropHasCollationTailoring HasCollationTailoring
1.3.6.1.4.1.897.2.2.2.73.n String dbPropCatalogCollation CatalogCollation
1.3.6.1.4.1.897.2.2.2.74.n String dbPropHasEndianSwapFix HasEndianSwapFix
1.3.6.1.4.1.897.2.2.2.75.n String dbPropAlternateMirrorServerName AlternateMirrorServerName
1.3.6.1.4.1.897.2.2.2.76.n String dbPropOptionWatchList OptionWatchList
1.3.6.1.4.1.897.2.2.2.77.n String dbPropOptionWatchAction OptionWatchAction
1.3.6.1.4.1.897.2.2.2.78.n String dbPropMirrorMode MirrorMode
1.3.6.1.4.1.897.2.2.2.79.n String dbPropHasNCHARLegacyCollationFix HasNCHARLegacyCollationFix
1.3.6.1.4.1.897.2.2.2.80.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.81.n String dbPropAuthenticated Authenticated
1.3.6.1.4.1.897.2.2.2.82.n String dbPropSynchronizationSchemaChangeActive SynchronizationSchemaChangeActive
1.3.6.1.4.1.897.2.2.2.83.n String dbPropLastCheckpointTime LastCheckpointTime
1.3.6.1.4.1.897.2.2.2.84.n String dbPropMirrorServerState MirrorServerState
1.3.6.1.4.1.897.2.2.2.85.n String dbPropDriveBus DriveBus
1.3.6.1.4.1.897.2.2.2.86.n String dbPropDriveModel DriveModel
1.3.6.1.4.1.897.2.2.2.87.n String dbPropInternal Internal
1.3.6.1.4.1.897.2.2.2.88.n String dbPropMirrorRole MirrorRole
1.3.6.1.4.1.897.2.2.2.89.n String dbPropWriteChecksum WriteChecksum
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0