|
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-level 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 |