The following table lists OIDs and names of the database server 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 server properties, see Database properties.
OID | Type | Name | Property |
---|---|---|---|
1.3.6.1.4.1.897.2.1.2.1..n | String | srvPropInternal | Internal |
1.3.6.1.4.1.897.2.1.2.2..n | String | srvPropCharSet | CharSet |
1.3.6.1.4.1.897.2.1.2.3..n | String | srvPropCommandLine | CommandLine |
1.3.6.1.4.1.897.2.1.2.4..n | String | srvPropCompactPlatformVer | CompactPlatformVer |
1.3.6.1.4.1.897.2.1.2.5..n | String | srvPropCompanyName | CompanyName |
1.3.6.1.4.1.897.2.1.2.6..n | String | srvPropConnsDisabled* | ConnsDisabled |
1.3.6.1.4.1.897.2.1.2.7..n | String | srvPropConsoleLogFile | ConsoleLogFile |
1.3.6.1.4.1.897.2.1.2.8..n | String | srvPropDefaultCollation | DefaultCollation |
1.3.6.1.4.1.897.2.1.2.9..n | String | srvPropIdleTimeout | IdleTimeout |
1.3.6.1.4.1.897.2.1.2.10..n | String | srvPropIsIQ | IsIQ |
1.3.6.1.4.1.897.2.1.2.11..n | String | srvPropInternal | Internal |
1.3.6.1.4.1.897.2.1.2.12..n | String | srvPropIsNetworkServer | IsNetworkServer |
1.3.6.1.4.1.897.2.1.2.13..n | String | srvPropIsRuntimeServer | IsRuntimeServer |
1.3.6.1.4.1.897.2.1.2.14..n | String | srvPropInternal | Internal |
1.3.6.1.4.1.897.2.1.2.15..n | String | srvPropLanguage | Language |
1.3.6.1.4.1.897.2.1.2.16..n | String | srvPropLegalCopyright | LegalCopyright |
1.3.6.1.4.1.897.2.1.2.17..n | String | srvPropLegalTrademarks | LegalTrademarks |
1.3.6.1.4.1.897.2.1.2.18..n | String | srvPropLicenseCount | LicenseCount |
1.3.6.1.4.1.897.2.1.2.19..n | String | srvPropLicensedCompany | LicensedCompany |
1.3.6.1.4.1.897.2.1.2.20..n | String | srvPropLicensedUser | LicensedUser |
1.3.6.1.4.1.897.2.1.2.21..n | String | srvPropLicenseType | LicenseType |
1.3.6.1.4.1.897.2.1.2.22..n | String | srvPropLivenessTimeout* | LivenessTimeout |
1.3.6.1.4.1.897.2.1.2.23..n | String | srvPropMachineName | MachineName |
1.3.6.1.4.1.897.2.1.2.24..n | String | srvPropMaxMessage | MaxMessage |
1.3.6.1.4.1.897.2.1.2.25..n | String | srvPropMessageWindowSize | MessageWindowSize |
1.3.6.1.4.1.897.2.1.2.26..n | String | srvPropName | Name |
1.3.6.1.4.1.897.2.1.2.27..n | String | srvPropNativeProcessorArchitecture | NativeProcessorArchitecture |
1.3.6.1.4.1.897.2.1.2.28..n | String | srvPropNumPhysicalProcessors | NumPhysicalProcessors |
1.3.6.1.4.1.897.2.1.2.29..n | String | srvPropInternal | Internal |
1.3.6.1.4.1.897.2.1.2.30..n | String | srvPropOmniIdentifier | OmniIdentifier |
1.3.6.1.4.1.897.2.1.2.31..n | String | srvPropPageSize | PageSize |
1.3.6.1.4.1.897.2.1.2.32..n | String | srvPropPlatform | Platform |
1.3.6.1.4.1.897.2.1.2.33..n | String | srvPropPlatformVer | PlatformVer |
1.3.6.1.4.1.897.2.1.2.34..n | String | srvPropProcessCPU | ProcessCPU |
1.3.6.1.4.1.897.2.1.2.35..n | String | srvPropProcessCPUSystem | ProcessCPUSystem |
1.3.6.1.4.1.897.2.1.2.36..n | String | srvPropProcessCPUUser | ProcessCPUUser |
1.3.6.1.4.1.897.2.1.2.37..n | String | srvPropProcessorArchitecture | ProcessorArchitecture |
1.3.6.1.4.1.897.2.1.2.38..n | String | srvPropProductName | ProductName |
1.3.6.1.4.1.897.2.1.2.39..n | String | srvPropProductVersion | ProductVersion |
1.3.6.1.4.1.897.2.1.2.40..n | String | srvPropQuittingTime* | QuittingTime |
1.3.6.1.4.1.897.2.1.2.41..n | String | srvPropRememberLastStatement* | RememberLastStatement |
1.3.6.1.4.1.897.2.1.2.42..n | String | srvPropRequestFilterConn | RequestFilterConn |
1.3.6.1.4.1.897.2.1.2.43..n | String | srvPropRequestFilterDB | RequestFilterDB |
1.3.6.1.4.1.897.2.1.2.44..n | String | srvPropRequestLogFile* | RequestLogFile |
1.3.6.1.4.1.897.2.1.2.45..n | String | srvPropRequestLogging* | RequestLogging |
1.3.6.1.4.1.897.2.1.2.46..n | String | srvPropRequestLogMaxSize | RequestLogMaxSize |
1.3.6.1.4.1.897.2.1.2.47..n | String | srvPropStartTime | StartTime |
1.3.6.1.4.1.897.2.1.2.48..n | String | srvPropTempDir | TempDir |
1.3.6.1.4.1.897.2.1.2.49..n | String | srvPropMultiProgrammingLevel | MultiProgrammingLevel |
1.3.6.1.4.1.897.2.1.2.50..n | String | srvPropTimeZoneAdjustment | TimeZoneAdjustment |
1.3.6.1.4.1.897.2.1.2.51..n | String | srvPropHttpPorts | HttpPorts |
1.3.6.1.4.1.897.2.1.2.52..n | String | srvPropHttpsPorts | HttpsPorts |
1.3.6.1.4.1.897.2.1.2.53..n | String | srvPropProfileFilterConn | ProfileFilterConn |
1.3.6.1.4.1.897.2.1.2.54..n | String | srvPropProfileFilterUser | ProfileFilterUser |
1.3.6.1.4.1.897.2.1.2.55..n | String | srvPropRequestLogNumFiles | RequestLogNumFiles |
1.3.6.1.4.1.897.2.1.2.56..n | String | srvPropIsFipsAvailable | IsFipsAvailable |
1.3.6.1.4.1.897.2.1.2.57..n | String | srvPropFipsMode | FipsMode |
1.3.6.1.4.1.897.2.1.2.58..n | String | srvPropStartDBPermission | StartDBPermission |
1.3.6.1.4.1.897.2.1.2.59..n | String | srvPropServerName | ServerName |
1.3.6.1.4.1.897.2.1.2.60..n | String | srvPropRememberLastPlan | RememberLastPlan |
1.3.6.1.4.1.897.2.1.2.61..n | String | srvPropInternal | Internal |
1.3.6.1.4.1.897.2.1.2.62..n | String | srvPropInternal | Internal |
1.3.6.1.4.1.897.2.1.2.63..n | String | srvPropRequestTiming | RequestTiming |
1.3.6.1.4.1.897.2.1.2.64..n | String | srvPropCacheSizingStatistics | CacheSizingStatistics |
1.3.6.1.4.1.897.2.1.2.65..n | String | srvPropConsoleLogMaxSize | ConsoleLogMaxSize |
1.3.6.1.4.1.897.2.1.2.66..n | String | srvPropDebuggingInformation | DebuggingInformation |
1.3.6.1.4.1.897.2.1.2.67..n | String | srvPropMessage | Message |
1.3.6.1.4.1.897.2.1.2.68..n | String | srvPropMessageText | MessageText |
1.3.6.1.4.1.897.2.1.2.69..n | String | srvPropMessageTime | MessageTime |
1.3.6.1.4.1.897.2.1.2.70..n | String | srvPropIsRsaAvailable | IsRsaAvailable |
1.3.6.1.4.1.897.2.1.2.71..n | String | srvPropIsEccAvailable | IsEccAvailable |
1.3.6.1.4.1.897.2.1.2.72..n | String | srvPropMaxConnections | MaxConnections |
1.3.6.1.4.1.897.2.1.2.73..n | String | srvPropNumLogicalProcessors | NumLogicalProcessors |
1.3.6.1.4.1.897.2.1.2.74..n | String | srvPropNumLogicalProcessorsUsed | NumLogicalProcessorsUsed |
1.3.6.1.4.1.897.2.1.2.75..n | String | srvPropNumPhysicalProcessorsUsed | NumPhysicalProcessorsUsed |
1.3.6.1.4.1.897.2.1.2.76..n | String | srvPropDefaultNcharCollation | DefaultNcharCollation |
1.3.6.1.4.1.897.2.1.2.77..n | String | srvPropCollectStatistics | CollectStatistics |
1.3.6.1.4.1.897.2.1.2.78..n | String | srvPropFirstOption | FirstOption |
1.3.6.1.4.1.897.2.1.2.79..n | String | srvPropLastOption | LastOption |
1.3.6.1.4.1.897.2.1.2.80..n | String | srvPropLastConnectionProperty | LastConnectionProperty |
1.3.6.1.4.1.897.2.1.2.81..n | String | srvPropLastDatabaseProperty | LastDatabaseProperty |
1.3.6.1.4.1.897.2.1.2.82..n | String | srvPropLastServerProperty | LastServerProperty |
1.3.6.1.4.1.897.2.1.2.83..n | String | srvPropWebClientLogging | WebClientLogging |
1.3.6.1.4.1.897.2.1.2.84..n | String | srvPropWebClientLogFile | WebClientLogFile |
1.3.6.1.4.1.897.2.1.2.85..n | String | srvPropHttpNumConnections | HttpNumConnections |
1.3.6.1.4.1.897.2.1.2.86..n | String | srvPropHttpsNumConnections | HttpsNumConnections |
1.3.6.1.4.1.897.2.1.2.87..n | String | srvPropInternal | Internal |
1.3.6.1.4.1.897.2.1.2.88..n | String | srvPropHttpNumActiveReq | HttpNumActiveReq |
1.3.6.1.4.1.897.2.1.2.89..n | String | srvPropHttpsNumActiveReq | HttpsNumActiveReq |
1.3.6.1.4.1.897.2.1.2.90..n | String | srvPropHttpNumSessions | HttpNumSessions |
1.3.6.1.4.1.897.2.1.2.91..n | String | srvPropQueryMemPages | QueryMemPages |
1.3.6.1.4.1.897.2.1.2.92..n | String | srvPropQueryMemGrantBase | QueryMemGrantBase |
1.3.6.1.4.1.897.2.1.2.93..n | String | srvPropQueryMemGrantBaseMI | QueryMemGrantBaseMI |
1.3.6.1.4.1.897.2.1.2.94..n | String | srvPropQueryMemGrantExtra | QueryMemGrantExtra |
1.3.6.1.4.1.897.2.1.2.95..n | String | srvPropQueryMemActiveMax | QueryMemActiveMax |
1.3.6.1.4.1.897.2.1.2.96..n | String | srvPropQueryMemPercentOfCache | QueryMemPercentOfCache |
1.3.6.1.4.1.897.2.1.2.97..n | String | srvPropMessageCategoryLimit | MessageCategoryLimit |
1.3.6.1.4.1.897.2.1.2.98..n | String | srvPropInternal | Internal |
1.3.6.1.4.1.897.2.1.2.99..n | String | srvPropInternal | Internal |
1.3.6.1.4.1.897.2.1.2.100..n | String | srvPropIsService | IsService |
1.3.6.1.4.1.897.2.1.2.101..n | String | srvPropTcpIpAddresses | TcpIpAddresses |
1.3.6.1.4.1.897.2.1.2.102..n | String | srvPropHttpAddresses | HttpAddresses |
1.3.6.1.4.1.897.2.1.2.103..n | String | srvPropHttpsAddresses | HttpsAddresses |
1.3.6.1.4.1.897.2.1.2.104..n | String | srvPropInternal | Internal |
1.3.6.1.4.1.897.2.1.2.105..n | String | srvPropRemoteCapability | RemoteCapability |
1.3.6.1.4.1.897.2.1.2.106..n | String | srvPropMaxRemoteCapability | MaxRemoteCapability |
1.3.6.1.4.1.897.2.1.2.107..n | String | srvPropEventTypeName | EventTypeName |
1.3.6.1.4.1.897.2.1.2.108..n | String | srvPropEventTypeDesc | EventTypeDesc |
1.3.6.1.4.1.897.2.1.2.109..n | String | srvPropMaxEventType | MaxEventType |
1.3.6.1.4.1.897.2.1.2.110..n | String | srvPropInternal | Internal |
1.3.6.1.4.1.897.2.1.2.111..n | String | srvPropInternal | Internal |
1.3.6.1.4.1.897.2.1.2.112..n | String | srvPropServerEdition | ServerEdition |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |