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 |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |