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.
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 |
1.3.6.1.4.1.897.2.2.2.90.n | String | dbPropApproximateCPUTime | ApproximateCPUTime |
1.3.6.1.4.1.897.2.2.2.91.n | String | dbPropConnectedTime | ConnectedTime |
1.3.6.1.4.1.897.2.2.2.92.n | String | dbPropReqCountUnscheduled | ReqCountUnscheduled |
1.3.6.1.4.1.897.2.2.2.93.n | String | dbPropReqCountActive | ReqCountActive |
1.3.6.1.4.1.897.2.2.2.94.n | String | dbPropReqCountBlockIO | ReqCountBlockIO |
1.3.6.1.4.1.897.2.2.2.95.n | String | dbPropReqCountBlockLock | ReqCountBlockLock |
1.3.6.1.4.1.897.2.2.2.96.n | String | dbPropReqCountBlockContention | ReqCountBlockContention |
1.3.6.1.4.1.897.2.2.2.97.n | String | dbPropReqTimeUnscheduled | ReqTimeUnscheduled |
1.3.6.1.4.1.897.2.2.2.98.n | String | dbPropReqTimeActive | ReqTimeActive |
1.3.6.1.4.1.897.2.2.2.99.n | String | dbPropReqTimeBlockIO | ReqTimeBlockIO |
1.3.6.1.4.1.897.2.2.2.100.n | String | dbPropReqTimeBlockLock | ReqTimeBlockLock |
1.3.6.1.4.1.897.2.2.2.101.n | String | dbPropReqTimeBlockContention | ReqTimeBlockContention |
1.3.6.1.4.1.897.2.2.2.102.n | String | dbPropInternal | Internal |
1.3.6.1.4.1.897.2.2.2.103.n | String | dbPropLastCommitRedoPos | LastCommitRedoPos |
1.3.6.1.4.1.897.2.2.2.104.n | String | dbPropLastWrittenRedoPos | LastWrittenRedoPos |
1.3.6.1.4.1.897.2.2.2.105.n | String | dbPropLastSyncedRedoPos | LastSyncedRedoPos |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |